This article is simple to describe the following, when using the PostgreSQL database, issues related to access rights and remote connection databases, and its solutions. ※ The following problems and solutions are in the range of PostgreSQL8.0 and Windows 2003Server 1. Use the Postgres user locally, you need to enter the user password of Postgres when performing a database backup. Cause: The local credit link is not started. Workaround: Open the Data directory under $ postergreSQL_HOME}, where the pg_hba.conf file, add a line: host all all 127.0.0.1 255.255.255.255 Trust 2. When using the PG_ADMIN for remote connection database, the system prompts the database cannot be found. service. Cause: The POSTGRESQL server's TCP connection service is not open, or the IP address of the connection is allowed to be too small. Workaround: Open the Data directory under $ postergreSQL_HOME}, where the postgreSQL.conf file is found, where listen_addresses indicates the IP address that allows the connection, the port indicates the local port number of the TCP connection, MAX_CONNECTIONS indicates the maximum number of connections. . Where the value of listen_addresses is if Localhost, it means that only local connections, if it is *, it is not limited.
