is there any error for my postgresql installation?

Started by 中和刘over 17 years ago3 messagesgeneral

minxinjianxin@gmail.com

over 17 years ago

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:
--------------
An error has occurred:
Error connecting to the server: FATAL: password authentication failed
for user "postgres"
----------------
how can i fix it so that i can get pgadmin work?

here is my pg_hda.conf
------------------------
# Database administrative login by UNIX sockets
local all postgres ident sameuser

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
-----------------------

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?
is (4) a error? what should i do?

thanks

--
I'm a web developer using debian+mono(C#)+postgresql+xhtml+js+xsl+xml+css

dev@archonet.com

over 17 years ago

In reply to: 中和刘 (#1)

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

minxinjianxin@gmail.com

over 17 years ago

In reply to: Richard Huxton (#2)

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