Re: Database ... has disappeared from pg_database

From: Jean-Marc Pigeon <jmp(at)safe(dot)ca>
To: jhartwig(at)debis(dot)com (Jens Hartwig)
Cc: jmp(at)new-york(dot)safe(dot)ca (Jean-Marc Pigeon)
Subject: Re: Database ... has disappeared from pg_database
Date: 2001-01-29 12:50:00
Message-ID: 200101291250.f0TCo0b26338@new-york.safe.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bonjour Jens Hartwig
>
> 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.):
[....]
>
>
> psql: FATAL 1: Database 'mydb', OID 10857280, has disappeared from
> pg_database
>
> What has happened? Any suggestions would be welcome.
Is the postgres daemon made awar about it??, we have an application
(Regulus) which data-base is located in its own directory,
an extra postgres daemon must be started like:
/usr/bin/postmaster -D //var/lib/regulus/dbm -p 1621 -B512 -o -F -o -Q -o -S2048

to access it we just do:
psql -p 1621 regulus

(it is a matter of fact, for test and and demo purpose, we have
3 or 4 Regulus version running on the same server, eash one
in it own directory and with its own daemon).

Hopping that help.

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

A bientot
==========================================================================
Jean-Marc Pigeon Internet: Jean-Marc(dot)Pigeon(at)safe(dot)ca
SAFE Inc. Phone: (514) 493-4280 Fax: (514) 493-1946
REGULUS, a real time accounting/billing package for ISP
REGULUS' Home base <"http://www.regulus.safe.ca">
==========================================================================

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kim Minh Kaplan 2001-01-29 14:50:45 Re: postgres limitation
Previous Message Jens Hartwig 2001-01-29 12:01:48 Database ... has disappeared from pg_database