New PostgreSQL Connection

New PostgreSQL Connection

The tool's method of connecting to PostgreSQL is similar to that of Navicat and other database tools. If you have other database tools installed, you can refer to their database connection information for guidance.

Server: Enter the server address where PostgreSQL is installed. For a local database connection, you can use localhost, 127.0.0.1, or your computer's IP address. For a remote database connection, enter the server's IP address.

Port: Enter the PostgreSQL port number. The default port number is 5432. If you customized a different port during installation, please provide that port number.

Username: Enter the username allowed to connect to the PostgreSQL database, with appropriate permissions for tool usage (e.g., CRUD operations).

Password: Enter the corresponding password for the provided username. If the connection fails, double-check the correctness of the password.

Database: Enter the name of the existing database you want to connect to.

Schema: The default schema is 'public'. If you want to connect to a different schema, enter its name.

Step 1: Enter the database connection information and click "Test Connection".

Step 2: Choose the schema you want to import, enter the connection name, and click "OK".

Common Issues:

If you encounter the error "utf-8' codec can't decode byte 0xd6 in position 62: invalidcontinuation byte", please double-check the correctness of the connection information.