From: Daniel Rubio <drubior@tinet.org>
To: pgsql-admin@postgresql.org
Subject: Can't login to 8.2.4 if not superuser...
Date: Wed, 05 Sep 2007 09:22:55 +0200
Message-ID: <46DE594F.30900@tinet.org> (raw)
Hi all
I'm experiencing a weird situation with my test installation for 8.2.4.
I installed with no problems on Solaris 10, and I've imported my
databases and users from a 7.4.14 using the 8.2.4 pg_dumpall without
excessive problems (some things about permissions on some tables, but I
think it's not related).
If I log via psql using the postgres user via psql there's no problem,
but If I try to log as a different user, the postmaster process hangs
and I can't connect.
On the log file (debug1, using syslog) I see:
Sep 5 09:24:10 pluto2 pg[7698]: [ID 748848 local4.info] [14-1] LOG:
connection received: host=[local]
Sep 5 09:24:10 pluto2 pg[7698]: [ID 748848 local4.info] [15-1] LOG:
connection authorized: user=xxx database=xxx
Sep 5 09:24:21 pluto2 pg[833]: [ID 748848 local4.info] [14-1] LOG:
server process (PID 7698) was terminated by signal 11
Sep 5 09:24:21 pluto2 pg[833]: [ID 748848 local4.info] [15-1] LOG:
terminating any other active server processes
Sep 5 09:24:21 pluto2 pg[833]: [ID 748848 local4.info] [16-1] LOG: all
server processes terminated; reinitializing
Sep 5 09:24:21 pluto2 pg[7700]: [ID 748848 local4.info] [17-1] LOG:
database system was interrupted at 2007-09-05 09:08:10 CEST
Sep 5 09:24:21 pluto2 pg[7700]: [ID 748848 local4.info] [18-1] LOG:
checkpoint record is at 0/2CFCB380
Sep 5 09:24:21 pluto2 pg[7700]: [ID 748848 local4.info] [19-1] LOG:
redo record is at 0/2CFCB380; undo record is at 0/0; shutdown TRUE
Sep 5 09:24:21 pluto2 pg[7700]: [ID 748848 local4.info] [20-1] LOG:
next transaction ID: 0/2662; next OID: 917504
Sep 5 09:24:21 pluto2 pg[7700]: [ID 748848 local4.info] [21-1] LOG:
next MultiXactId: 1; next MultiXactOffset: 0
Sep 5 09:24:21 pluto2 pg[7700]: [ID 748848 local4.info] [22-1] LOG:
database system was not properly shut down; automatic recovery in progress
Sep 5 09:24:21 pluto2 pg[7700]: [ID 748848 local4.info] [23-1] LOG:
record with zero length at 0/2CFCB3D0
Sep 5 09:24:21 pluto2 pg[7700]: [ID 748848 local4.info] [24-1] LOG:
redo is not required
Sep 5 09:24:21 pluto2 pg[7700]: [ID 748848 local4.info] [25-1] LOG:
database system is ready
And in the command line:
bash-3.00# ../bin/psql -d xxx -U xxx
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
If I login with the postgres user there's no problem, and if I set the
user xxx as superuser (using pgAdmin) I can login with it too ...
Actually, for test purposes, my pg_hba.conf settings are:
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1 255.255.255.255 password
host all all xxx.xxx.xxx.xxx 255.255.255.255 password
host all all yyy.yyy.yyy.yyy 255.255.255.255 password
Where xxx.xxx.xxx.xxx is my host public ip address and yyy.yyy.yyy.yyy
my laptop IP to access with pgAdmin.
Some idea about what it's happening?
--
********************************************************
Daniel Rubio Rodríguez
OASI (Organisme Autònom Per la Societat de la Informació)
c/ Assalt, 12
43003 - Tarragona
Tef.: 977.244.007 - Fax: 977.224.517
e-mail: drubio a oasi.org
********************************************************
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: drubior@tinet.org
Subject: Re: Can't login to 8.2.4 if not superuser...
In-Reply-To: <46DE594F.30900@tinet.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox