Yes, it works with pgBouncer, which is recommended in production. Centia.io will connect to pg/pgBouncer with different PG user creds, so pgBouncer must be configured for that. You can also use whatever managed PG service you like.