[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Postgresql refure to connect



Hi,
I have just installed the postgresql DBMS from debian hamm.
I am trying to play a little with it, but at the first attempt I get this
error:

hsogso:~# psql
Connection to database 'template1' failed.
FATAL 1:  SetUserId: user "root" is not in "pg_shadow"
hsogso:~# uname -a
Linux hsogso 2.1.120 #16 Wed Sep 9 14:36:32 CEST 1998 i586 unknown
hsogso:~#

Where do I create postgres users? I checked that the standard configuration
should permit everyone to connect. But I didn't find anything about pg_shadow.
What is it?

And then, after reboot I cannot start the server:
hsogso:/tmp# /etc/init.d/postgresql start
Starting PostgreSQL postmaster
FATAL: StreamServerPort: bind() failed: errno=13
        Is another postmaster already running on that port?
        If not, remove socket node (/tmp/.s.PGSQL.<portnr>)and retry.
/usr/lib/postgresql/bin/postmaster: cannot create UNIX stream port
hsogso:/tmp# ls -la /tmp
total 4
drwxr-xr-x   3 root     root         1024 Sep 16 00:21 .
drwxr-xr-x  21 root     root         1024 Sep  6 10:36 ..
-r--r--r--   1 root     root           11 Sep 16 00:21 .X0-lock
drwxrwxrwt   2 root     root         1024 Sep 16 00:21 .X11-unix
hsogso:/tmp#

And, if I execute "strace postmaster start", then I get this final output:

298   socket(PF_UNIX, SOCK_STREAM, 0)   = 4
298   setsockopt(4, SOL_SOCKET, SO_REUSEADDR, [1], 4) = 0
298   bind(4, {sun_family=AF_UNIX, sun_path="/tmp/.s.PGSQL.5432"}, 20) = -1 EACCES (Permission denied)
298   write(2, "FATAL: StreamServerPort: bind() "..., 165) = 165
298   write(2, "/usr/lib/postgresql/bin/postmast"..., 67) = 67
298   _exit(1)                          = ?

Anybody can help me?

Thanks,
Giuseppe


Reply to: