How to enable the Navicat report Viewer to connect to the PostgreSQL database

The Navicat Report Viewer , as a convenient database viewer, allows users to quickly and easily browse reports, regardless of whether the server is available on any Linux, Unix, Mac, or Windows platform. So we are very popular. Here is an introduction to how to make the Navicat report Viewer connected to the PostgreSQL database?

Original: http://www.formysql.com/wenti/lianjie-postgreaql.html

In the Navicat Report Viewer, the user first creates one or more connections by using the Connection window to begin viewing reports. To create a new connection, tap Connect or select File-New connection, and then enter the required information in the Connection Properties window.

After the connection is created, the user needs to place the report file (. RTM) to the report location before viewing and printing the report. It is important to note that the NAVICAT report Viewer supports connecting to remote servers on different platforms, namely Windows, Mac, Linux, and UNIX.

Navicat Connection Property Information

PostgreSQL Connection General Settings

For security reasons, the local remote direct connection to the PostgreSQL server is disabled, so users may not be able to connect directly to the remote server using the Navicat report Viewer or other similar applications. By default, PostgreSQL allows only native computers connected by using TCP/IP to connect. Other machines will not be able to connect unless the user modifies the listen_addresses in the postgresql.conf file, enabling host-based authentication and re-opening the server by modifying the $PGDATA/pg_hba.conf file.

By default, PostgreSQL provides a user name of "Postgres" with a blank password.

Host name or IP address: the host name or the IP address of the server where the database resides.

PORT: The TCP/IP port that is connected to the database server.

Initial database: The initial database to which the user is connected when connected.

User name: The user name to connect to the database server.

Password: the password to connect to the server.

PostgreSQL Connection Advanced Settings

Maintain connection interval (seconds): This option allows the user to maintain a connection by pinging, and the interval between ping and ping can be set in the Edit field.

For more information on how to connect the Navicat report Viewer to the PostgreSQL database, click on "Navicat for MySQL download " For more tutorials.

How to enable the Navicat report Viewer to connect to the PostgreSQL database