From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Peter Bojanic <pbojanic(at)pictorius(dot)com> |
Cc: | pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] Problems with pg_dump |
Date: | 1999-12-09 16:50:13 |
Message-ID: | 199912091650.LAA26932@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
[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(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 | kaiq | 1999-12-09 16:55:18 | Re: [GENERAL] parse error ??? |
Previous Message | soundar rajan | 1999-12-09 16:49:08 | JDBC2.0 and pg |