>>>>> "Giuseppe" == Giuseppe Sacco <[EMAIL PROTECTED]> writes: Giuseppe> Organization: HSO Business Company Giuseppe> X-Mailer: Mozilla 4.05 [en] (WinNT; I)
Giuseppe> hsogso:~# psql Giuseppe> Connection to database 'template1' failed. Giuseppe> FATAL 1: SetUserId: user "root" is not in "pg_shadow" Root is NOT the superuser in postgres. You need to log on as user postgres. As root do a `su - postgres' and set up your database. You can add new users via a script, namely `createuser'. The script will prompt you whether the new user is able to create/delete/modify databases and tables. Giuseppe> And then, after reboot I cannot start the server: Giuseppe> hsogso:/tmp# /etc/init.d/postgresql start Giuseppe> Starting PostgreSQL postmaster Giuseppe> FATAL: StreamServerPort: bind() failed: errno=13 Giuseppe> Is another postmaster already running on that port? Giuseppe> If not, remove socket node (/tmp/.s.PGSQL.<portnr>)and retry. Giuseppe> /usr/lib/postgresql/bin/postmaster: cannot create UNIX stream port I observed the same problem. Could be a bug with the debian postgres startup script, could be a bug with postgres not deleting the file on shutdown. Just delete that file and you can restart the server. Maybe the startup script should check for existence of that file after shutdown and remove it if it's still there. -- Nicolai P Guba BT Laboratories GNU Project http://www.labs.bt.com http://www.gnu.org [EMAIL PROTECTED] [EMAIL PROTECTED]