I had checked the directory: /var/lib/pgsql (not postgres) It has some files but I can't do with it. I thought I had a prolems when install mandrake 9.0 and I installed it again but there is nothing to be change. When I start postgresql by the command: /etc/init.d/postgresql start then I type with user root: createdb demo Have a error message: user "root" does not exist What does this mean? please help me, thank you very much. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@xxxxxxxxxx ******************************************************* -----Original Message----- From: Gerd Terlutter <gerd@xxxxxxxxx> To: Tran Anh Tu <trantu@xxxxxxxxxx> Cc: pgsql-php@xxxxxxxxxxxxxx Date: Fri, 12 Sep 2003 09:03:33 +0200 Subject: Re: [PHP] Help me > Tran Anh Tu wrote: > > Hi all! > > ... > > But when I stop it and switch to user: postgres, and start it with > > command: postmaster -i then it does not working because It don't know > > where the database is placed. A error message: > > > > postmaster does not know where to find the database system data. > > Please help me! > tran@tux$su - > password:xxx > root#su postgres > tux:/root$ whoami > postgres > tux:/root$ cd > tux$pwd > /var/lib/postgres > tux$ls -al > does this help? > > greetings, > Gerd > > -- > -------------------------------------------------------- > # Gerd Terlutter | Mueller+Blanck Software GmbH # > # gerd@xxxxxxxxx | Gutenbergring 38 # > # gerd.terlutter@xxxxxx | D-22848 Noderstedt # > # tel:0171/6992579 | tel:+49 40 500 171-1 # > # Buero:040/500171-17 | fax:+49 40 500 171-71 # > -------------------------------------------------------- > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings