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

Поиск
Список
Период
Сортировка
От Daniel Rubio
Тема Can't login to 8.2.4 if not superuser...
Дата
Msg-id 46DE594F.30900@tinet.org
обсуждение исходный текст
Ответы Re: Can't login to 8.2.4 if not superuser...
Список 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
********************************************************



В списке pgsql-admin по дате отправления:

Предыдущее
От: "Peter Koczan"
Дата:
Сообщение: Re: geometry poligons performance and index
Следующее
От: Daniel Rubio
Дата:
Сообщение: No pg_dumplo on 8.2.4