Here is an example of connecting to PostgreSQL database in Database Tour software.

First, check whether PostgreSQL is installed on your computer. You can search in the list of installed programs (from Windows Control Panel) or list of services.

Installing PostgreSQL

If PostgreSQL was not installed, visit the PostgreSQL download page (use your search engine for finding it) and download the installer for Windows.

Then, launch the downloaded installer. For novices, it is recommended to use default paths and settings during the installation.

Connecting to PostgreSQL database

There are several methods to connect to PostgreSQL databases in Database Tour. Here, the recommended method is described: connecting using FD engine. This method provides faster database-to-database exporting comparing to ODBC and other alternatives and does not need a separate driver.

Note: PostgreSQL can be either 32-bit or 64-bit. The latest versions are 64-bit. To work with PostgreSQL 64-bit, you need to use Database Tour 64-bit, and vice versa. Each Database Tour edition (i.e. Standard and Pro) has both 32-bit and 64-bit versions. On Windows 64-bit, you can install both and use them depending on what type of work you need to do.

Let's start:

  1. Launch the Database Tour application.
  2. Click Connect / Open Data Source button or choose Database | Connect / Register... menu.
  3. Switch to FD interface.
  4. In the list of database types, choose PostgreSQL.
  5. In the list below, fill the connection parameters. Connecting to PostgreSQL Database The most important parameters are:
    • Vendor library
      It is recommended to specify the vendor library explicitly. It must be a path to libpq.dll file from the folder where you installed PostgreSQL. Note: When using Database Tour 32-bit, specify the library from the folder where PostgreSQL 32-bit was installed, otherwise use the path to PostgreSQL 64-bit.
    • Server
      This is a required parameter. Specify the IP address or the host name of the PostgreSQL server. If you want to connect to a local database, specify localhost.
    • Port
      This is a required parameter. Specify the port used by the PostgreSQL service.The default port is 5432.
    There is a full list of available parameters.
  6. In the Database alias field, specify a friendly name to your database. It will be shown in the list of registered databases to facilitate access to the database.
  7. Click Test to test the connection. In the case of success, click OK to register and open the database. Later, you can access this database by its alias in the list of registered databases or from the drop-down list of the Connect / Open Data Source button .

See also