Re: Problems when dumping a database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tressens Lionel <tressens(at)etud(dot)insa-tlse(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems when dumping a database
Date: 2001-02-20 18:18:21
Message-ID: 25112.982693101@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tressens Lionel <tressens(at)etud(dot)insa-tlse(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-02-20 18:23:40 Re: Re: A How-To: PostgreSQL from Tcl via ODBC
Previous Message Bill Barnes 2001-02-20 18:15:01 Re: Re: A How-To: PostgreSQL from Tcl via ODBC