starting/running postgres...

From: "bruce" <bedouglas(at)earthlink(dot)net>
To: <pgsql-php(at)postgresql(dot)org>
Subject: starting/running postgres...
Date: 2005-04-25 22:09:11
Message-ID: 04b401c549e3$693ee2e0$0301a8c0@Mesa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

hi.

i'm installing postgres and have a few questions... i can login/su as the
user 'postgres' and then 'postmaster -i -p 5432 -D /var/lib/psql/data/'.
this starts the postgres app, and i can access it from a website.

however, if i attempt to do 'service postgresql start' while i'm 'root', the
postgres db/app still starts, but i'm unable to connect to it from the
website. the same thing occurs if i try to start the postgres app from the
'gnome' gui...

the website tries to access the db as user 'gforge'. this user is different
than the user 'postgres' or the user 'root'. as i said, this works if i
start postegres from the command line as user 'postgres'.

any ides/thoughts/etc...

thanks

bruce
bedouglas(at)earthlink(dot)net

ps. im unable to use the 'services postgresql start' as user 'postgres'.

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Michael Fuhr 2005-04-26 01:24:59 Re: starting/running postgres...
Previous Message Frank Finner 2005-04-25 18:57:23 Re: Why doesn't version 8.0.1 talk to php. Something I've