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.
Icon/Social/001 Icon/Social/006 Icon/Social/005 Icon/Social/004 Icon/Social/002