On Mon, Dec 8, 2008 at 8:16 PM, Richard Huxton <dev@archonet.com> 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
