Click Connections button from the main screen. Enter the name you wish to associate the connection with in Connection Name (this name will be used to indicate the connection in the Server Navigator). Enter either the hostname or IP address of you PostgreSQL server in Host name. Enter the port number into Port (5432 is the default port number on which PostgreSQL runs). Provide the user name and password for the connection in User name and Password. Click the Save button to save your changes. The connection you have just set up should be displayed in the Server Navigator , Double click on the connection item to open your connection to the server. Remember that you can set up and open connections to multiple servers in Navicat.


Tips for using PostgreSQL server for the first time

The following information is some tips that would assist you to start your PostgreSQL server for first time:

1. PostgreSQL database download URL : http://www.postgresql.org/download/

After you intalled PostgreSQL on your computer, please open Terminal program. Please try to use the following command to start the server:
For e.g.,
i.) cd /usr/local/pgsql
ii.) bin/pg_ctl start

2. Localhost connection setting

Navicat Localhost Connection Setting is similiar as following :
Connection name : <It can be any name. The connection name will be shown in left panel of Navicat main screen>
Host : localhost
Username : postgres
Password : ******
Port : 5432 (default)

Before you established local connection between Navicat and your local PostgreSQL server, please firstly start your local PostgreSQL server.

3. Remote Connection setting

Please enable remote connections function while installation or configure postgresql.conf for setting remote access

Navicat Remote Connection Setting is similiar as following :

Connection name : <It can be any name. The connection name will be shown in left panel of Navicat main screen>
Host : IPaddress of remote PostgreSQL server
Username : Your_username
Password : Your_password
Port : 5432 (default)


4. SSH Tunnel

Does your remote server supports SSH connection? If yes, you can use Navicat to connect with your remote PostgreSQL server via a SSH tunnel.

It's not necessary to modify your existing PostgreSQL Privileges setting.

For SSH Tunnel setup details, please visit [SSH Tunnel Configuration].

5. Testing Account for your evaluation

We offer a testing account for you to evaluate Navicat more easily. Navicat remote connection setting for testing account:
Connection name : <It can be any name. The connection name will be shown in left panel of Navicat main screen>
Host: server1.navicat.com
username : navicat
password : testnavicat
Port number : 5432

NOTE: Navicat would be able to access your remote PostgreSQL server whether it is running on Linux, Unix, Mac, Windows platform. If you couldn't connect your remote PostgreSQL server via Internet, please kindly visit our knowledgebase for detailed explanation.

Open an existing database
After establishing a connection to a server the Server Navigator will show a list of databases on the server. Double click on the preferred database to shows all the tables, queries and backups associated with the database.

Create a new database
After establishing a connection to a server, right click on the server connection in the Server Navigator and select New Database from the menu. Enter the name for the new database and click OK to create the database on the server. If the database was successfully created on the server it will be displayed in the Server Navigator. You can now double click on the database to open it.

Open an existing table
Open a connection to a PostgreSQL server and then open a database on the server. In the Database Window, double click on a table to open the table in the Table window.

Create a new table
With an existing database open in the Database window select the Tables tab and click the New Table button at the Database window.

The Table Design Window provides a grid where you can enter fields together with their types and properties. A field's type can be selected from the Field Type list by clicking on the combo button. To set primary key, please double-click on Primary key box.

Select the Indexes tab to define the index(es) for the table. The Field Name grid is used to define the field(s) that make up the index. After defining all fields and indexes click Save, enter the name of the new table and click OK.

Download Mac OS X version of PostgreSQL Database
http://www.postgresql.org/download/