Re: pg_dump help

On Tue, Aug 08, 2000 at 08:20:16AM -0500, Len Morgan wrote:
> -----Original Message-----
> From: Robert D. Nelson <RDNELSON(at)co(dot)centre(dot)pa(dot)us>
>
> >>I am trying to copy a table from my local database to a client's. The
> >>problem is I keep getting a message from pg_dump:
> >>
> >>"can't find template1 database. You are really hosed."
> >
>
> I still seem to have an additional problem though that is somewhat related:
>
> All of my tables, indexes, and sequences are doubled if you do a \dt or \di
> or \ds!
>

Hmm, this sounds like an old problem with the pg_user table getting corrupt.
try: SELECT * FROM pg_user. Do you see only one user named postgres? ISTR
that this could even cause the 'can't find template1 database' error.

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005