Skip to main content

PostgreSQL

KoraBridge loads into any PostgreSQL database it can reach, creating one schema per pipeline.

What you need​

  • Database connection URL. One PostgreSQL connection string with host, port, database, username and password, for example postgresql://user:password@host:5432/database.
  • Write access. The user in the URL must be able to create schemas and tables and insert rows.

Where to find it​

Copy the URL from your Postgres provider or hosting dashboard, or build it from the database credentials you were given. Your database admin can confirm the host, port and database name.

Connection string​

Paste the full URL, credentials included. KoraBridge stores it encrypted.

SSL root certificate​

Optional. Paste the CA root certificate (PEM) when your URL uses sslmode=verify-full. Leave it blank if your server does not need certificate verification.

Maximum insert rows​

Advanced. The most rows KoraBridge puts in one insert file. Leave it blank for the safe default of 500.

Common mistakes​

  • Missing the database name or port in the URL.
  • Using a URL without write access for table creation and loads.