中和刘 wrote: > I have just installed postgresql 8.3 on my debian sid, and have set > the password of both system user postgres and database user to the > same password, but when i connect to it using pgadmin3(from the local > machine), i got the error: > here is the log messages > ----------------------- > 2008-12-06 12:33:08 HKT LOG: could not load root certificate file > "root.crt": no SSL error reported (1) > 2008-12-06 12:33:08 HKT DETAIL: Will not verify client certificates. (2) > 2008-12-06 12:33:08 HKT LOG: could not create IPv6 socket: Address > family not supported by protocol (3) > 2008-12-06 12:33:09 HKT LOG: database system was shut down at > 2008-12-06 12:32:18 HKT > 2008-12-06 12:33:09 HKT LOG: autovacuum launcher started > 2008-12-06 12:33:09 HKT LOG: database system is ready to accept connections > 2008-12-06 12:33:09 HKT LOG: incomplete startup packet (4) > -------------------------- > is (1) a error? what should i do? > what does (2) mean? is it normal? > is (3) ok? 1,2,3 aren't anything too serious - just saying that you've not set up ssl correctly and IPv6 networking isn't going to work. You're not using them, so it doesn't matter. > is (4) a error? what should i do? I'm not sure how you're getting #4 - it seems to be happening as soon as the system starts up. Three things to do: 1. Make sure log_connections is turned on in your postgresql.conf 2. Make sure your connection settings are correct in pgadmin 3. Try connecting from the command-line client psql -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
