Can't login to 8.2.4 if not superuser...

From: Daniel Rubio <drubior(at)tinet(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Can't login to 8.2.4 if not superuser...
Date: 2007-09-05 07:22:55
Message-ID: 46DE594F.30900@tinet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
********************************************************

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel Rubio 2007-09-05 07:31:05 No pg_dumplo on 8.2.4
Previous Message Peter Koczan 2007-09-05 02:58:02 Re: geometry poligons performance and index