14.1 Frequently Asked Questions

Table of Contents Previous Next


14 Troubleshooting : 14.1 Frequently Asked Questions

Make sure that your client application is providing an MD-5 encrypted password when attempting to connect to the load balancing port. The username:password-md5 combination is stored in pgpool_passwd.conf, and is automatically updated when a user changes password, or when a new user is created.
To safely stop a Postgres server without triggering failover, you can use either the service command or the pg_ctl utility. For more information, see Section 13.4.
Problem: I am attempting to connect to my Advanced Server database with the psql client, and am getting the error:
(03/23/2012 13:36:53)-> psql --host=192.0.43.10 -p 9999 -U enterprisedb
Password for user enterprisedb: psql: FATAL: database "postgres" does not exist
The psql client expects the default database to be named postgres; the edb-psql client expects the default database to be named edb. If you attempt to connect to an Advanced Server cluster with the psql client without specifying the name of the database to which it should connect, the client will fail to connect.
You can include the -d or --dbname flag, followed by the database name when invoking either client to specify the database to which the client should connect.
It may be that pgpool is retaining a connection to the database. You can use the pg_cancel_backend() or pg_terminate_backend() functions to selectively close connections to the database you wish to drop.
Instead of reloading, simply waiting for 20 seconds between the 수정 USER statement and the CREATEDB statement should solve the problem.
If you invoke the pg_start_backup() function before performing a manual backup your database, you must remember to invoke the pg_stop_backup() function when the backup has completed, or EDB Ark scheduled backups will fail.

14 Troubleshooting : 14.1 Frequently Asked Questions

Table of Contents Previous Next