Re: Problems when dumping a database - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems when dumping a database
Date
Msg-id 25112.982693101@sss.pgh.pa.us
Whole thread Raw
In response to Problems when dumping a database  (Tressens Lionel <tressens@etud.insa-tlse.fr>)
Responses Re: Problems when dumping a database  (Tressens Lionel <tressens@etud.insa-tlse.fr>)
List pgsql-general
Tressens Lionel <tressens@etud.insa-tlse.fr> writes:
> My pgsql DBMS works great except that when I want to dump a database,
> pg_dump says that database template1 doesn't exist (actually it does !)
> and the dump is aborted...

Curious.  Can you connect to template1 by hand (eg "psql template1")?

If not, try issuing "vacuum pg_database" (you can do this from any
database not only template1) to see if it helps.

If that doesn't fix it, we'll need to see the exact output from pg_dump,
as well as what shows up in the postmaster log.

            regards, tom lane

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Re: A How-To: PostgreSQL from Tcl via ODBC
Next
From: Tom Lane
Date:
Subject: Re: vacuum analyze again...