Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Einar KarttunenDate: 2001-01-29 12:27:29
Subject: Re: cannot connect to database
Previous:From: RasputinDate: 2001-01-29 09:39:06
Subject: Re: Still lockin up...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group