On Mon, Dec 8, 2008 at 8:16 PM, Richard Huxton <[EMAIL PROTECTED]> 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 psql thank you! i finally found that it's because i did not setup the postgres role's password > -- > Richard Huxton > Archonet Ltd >
-- I'm a web developer using debian+mono(C#)+postgresql+xhtml+javascript+xsl+xml+css my home is http://www.starliu.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
