homehome previousprevious nextnext
 
Remote Connection Settings

You can connect to your PostgreSQL Server remotely by filling in the information below under General tab.

  • Host name/IP address: IP of Remote PostgreSQL Server
  • Port: 5432
  • User name: Your Username (postgres as default)
  • Password: Your Password (<blank> as default)

If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol SSH / HTTP is another solution.

Note: For security reasons native remote direct connections to the PostgreSQL server are disabled. Therefore, you may not be able to use Navicat PostgreSQL or other similar PostgreSQL admin applications running on your computer to connect to the remote server. For more details, refer to next paragraph on Server Administration.

For Server Administration:
By default, PostgreSQL only allows connections from the local machine using TCP/IP connections. Other machines will not be able to connect unless you modify listen_addresses in the postgresql.conf file, enable host-based authentication by modifying the $PGDATA/pg_hba.conf file, and restart the server. For more information: Client Authentication

See also:
General Settings

Related topics:
Manage Users


 

 

 

 

 

 

 

 

 

 

Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
PGSQL TM is a trademark of PGSQL AB in the United States and other countries.