Re: [GENERAL] Problems when dumping a database

2001-02-24 Thread Tressens Lionel
Le 22.02.01 à 22:23, "Tom Lane" écrivait : )> SELECT oid FROM pg_database WHERE datname = 'template1' ) )> But this SELECT returns two tuples ! I have two identical tuples in )> pg_database for template1. )> Perhaps deleting one will help me, but which one (equal ?). ) )This is definitely uncool,

Re: [GENERAL] Problems when dumping a database

2001-02-22 Thread Tom Lane
Tressens Lionel <[EMAIL PROTECTED]> writes: > Le 20.02.01 à 13:18, "Tom Lane" écrivait : > )Tressens Lionel <[EMAIL PROTECTED]> 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 t

Re: [GENERAL] Problems when dumping a database

2001-02-20 Thread Tom Lane
Tressens Lionel <[EMAIL PROTECTED]> 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,