Re: is there any error for my postgresql installation?

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