public inbox for [email protected]
help / color / mirror / Atom feedFrom: Joshua D. Drake <[email protected]>
To: [email protected]
Subject: Re: backup.sgml WIP (patch included)
Date: Tue, 02 Jun 2015 13:12:40 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>
On 06/02/2015 01:04 PM, Alvaro Herrera wrote:
>
> Joshua D. Drake wrote:
>
>> A change I did not make per Craig Ringer (and plenty of other people through
>> the years):
>>
>> "Instead we should be advising people to use pg_dump -Fc and pg_restore as
>> their default and primary method of dumping a database. It is rarely
>> desirable to use text dumps and if pg_dump was being written now, it'd
>> surely default to -Fc ."
>>
>> I think we really need to think about this.
>
> Yeah, this makes sense, except that if you want parallel dump (and many
> people do) you need -Fd.
>
Oh agreed there. I do say in the current patch:
The pg_dump application provides other formats. The most notable are the
use of -F c or -F d. The use of the custom format (-F c) is an excellent
option for smaller databases when you need fine grained control of the
objects you chose to restore. The use of the directory format (-F d)
allows for parallel connection based backups. If you are performing a
backup with many objects and using pg_dump then the directory format
will be the most efficient. This option also allows for fine grained
control of the objects you chose to restore. Further, the use of the
custom or directory pg_dump formats requires the use of pg_restore and
will not work with psql. There is more information on using pg_restore
in section Section 24.1.3.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: backup.sgml WIP (patch included)
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox