How to add remote PostgreSQL database
Question:
I have 1C:Enterprise Server installed on my local computer and I want to add the PostgreSQL database located remotely on the Virtual Machine hosted in the cloud of my hosting provider. Could you help me figure out what Database server parameter I need to specify in the Add Infobase or folder window?
Answer:
To set up a direct connection between your local site and the PostgreSQL server, you must configure a client application. There are several PostgreSQL client applications available, but for all of them, you must provide the following information to establish a remote connection:
- The name of the remote server (for example, a2ss42.a2hosting.com).
- The port of the remote server (this is always 5432).
- The PostgreSQL database name.
- The PostgreSQL database username.
- The PostgreSQL database password.