From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Nikos Mouat <nikm(at)cyberflunk(dot)com> |
Cc: | Mike Mascari <mascarim(at)yahoo(dot)com>, Michael Plump <plumpy(at)skylab(dot)org>, pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] You are really hosed. |
Date: | 1999-10-10 14:42:18 |
Message-ID: | 199910101442.KAA07082@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> >
> > SELECT oid from pg_database where datname =
> > 'template1'
> >
>
> it turns out there was multiple template1's in the pg_database table:
>
> template1=> select * from pg_database;l
> datname |datdba|encoding|datpath
> ---------+------+--------+---------
> template1| 100| 0|template1
> template1| 100| 0|template1
> darwin | 100| 0|darwin
> template1| 100| 0|template1
> (4 rows)
>
>
> pg_dump works fine now (I deleted two of the three template1's)
I have no idea how this happens, but when it does, things are bad.
I have improved the error message in pg_dump, saying:
pg_dump: couldn't find the template1 database.
Check the table pg_database for a problem.
There should be exactly one 'template1' entry.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Tassell | 1999-10-10 19:51:24 | Re: [GENERAL] Connect PostgreSQL 6.0 Server with php4b |
Previous Message | Jeroen van Vianen | 1999-10-10 12:35:01 | pgxml 1.0 released |