Re: [GENERAL] You are really hosed.

> >
> > 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@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026