cannot connect to database

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

Responses

Browse pgsql-novice by date

  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...