From: | "Jens Hartwig" <jhartwig(at)debis(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Database ... has disappeared from pg_database |
Date: | 2001-01-29 12:01:48 |
Message-ID: | 003b01c089eb$42c99180$c10ac98a@0000864A433A |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello all,
I am running into a strange error when creating a database which is located
in another directory than the default directory of PostgreSQL (7.0.2.):
I created a directory called mybase (as owner postgres). I ran the command
initlocation on this directory, then I declared an environment variable
PGDATA2 and restarted my postmaster.
With the command createdb mydb -D 'PGDATA2' I created a new database. When
trying to connect to this database I get the following error:
psql: FATAL 1: Database 'mydb', OID 10857280, has disappeared from
pg_database
What has happened? Any suggestions would be welcome.
Best regards, Jens Hartwig
=============================================
Jens Hartwig
---------------------------------------------
debis Systemhaus GEI mbH
10875 Berlin
Tel. : +49 (0)30 2554-3282
Fax : +49 (0)30 2554-3187
Mobil : +49 (0)170 167-2648
E-Mail : jhartwig(at)debis(dot)com
=============================================
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Marc Pigeon | 2001-01-29 12:50:00 | Re: Database ... has disappeared from pg_database |
Previous Message | Graham Vickrage | 2001-01-29 11:10:14 | pg_hba.conf question |