Configure postgresql tcp11/11/2023 Welcome to psql 8.1.11 (server 8.4.18), the PostgreSQL interactive terminal.Īlso, if you don’t want to specify the hostname in the command line parameter every time, you can setup the remote PostgreSQL database ip-address in PGHOST environment variable name as shown below. Now, login to the client machine 192.168.101.20, and perform the psql remote connection to the PostgreSQL database server (192.168.102.1) as shown below. If you have multiple interfaces on the server, you can also specify a specific interface to be listened. On the PostgreSQL database server, by default, the listen address will be localhost in the nf file as shown below. The PostgreSQL server accepts connection by client program over the TCP/IP network.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |