On Mon, Dec 8, 2008 at 8:16 PM, Richard Huxton <dev@xxxxxxxxxxxx> wrote:> 中和刘 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 psqlthank you! i finally found that it's because i did not setup thepostgres role's password> --> Richard Huxton> Archonet Ltd> -- I'm a web developer usingdebian+mono(C#)+postgresql+xhtml+javascript+xsl+xml+cssmy home is http://www.starliu.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
