Re: starting postgres/psql

Robert Morgan wrote:

>Back again,I still cant access the dbms I have created the user postgres
>and started postgres.
>
>[root(at)localhost bob]# su postgres
>bash-2.05b$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l
>logfile start
>/usr/local/pgsql/bin/pg_ctl: line 341: logfile: Permission denied
>
Okay, you installed and initdb'd the database as user postgres, right?
Then one of these should fix it:

- Make sure that user postgres 'owns' the directory and its subdirectories:
as user root:
chown -R postgres.postgres /usr/local/pgsql
(user postgres belongs to group postgres in this example)

- Make sure that /bin is in postgres' path (in .bash_profile)

export PATH=$PATH:/usr/local/java/bin:/usr/local/ant/bin:/usr/local/pgsql/bin
^ ^ ^ ^

(you may want/need/disregard the java and ant)

Then su to user postgres:
su - postgres
and your psql -d template1 should work

Ron