Thread: Problems with pg_dump

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?

----------
Peter Bojanic, VP Professional Services, Pictorius Incorporated
URL: http://www.pictorius.com; Phone: (902) 492-2880 x223; Fax: (902)
492-3409

[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