TimescaleDB v2.9 Documentation
首页 白天 夜间 下载 阅读记录
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签
编辑文档

Connecting to TimescaleDB

来源 1 浏览 277 扫码 打印 2022-12-25 22:18:32

    Connecting to TimescaleDB

    • Learn about connecting to your database to understand how it works before you begin.
    • Install .
    • Install and use DBeaver.
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • Getting started
      • Create a continuous aggregate
        • Continuous aggregate basics
        • Continuous aggregate policies and refreshing data
      • Add time-series data
      • Next steps
      • Learn about data retention
      • Create a hypertable
      • Query your data
      • Save space with compression
    • Timescale Cloud
      • Integrations
      • Security
        • Connect with a stricter SSL mode
        • Security overview
      • High availability
      • Service logs
      • Members
        • Members list
      • Multi-node
      • Billing
        • Account management
      • PostgreSQL extensions
      • Service explorer
      • Troubleshooting
      • Service overview
      • Service metrics
      • Services
        • Create a service demo
        • Create a service
      • Service operations
        • Replication
        • Autoscale
        • Resources
        • VPC
        • Service management
        • Maintenance
        • Database parameters
          • Customize configuration
          • Advanced parameters
      • Migrate a TimescaleDB database to Cloud
        • Migrate schema and data separately
        • Migrate the entire database at once
      • Data tiering
        • Tier data to object storage
      • Backup and restore
    • Managed Service for TimescaleDB
      • Supported extensions
      • Aiven Client for Managed Service for TimescaleDB
        • Send Grafana emails using Aiven Client
        • Integrate authentication plugins in Grafana
        • Create a read-only replica using Aiven Client
        • Create a fork of the service using Aiven Client
        • Install Aiven Client for Managed Service for TimescaleDB
      • Integrate Managed Service for TimescaleDB as a data source in Grafana
      • Clouds and regions
      • Viewing service logs
      • Connection pools
      • Integrate Managed Service for TimescaleDB and Google Data Studio
      • Using REST API on Managed Service for TimescaleDB
      • Troubleshooting
      • Send metrics to Datadog
      • Create a multi-node cluster
      • Migrate your data to Managed Service for TimescaleDB
      • Ingest data
      • Backups
      • User management
      • Failover
      • Billing
      • Security
      • Create a replica for PostgreSQL service
      • Logging
      • Maintenance
      • VPC peering
      • Migrate your data to Timescale Cloud
      • About Managed Service for TimescaleDB
    • API Reference
      • Hypertables & chunks
        • chunks_detailed_size
        • detach_tablespace
        • add_reorder_policy
        • hypertable_index_size
        • add_dimension
        • detach_tablespaces
        • set_integer_now_func
        • create_hypertable
        • drop_chunks
        • hypertable_size
        • reorder_chunk
        • hypertable_detailed_size
        • set_chunk_time_interval
        • remove_reorder_policy
        • move_chunk
        • show_chunks
        • show_tablespaces
        • attach_tablespace
        • create_index (transaction per chunk)
      • Distributed hypertables
        • create_distributed_hypertable
        • detach_data_node
        • attach_data_node
        • distributed_exec
        • set_replication_factor
        • create_distributed_restore_point
        • copy_chunk
        • set_number_partitions
        • move_chunk
        • delete_data_node
        • add_data_node
        • cleanup_copy_chunk_operation
      • Continuous aggregates
        • ALTER MATERIALIZED VIEW (Continuous Aggregate)
        • cagg_migrate
        • CREATE MATERIALIZED VIEW (Continuous Aggregate)
        • refresh_continuous_aggregate
        • remove_continuous_aggregate_policy
        • remove_policies
        • add_continuous_aggregate_policy
        • remove_all_policies
        • show_policies
        • alter_policies
        • add_policies
        • DROP MATERIALIZED VIEW (Continuous Aggregate)
      • Administration Functions
        • timescaledb_pre_restore
        • dump_meta_data
        • timescaledb_post_restore
        • get_telemetry_report
      • Compression
        • compress_chunk
        • recompress_chunk
        • chunk_compression_stats
        • remove_compression_policy
        • ALTER TABLE (Compression)
        • add_compression_policy
        • decompress_chunk
        • hypertable_compression_stats
      • Actions and automation
        • alter_job
        • add_job
        • run_job
        • delete_job
      • API Reference Tag Overview
      • Configuration
      • Data retention
        • remove_retention_policy
        • add_retention_policy
      • Hyperfunctions
        • first
        • days_in_month
        • Downsample
          • gp_lttb
          • lttb
          • asap
        • last
        • Frequency Analysis
          • min_frequency / max_frequency
          • freq_agg
          • count_min_sketch
          • approx_count
          • topn
          • into_values (for freq_agg)
          • topn_agg
        • time_bucket_ng
        • time_bucket
        • Metric aggregation (counters and gauges)
          • delta
          • corr
          • first_time, last_time
          • counter_zero_time
          • rollup
          • irate
          • num_changes
          • intercept
          • interpolated_rate
          • counter_agg (point form)
          • with_bounds
          • num_resets
          • time_weight
          • slope
          • gauge_agg
          • idelta
          • extrapolated_delta
          • time_delta
          • rate
          • num_elements
          • extrapolated_rate
          • first_val, last_val
          • interpolated_delta
        • Gapfilling and interpolation
          • interpolate
          • percentile_agg and uddsketch
          • tdigest
          • time_bucket_gapfill
          • locf
        • month_normalize
          • hyperloglog
        • Saturating math
          • ohlc
          • saturating_add
          • saturating_sub
          • max_n
          • stats_agg (one variable)
          • min_n_by
          • saturating_sub_pos
          • candlestick_agg
          • max_n_by
          • min_n
          • stats_agg (two variables)
          • saturating_mul
          • saturating_add_pos
        • approximate_row_count
        • State aggregates
          • state_agg
          • state_timeline
          • interpolated_state_timeline
          • state_periods
          • interpolated_duration_in
          • duration_in
          • interpolated_state_periods
          • into_values (for state_agg)
          • rollup (for state_agg)
          • heartbeat_agg
        • histogram
      • Informational views
        • timescaledb_experimental.policies
        • timescaledb_information.continuous_aggregates
        • timescaledb_information.compression_settings
        • timescaledb_information.chunks
        • timescaledb_information.jobs
        • timescaledb_information.hypertables
        • timescaledb_information.job_stats
        • timescaledb_information.data_nodes
        • timescaledb_information.dimensions
    • Promscale
      • Recommendations
        • Resource recommendation guide
        • Configuration recommendation guide
      • Promscale CLI reference
      • Downsample data
        • Recording Rules
        • Continuous Aggregates
      • tobs
        • Install
        • About tobs
      • Alert in Promscale
      • Promscale benefits
      • Quick start
      • About Promscale
      • Manage data in Promscale
        • Maintenance jobs
        • Compression
        • Retention
        • Delete data
      • Visualize data in Promscale
        • Jaeger
        • Grafana
        • Application Performance Monitoring (APM)
      • Troubleshooting Promscale
      • SQL API functions reference
      • Install Promscale
        • Debian or Ubuntu
        • Binary
        • Docker
        • Promscale with Timescale cloud
          • Kubernetes
          • Binary
          • Docker
        • RPM based Linux (Red Hat or CentOS)
        • Kubernetes
      • Backup and Restore Promscale
      • Scale Promscale
        • Prometheus High availability
        • Prometheus multi-tenancy
      • Query data in Promscale
        • Query metrics
        • Query traces
      • How-to Guides
        • Migrate existing data
        • Upgrade Promscale
      • Monitor Promscale
      • Send data to Promscale
        • OpenTelemetry
        • Jaeger
        • Remote write API
        • Zipkin
        • Prometheus
      • Database roles and permissions
    • TimescaleDB
      • How-to Guides
        • Upgrade TimescaleDB
          • About upgrades
          • Upgrade PostgreSQL
          • Upgrade within Docker
          • Downgrade TimescaleDB
          • Troubleshooting upgrades
          • Minor upgrades
          • Major upgrades
        • Query data
          • Perform advanced analytic queries
          • SELECT data
          • Troubleshooting
          • About querying data
          • Perform DISTINCT queries with SkipScan
        • Connecting to TimescaleDB
          • About connecting to TimescaleDB
          • Install psql
          • Connect using Azure Data Studio
          • Connect using DBeaver
          • About psql
          • Install pgAdmin
        • Distributed hypertables
          • Create distributed hypertables
          • About distributed hypertables
          • Create foreign keys on distributed hypertables
          • Insert data
          • Use triggers in distributed hypertables
          • Alter and drop distributed hypertables
          • Query data
          • Troubleshooting
        • Configuration
          • Troubleshooting
          • About Configuration
          • TimescaleDB configuration
          • Using timescaledb-tune
          • Telemetry
          • Manual PostgreSQL configuration
          • Docker configuration
        • Data retention
          • Create a retention policy
          • About data retention
          • About data retention with continuous aggregates
          • Troubleshooting data retention
          • Manually drop chunks
        • Multi-node
          • Multi-node setup on TimescaleDB
          • Multi-node administration
          • Multi-node authentication
          • Grow and shrink a multi-node cluster
          • About multi-node
          • High availability multi-node
          • Multi-node maintenance
          • Configure multi-node
        • Troubleshoot TimescaleDB
        • Data migration
          • About data migration
          • Import from CSV
          • Troubleshoot data migration
          • Migrate from a different database
          • Migrate InfluxDB data
          • Migrate from the same database
        • Additional tooling
          • Install and use timescaledb-parallel-copy
          • About timescaledb-tune
        • Continuous aggregates
          • Create a continuous aggregate
          • Compress continuous aggregates
          • Time in continuous aggregates
          • Drop data from continuous aggregates
          • Create an index on a continuous aggregate
          • Real time aggregates
          • Troubleshoot continuous aggregates
          • About continuous aggregates
          • Manage materialized hypertables
          • Migrate a continuous aggregate to the new form
          • Refresh policies for continuous aggregates
        • Schema management
          • About indexing
          • About tablespaces
          • Index
          • Alter hypertables
          • Triggers
          • Manage storage using tablespaces
          • About constraints
          • About schemas
          • JSON
        • Compression
          • Decompress chunks
          • About compression
          • Manually compress chunks
          • Backfill historical data
          • Modify a schema
          • Troubleshooting
        • Uninstall TimescaleDB
          • Uninstall TimescaleDB on macOS
        • Hypertables
          • About hypertables
          • Create hypertables
          • Create unique indexes on hypertables
          • Change hypertable chunk intervals
          • Alter hypertables
          • Drop hypertables
          • Troubleshoot hypertables
        • User-defined actions
          • Use an action for generic retention
          • About user-defined actions
          • Test and debug a user-defined action
          • Use an action for downsampling and compression
          • Use an action for tablespace management
          • Use an action to backfill data periodically
          • Alter and delete a user-defined action
          • Troubleshooting
          • Create and register a user-defined action
        • Replication and High Availability
          • Configure replication
          • About high availability
        • Time buckets
          • About time buckets
          • Use time buckets to group time-series data
        • Write data
          • Delete data
          • Upsert data
          • About writing data
          • Insert data
          • Update data
        • Alerting
        • Backup and restore
          • Physical backups
          • Docker & WAL-E
          • Using pg_dump/pg_restore
          • Troubleshooting
        • Hyperfunctions
          • Statistical aggregates
          • Function pipelines
          • Approximate count distincts
            • Hyperloglog
          • Counter aggregation
            • Counter aggregates
          • Install and update TimescaleDB Toolkit
          • Gapfilling and interpolation
            • Last observation carried forward
            • Time bucket gapfill
          • Percentile approximation
            • Approximate percentile
            • Advanced aggregation methods
          • Time-weighted averages
            • Time-weighted averages
          • About hyperfunctions
          • Troubleshoot hyperfunctions
        • Ingest data from other sources
          • Ingesting data with Telegraf
          • Ingesting data with Prometheus
          • Ingesting data with TimescaleDB parallel copy
          • Ingesting data with Kafka
          • About ingesting data from other sources
      • Contribute to documentation
      • Code quick starts
        • Ruby
        • Python
        • Java
        • C# .Net
        • Golang
        • Node.js
      • Overview
        • How does it compare?
          • Comparison with PostgreSQL
          • Comparison with NoSQL
        • What is time-series data?
        • Deployment options
        • Release notes
          • Changes in TimescaleDB 2.0
        • Limitations
        • Data model flexibility
        • FAQs
          • FAQs: Time-series databases
          • FAQs: PostgreSQL
          • FAQs: Using TimescaleDB
          • FAQs: Community
          • FAQs: Products
        • TimescaleDB on Kubernetes
        • Core concepts
          • Distributed hypertables
          • Scaling
          • Hypertables and chunks
            • Benefits of hypertables
            • Hypertable architecture
          • Continuous aggregates
          • Data retention
          • Backup and restore
          • User-defined actions
          • Compression
            • Compression architecture
      • Compare TimescaleDB Editions
      • Tutorials
        • Visualize data in Tableau
        • Analyze data using hyperfunctions
          • Join time-series and relational data
          • Visualize time-series data
          • Analyze data using SQL and hyperfunctions
          • Ingest and query data
        • Analyze NFT sales data
          • Analyzing NFT transactions
          • NFT schema design and ingestion
        • TimescaleDB with AWS Lambda
          • Create a data API for TimescaleDB
          • Continuous deployment with GitHub actions
          • Pull and ingest data from a third party API
        • Custom TimescaleDB dashboards
        • Simulate IoT sensor data
        • Store financial tick data in TimescaleDB
          • Query the candlestick views
          • Create candlestick aggregates
          • Advanced data management
          • Design schema and ingest tick data
        • Analyze cryptocurrency data
        • Ingest real-time financial websocket data
        • Grafana
          • Connect TimescaleDB and Grafana
          • Create a dashboard and panel
          • Visualize missing data
          • Build Geospatial dashboards
          • Use Grafana variables
          • Setup Grafana on Managed Service for TimescaleDB
          • Setup alerts
          • Visualizations
            • Bar chart
            • Candlestick
            • Histograms
            • Pie chart
            • Time-series
        • Collect metrics with Telegraf
        • Monitor a Django application with Prometheus
        • Monitor MST with Prometheus
        • Sample datasets
        • Introduction to time-series forecasting
        • Analyze intraday stock data
          • Explore stock market data
          • Fetch and ingest stock data
          • Design database schema
        • Introduction to time-series data
          • Time-series tutorial - set up
          • Time-series tutorial - query data
          • Time-series tutorial - advanced queries
        • Analyze the Bitcoin blockchain
          • Analyze the blockchain with hyperfunctions
          • Ingest and query Bitcoin transactions
      • Contribute to TimescaleDB
    • Install TimescaleDB
      • Managed Service for TimescaleDB
      • Kubernetes
      • Pre-built containers
      • Self hosted
        • Arch Linux
        • MacOS
        • RHEL/CentOS
        • Debian/Ubuntu
        • From source
        • Windows
      • Troubleshooting
      • Timescale Cloud
      • Pre-built cloud images
    暂无相关搜索结果！

      本文档使用 全库网 构建

      展开/收起文章目录

      思维导图备注

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档

      书签列表

        阅读记录

        阅读进度: 0.00% ( 0/0 ) 重置阅读进度