pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
******************************************************** 





view thread (8+ messages)  latest in thread

Message-ID: <46DE594F.30900@tinet.org>
Permalink:  ../46DE594F.30900@tinet.org/
Also on:    postgresql.org/message-id/46DE594F.30900@tinet.org

 · 

reply

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