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,
PgDAC and PostgreSQL Cloud services
Re: PgDAC and PostgreSQL Cloud services
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
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