PostgreSQL

GreptimeCloud exposes GreptimeDB access in PostgreSQL v3 wire protocol. Most standard clients and drivers are compatible at wire protocol level, and the connection is encrypted with TLS. Note that we don’t use Postgres’ SQL dialect in GreptimeDB, so there can be some statements that are unsupported. For more information, please refer to Postgresql documentation of GreptimeDB.

To connect to GreptimeCloud in Postgres wire protocol, using information below:

  • Host: <host>
  • Port: 4003
  • Database: <dbname>
  • Username: <username>
  • Password: <password>

psql

The default cli tool bundled with PostgreSQL.

  1. psql -h <host> -p 4003 -U <username> -d <dbname> -W

Postgres Connection String

Using the connection string below for compatible client libraries like psycopg, rust-postgres and more.

  1. host=<host> port=4003 dbname=<dbname> user=<username> password=<password>

URL

Using the URL below with your Postgres JDBC client.

  1. jdbc:postgresql://<host>:4003/<dbname>?user=<username>&password=<password>&ssl=true

If you are using clients from Python, you might be able to use following URL

  1. postgresql://<username>:<password>@<host>:4003/<dbname>