[Charset iso-8859-1 unsupported, filtering to ASCII...]
> I'm running Postgresql 6.5.3 on RedHat Linux 6.0.
>
> When I try to use pg_dump:
>
> # pg_dump mmt
>
> I get the following error message:
>
> pg_dump: couldn't find the template1 database. You are really hosed. Giving
> up.
>
> Both my database, "mmt" and the "template1" database are present and I can
> connect to them with psql and query against them. I've got another Linux
> system with the same configuration and pg_dump works fine.
>
> Any suggestions or similar experiences?
Connect to template1 database, and do 'select * from pg_database' If
there is more than one template1, delete it by using it's oid, and try
the dump again. 6.6/7.0 will fix this.
--
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