Re: Non-text mode for pg_dumpall - Mailing list pgsql-hackers

From Srinath Reddy
Subject Re: Non-text mode for pg_dumpall
Date
Msg-id CAFC+b6r2HDhms7aggMq8b8fJQL2r-RNTEeNcBnNj_0M41R81Lw@mail.gmail.com
Whole thread Raw
In response to Re: Non-text mode for pg_dumpall  (Mahendra Singh Thalor <mahi6run@gmail.com>)
Responses Re: Non-text mode for pg_dumpall
List pgsql-hackers
Hi,
i think during restore we should not force user to use -C during cases like 
./pg_restore pdd -g -f -
./pg_restore pdd -a -f -
./pg_restore pdd -s -f -
because its not good to use -C to create database every time when we are using these options individually.
latest patch throws following error for all the above cases

pg_restore: error: -C/--create option should be specified when restoring multiple databases by archive of pg_dumpall
pg_restore: hint: Try "pg_restore --help" for more information.
pg_restore: hint: If db is already created and dump has single db dump, then use particular dump file.

Thanks and Regards
Srinath Reddy Sadipiralla
EDB: https://www.enterprisedb.com
Srinath Reddy Sadipiralla,

pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options
Next
From: Ramanathan
Date:
Subject: Re: Proposal - Reduce lock during first phase of VACUUM TRUNCATE from ACCESS EXCLUSIVE to EXCLUSIVE