Hello,
I have a problem when trying to connect to a specific database with
postgres.
I'm logged as a user helpdesk group helpdesk
in my environment :
helpdesk@phoenix:~ > env |grep -i pg
PGLIB=/var/lib/pgsql/lib
PGDATA=/helpdesk/dbserver/db/data
PATH=/support/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/lib/java/bin:/usr/games/bin:/usr/games:/opt/gnome/bin:
/opt/kde/bin:/usr/openwin/bin:.:/var/lib/pgsql/bin:/var/lib/pgsql/bin:/var/lib/pgsql/bin
Postgresql is installed in /var/lib/pgsql - version 6.4.2
In data :
helpdesk@phoenix:/helpdesk/dbserver/db/data > ll
total 56
-rwxr-xr-x 1 helpdesk helpdesk 4 Jan 23 16:18 PG_VERSION
drwxr-xr-x 5 helpdesk helpdesk 4096 Dec 5 1999 base
-rwxr-xr-x 1 helpdesk helpdesk 8192 Dec 5 1999 pg_database
-rwxr-xr-x 1 helpdesk helpdesk 3407 Dec 5 1999 pg_geqo.sample
-rwxr-xr-x 1 helpdesk helpdesk 0 Dec 5 1999 pg_group
-rwxr-xr-x 1 helpdesk helpdesk 5192 Dec 5 1999 pg_hba.conf
-rwxr-xr-x 1 helpdesk helpdesk 8192 Dec 5 1999 pg_log
-rwxr-xr-x 1 helpdesk helpdesk 52 Dec 5 1999 pg_pwd
-rwxr-xr-x 1 helpdesk helpdesk 8192 Dec 5 1999 pg_shadow
-rwxr-xr-x 1 helpdesk helpdesk 8192 Dec 5 1999 pg_variable
In data/base :
drwxr-xr-x 2 helpdesk helpdesk 4096 Dec 5 1999 postgres
drwxr-xr-x 2 helpdesk helpdesk 4096 Dec 5 1999 problem_track
drwxr-xr-x 2 helpdesk helpdesk 4096 Dec 5 1999 template1
A postmaster process is running :
6709 pts/13 S 0:00 postmaster -B 256 -i -D /helpdesk/dbserver/db/data
In this environment I try :
psql template1 Ok
psql problem_track :
Connection to database 'problem_track' failed.
FATAL 1: Database problem_track does not exist in pg_database
Can someone help me and point me to my mistake
TIA
Laurent