Re: is there any error for my postgresql installation?

中和刘 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