cannot connect to database
От | Laurent GALAIS |
---|---|
Тема | cannot connect to database |
Дата | |
Msg-id | 3A755F1D.4080403@4js.com обсуждение исходный текст |
Ответы |
Re: cannot connect to database
select using index in group by slower as normal fields? |
Список | 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@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
В списке pgsql-novice по дате отправления: