> ## 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

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

## PostgreSQL コネクタを追加

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

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

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

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

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

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

## PostgreSQL への認証

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

**Server:** Enter the host name or IP of the server that hosts the PostgreSQL database. The default server value is **localhost**.

CData Sync supports authenticating to PostgreSQL in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

* [**Password**](#password) (default)
* [**Azure Active Directory**](#azure-active-directory)
* [**Azure Password**](#azure-password)
* [**Azure Managed Service Identity**](#azure-managed-service-identity)
* [**Aws IAM Roles**](#aws-iam-roles)
* [**Aws EC2 Roles**](#aws-ec2-roles)
* [**GCP Service Account**](#gcp-service-account)

### Password

To connect with user credentials, specify the following properties:

* **Auth Scheme:** Select **Password**.
* **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.

### Azure Active Directory

To connect with Azure Active Directory, specify the following properties:

* **Auth Scheme:** Select **AzureAD**.
* **User:** Enter the username that you use to authenticate to your PostgreSQL account.
* **Azure Tenant:** Enter the Microsoft Online tenant to which you want to connect. If you do not specify the tenant, CData Sync uses the default tenant.
* **OAuth Client Id:** Enter the client Id that you were assigned when you registered your application with an OAuth authorization server.
* **OAuth Client Secret:** Enter the client secret that you were assigned when you registered your application with an OAuth authorization server.

### Azure Password

To connect with Azure user credentials, specify the following properties:

* **Auth Scheme:** Select **AzurePassword**.
* **User:** Enter the username that you use to authenticate to your Azure account.
* **Password:** Enter the password that you use to connect to your Azure account.
* **Azure Tenant:** Enter the Microsoft Online tenant to which you want to connect. If you do not specify a tenant, CData Sync uses the default tenant.

### Azure Managed Service Identity

To connect with Azure Managed Service Identity, specify the following properties:

* **Auth Scheme:** Select **AzureMSI**.
* **User:** Enter the username that you use to authenticate to your PostgreSQL account.

### Aws IAM Roles

To connect with IAM user credentials, specify the following properties:

* **Auth Scheme:** Select **AwsIAMRoles**.
* **User:** Enter the username that you use to authenticate to your PostgreSQL account.
* **AWS Access Key:** Enter your Amazon Web Services (AWS) account access key. This value is available on you AWS security-credentials page.
* **AWS Secret:** Enter your Amazon Web Services (AWS) account secret. This value is available on you AWS security-credentials page.
* **AWS Role Arn:** Enter the Amazon Resource Name of the role that you want to use when you authenticate.
* (Optional) **AWS External Id:** Enter a unique identifier that might be required when you assume a role in another account.

### AWS EC2 Roles

EC2 インスタンスでCData Sync を実行すると、CData Sync はインスタンスに割り当てられたIAM ロールを使用して認証できます。そのロールを使用するには、**Auth Scheme** で**AwsEC2Roles** を選択します。追加のプロパティは必要ありません。

### GCP Service Account

To connect with a GCP service account, specify the following properties:

* **Auth Scheme:** Select **GCPServiceAccount**.
* **OAuth JWT Cert:** Enter your Java web tokens (JWT) certificate store.
* **OAuth JWT Cert Type:** Enter the type of key store that contains your JWT Certificate. The default type is **PEMKEY\_BLOB**.
* (Optional) **OAuth JWT Cert Password:** Enter the password for your OAuth JWT certificate.
* (Optional) **OAuth JWT Cert Subject:** Enter the user subject for which the application is requesting delegated access.

## 接続を完了する

To complete your connection:

1. Specify these settings:
   * **Database:** Enter the name of the database that to which you want to connect when you connect to the PostgreSQL server.
   * **Port:** Enter the port number of the server that hosts the PostgreSQL database. The default port value is **5432**.
2. Define advanced connection settings on the **Advanced** tab. (In most cases, though, you should not need these settings.)
3. If you authenticate with AzureAD, AzurePassword, AzureMSI, or GCPServiceAccount, click **Connect to PostgreSQL** to connect to your PostgreSQL account.
4. Click **Create & Test** to create your connection.

## 詳細について


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