PgDAC and PostgreSQL Cloud services

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
gside
Posts: 9
Joined: Mon 02 Dec 2019 17:22

PgDAC and PostgreSQL Cloud services

Post by gside » Mon 02 Dec 2019 17:35

Hi,

Is there any specific requirement when using a Postgres database hosted at a cloud provider (like enterprisedb or heroku), using PgDAC and SecureBridge?

I never used such architecture, so sorry for these basic questions:
- is connection to these cloud providers similar to regular C/S setup: setup and use a TLS connection, provide the server IP address, and use the embedded PgDAC client? or is an ODBC driver required?
- is there any recommendation when using PgDAC with a cloud database, regarding performances and reliability?

Any feedback is welcome,
Thanks,

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: PgDAC and PostgreSQL Cloud services

Post by MaximG » Wed 04 Dec 2019 15:41

1. Using our product a PostgreSQL database hosted at a cloud provider is no different from using a regular PostgreSQL database and doesn't require any external libraries or ODBC drivers.
The connection instructions are provided in our documentation:

https://www.devart.com/pgdac/docs/loggingserver.htm
https://www.devart.com/pgdac/docs/secureconnections.htm

2. PgDAC doesn't have any dedicated options for cloud instances of the database. In your particular case, it is recommended to use a special Disconnected Mode:

https://www.devart.com/pgdac/docs/unstable_network.htm

Post Reply