From:       To:      

Home > Documentation > MySQL to PostgreSQL > Tutorial

Step 3 of 6. Connect to PostgreSQL Server

This wizard screen collects information to connect to PostgreSQL server. The converter is able to connect to PostgreSQL server using either local or remote mode. Local mode is being used to connect PostgreSQL server launched on the same machine where you run the program from. Remote mode allows you to connect to PostgreSQL server launched on another computer.

By default the program uses local connection mode. It is indicated by radio button "Local" selected. To establish remote connection you should select "Remote" radio button. For remote PostgreSQL servers you should also specify the host and the port to connect through. Host could be either network name or IP address. TCP/IP port value is necessary only if it differs from the default PostgreSQL port number 5432. Otherwise you may leave this field as is.

Enter user name and password or leave these fields blank for anonymous connection.

By default PostgreSQL server connects to database with name equal to the username specified. If there is no such database or PostgreSQL server does not allows access to it, custom database may be specifies on this wizard page.

Have questions? Contact us