Re: [GENERAL] You are really hosed.

[Nikos Mouat]

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

nm


************