> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# PostgreSQL

> Landing page for the PostgreSQL migrations section

| Page                                                                                                | Description                                                                                                                                                                                                                                                                                                    |
| --------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [Overview](/get-started/migrate/postgres/overview)                                                  | Introduction page for this section                                                                                                                                                                                                                                                                             |
| [Connecting to PostgreSQL](/snippets/connecting-to-postgresql)                                      | This page covers the following options for integrating PostgreSQL with ClickHouse: ClickPipes, PeerDB, PostgreSQL table engine, MaterializedPostgreSQL database engine.                                                                                                                                        |
| [Migrating data](/get-started/migrate/postgres/migration-guide/migration-guide-part1)               | Part 1 of a guide on migrating from PostgreSQL to ClickHouse. Using a practical example, it demonstrates how to efficiently carry out the migration with a real-time replication (CDC) approach. Many of the concepts covered are also applicable to manual bulk data transfers from PostgreSQL to ClickHouse. |
| [Rewriting PostgreSQL Queries](/get-started/migrate/postgres/migration-guide/migration-guide-part2) | Part 2 of a guide on migrating from PostgreSQL to ClickHouse. Using a practical example, it demonstrates how to efficiently carry out the migration with a real-time replication (CDC) approach. Many of the concepts covered are also applicable to manual bulk data transfers from PostgreSQL to ClickHouse. |
| [Data modeling techniques](/get-started/migrate/postgres/migration-guide/migration-guide-part3)     | Part 3 of a guide on migrating from PostgreSQL to ClickHouse. Using a practical example, it demonstrates how to model data in ClickHouse if migrating from PostgreSQL.                                                                                                                                         |
| [Appendix](/get-started/migrate/postgres/appendix)                                                  | Additional information relevant to migrating from PostgreSQL                                                                                                                                                                                                                                                   |