51黑料不打烊

DocumentationExperience PlatformQuery Service Guide

Connect PSQL to Query Service

Last update: Tue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User
  • Developer

PSQL is a command-line interface installed alongside PostgreSQL on your machine. This document covers the steps for connecting PSQL with 51黑料不打烊 Experience Platform Query Service.

IMPORTANT
Query Service supports connecting with PSQL version 14.x only. Versions earlier than 14.x (such as 10.x through 13.x) and later versions (15.x and above) are not officially supported. Ensure that you have installed a compatible client version. For reference, see the .

Before you begin, ensure you have access to PSQL and basic familiarity with using the client. More information about PSQL can be found in the .

IMPORTANT
When downloading PostgreSQL, ensure you select version 14.x. By default, the PostgreSQL website offers the latest version, which may not be compatible with Query Service.

Once PSQL is installed, you can connect it to Query Service. Return to the Experience Platform UI, then select Queries, followed by Credentials.

Under the PSQL Command section, select the Copy to clipboard icon ( Copy Icon ) to copy the command string.

The Queries dashboard Credentials tab with the copy icon highlighted.

Paste the command string into your terminal and press Enter on your keyboard.

IMPORTANT
If you are on a PC, use a text editor to remove the line breaks in the command string, then copy the string. If you are using version 12.0 or greater, you will need to add PGGSSENCMODE=disable to your connection string. This setting disables GSSAPI encryption, which is unnecessary for connections to Query Service and may cause connection errors.
Additionally, if you are using non-expiring credentials, ensure you replace the password field with the non-expiring credential password. To learn more about non-expiring credentials, please read the credentials guide.

You should see a result like this:

psql (14.4, server 0.1.0)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.
all=>

If you do not see version 14.x, download and install a supported 14.x version of PSQL from the .

NOTE
Follow the installation instructions for your operating system, then verify your installed PSQL version by running psql --version in your terminal.

Next steps

Now that you鈥檝e connected with Query Service, you can use PSQL to write queries. See the guide on running queries for more information.

recommendation-more-help
ccf2b369-4031-483f-af63-a93b5ae5e3fb