> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sync.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# PostgreSQL (Native)

CData Sync アプリケーションからPostgreSQL コネクタを使用して、PostgreSQL からデータを取得してサポートされている任意の同期先に移動できます。これを行うには、コネクタを追加し、コネクタへの認証を行い、接続を完了する必要があります。

> [!NOTE]
>
> This connection can be used only as a source for the **Change Data Capture** job type.

## Prerequisites

Before you add and set up the PostgreSQL source connector, you need to set up PostgreSQL for change data capture (CDC), as explained in the following sections.

### Minimum Requirements

Before you set up PostgreSQL for CDC, ensure that you have the following minimum requirements:

* **PostgreSQL Version:** Version 12 or later

  > [!NOTE]
  >
  > Only databases with the UTF-8 character encoding are supported for CDC. Strings that contain extended ASCII characters might not be processed correctly during the incremental replication.

* **User Privileges:** LOGIN and REPLICATION (the minimum privileges that are required for connecting to PostgreSQL and reading the replication slot)

### Set Up PostgreSQL for CDC

Perform the following steps to enable logical replication, specify which tables to replicate, and create a logical replication slot for Sync.

1. Ensure that the `wal_level` parameter is set in your PostgreSQL database, as follows:

   1. Verify the current `wal_level` setting in PostgreSQL by submitting the following query:

      ```
      SHOW wal_level;
      ```

   2. Set the `wal_level` parameter to enable logical replication in either of the following ways:

      **Method 1:** Execute the following command:

      `ALTER SYSTEM SET wal_level = logical;`

      **Method 2:** Set `wal_level = logical` manually in your PostgreSQL file, as shown below:

      ```
      # REPLICATION
      wal_level = logical   
      ```

   > [!NOTE]
   >
   > Regardless of which method you use, you **must restart the PostgreSQL database** for the changes to take effect.

2. Create a publication to specify which tables to replicate.

   ```
   CREATE PUBLICATION cdatasync_pub1 FOR TABLE table1, table2, ...;
   ```

   You can also create a publication for all tables in the database, as shown below.

   ```
   CREATE PUBLICATION cdatasync_pub1 FOR ALL TABLES;
   ```

   > [!NOTE]
   >
   > SUPERUSER privileges are required when you create a publication for all tables.

3. Create a logical replication slot for Sync by submitting the following SELECT statement:

   ```
   SELECT pg_create_logical_replication_slot('SlotName', 'pgoutput');
   ```

   > [!NOTE]
   >
   > When you create the logical replication slot, you must use the `pgoutput` plugin.

## PostgreSQL コネクタを追加

Sync でPostgreSQL のデータを使用できるようにするには、まず以下の手順でコネクタを追加する必要があります：

<ol>
  <li>Sync のダッシュボードから**接続**ページを開きます。</li>
  <li>**接続を追加**をクリックして**コネクタを選択**ページを開きます。</li>
  <li>**データソース**タブをクリックして
  **PostgreSQL (Native)** 行に移動します。</li>

  <li>
    行末にある**接続を設定**アイコンをクリックして、**新しい接続**ページを開きます。この操作により、
    **接続を追加**ダイアログボックスが開きます。

    **Note：** **接続を設定**アイコンが表示されない場合は、**コネクタをダウンロード**アイコンをクリックして PostgreSQL (Native) コネクタをインストールしてください。
  </li>

  <li>**接続を追加**ダイアログボックスに接続名を入力します。</li>
  <li>**追加**をクリックして、コネクタの**設定**タブを開きます。</li>
</ol>

新しいコネクタのインストールについての詳細は、
[接続](https://docs.sync.cdata.com/26.2/ja/connections/connections.md)を参照してください。

## PostgreSQL への認証

After you add the connector, you need to set the required properties.

* **Host:** Enter the host name or IP of the server that hosts the PostgreSQL database. The default server value is **localhost**.
* **Port:** Enter the port number of the server that hosts the PostgreSQL database. The default port value is **5432**.
* **Database:** Enter the name of the database that to which you want to connect when you connect to the PostgreSQL server. The default database is **postgres**.
* **User:** Enter the username that you use to authenticate to your PostgreSQL account.
* **Password:** Enter the password that you use to authenticate to your PostgreSQL account.

## 接続を完了する

To complete your connection:

1. Define advanced connection settings on the **Advanced** tab. (In most cases, though, you should not need these settings.)
2. Click **Create & Test** to create your connection.

## 詳細について

CData Sync とPostgreSQL の連携について、詳しくは
[PostgreSQL Connector for CData Sync](https://cdn.cdata.com/help/FPM/jp/synch/default.htm) を参照してください。


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.