Re: Make pg_basebackup -x stream the default

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Vladimir Rusinov <vrusinov(at)google(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Make pg_basebackup -x stream the default
Date: 2016-12-20 13:38:30
Message-ID: CAHGQGwFV-jNj3cxN6nL20jv5VX7dhfEZycCtUrSF0PZVjWaO=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Dec 19, 2016 at 7:51 PM, Vladimir Rusinov <vrusinov(at)google(dot)com> wrote:
>
> On Sat, Dec 17, 2016 at 2:37 PM, Magnus Hagander <magnus(at)hagander(dot)net>
> wrote:
>>
>> Attached is an updated patch that does this. As a bonus it simplifies the
>> code a bit. I also fixed an error message that I missed updating in the
>> previous patch.
>
>
> looks good to me.

Yep, basically looks good to me. Here are some small comments.

> while ((c = getopt_long(argc, argv, "D:F:r:RT:xX:l:nNzZ:d:c:h:p:U:s:S:wWvP",
> long_options, &option_index)) != -1)

'x' should be removed from the above code.

> To create a backup of a single-tablespace local database and compress this with bzip2:
>
> $ pg_basebackup -D - -Ft | bzip2 > backup.tar.bz2

The above example in the docs needs to be modified. For example,
add "-X fetch" into the above command so that pg_basebackup
should not exit with an error.

> The server must also be configured with max_wal_senders set high
> enough to leave at least one session available for the backup.

I think that it's better to explain explicitly here that max_wal_senders
should be higher than one by default.

Regards,

--
Fujii Masao

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-12-20 13:41:51 Re: Hash Indexes
Previous Message Robert Haas 2016-12-20 13:35:05 Re: Time to drop old-style (V0) functions?