Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group