From: | Laurent GALAIS <lg(at)4js(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | cannot connect to database |
Date: | 2001-01-29 12:16:29 |
Message-ID: | 3A755F1D.4080403@4js.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Einar Karttunen | 2001-01-29 12:27:29 | Re: cannot connect to database |
Previous Message | Rasputin | 2001-01-29 09:39:06 | Re: Still lockin up... |