Client Information
A PSQL Client on Linux or OS X can connect to any of the PSQL Servers provided the client and server machines can communicate with a shared protocol.
Authentication to Remote Machines
To connect to a remote machine using the Linux or OS X client, you need to have authentication to the remote machines. This is accomplished by entering a specific user name and password for the server using the pvnetpass utility. This utility stores the user name and password in an encrypted format for that particular server in the PSQL registry on the client machine. If you do not specify user names and passwords, your applications can receive status code 3119.
See
pvnetpass
in
PSQL User's Guide
.
Creating a Client DSN
A client data source name (DSN) is required if applications on the client use the PSQL Relational Engine through ODBC. To create a client DSN, you use the dsnadd utility included with the PSQL Client. See
dsnadd
in
PSQL User's Guide
and the man page for dsnadd located in
/usr/local/psql/man/man1
.