Integrate PostgreSQL with Timescale Cloud

You use PostgreSQL foreign data wrappers (FDWs) to query external data sources from a Timescale Cloud service. These external data sources can be one of the following:

• Other Timescale Cloud services
• PostgreSQL databases outside of Timescale Cloud

If you are using VPC peering, you can create FDWs in your Customer VPC to query a service in your Timescale Cloud project. However, you can't create FDWs in your Timescale Cloud services to query a data source in your Customer VPC. This is because Timescale Cloud VPC peering uses AWS PrivateLink for increased security. See VPC peering documentation for additional details.

PostgreSQL FDWs are particularly useful if you manage multiple Timescale Cloud services with different capabilities, and need to seamlessly access and merge regular and time-series data.

Before integrating:

• Create a target Timescale Cloud service

  You need your connection details to follow the steps in this page. This procedure also works for self-hosted TimescaleDB.

To query another data source: