Re: hot standby questions

Thank you guys

I think I kinda shot myself in the foot. I took a look at the wiki and I put in -x and so far so good

— Armand

> On Aug 3, 2017, at 11:03 PM, Lucas Possamai <drum(dot)lucas(at)gmail(dot)com> wrote:
>
>
>
> 2017-08-04 5:58 GMT+12:00 Jeff Janes <jeff(dot)janes(at)gmail(dot)com <mailto:jeff(dot)janes(at)gmail(dot)com>>:
> On Wed, Aug 2, 2017 at 8:19 PM, armand pirvu <armand(dot)pirvu(at)gmail(dot)com <mailto:armand(dot)pirvu(at)gmail(dot)com>> wrote:
>
> Hi
>
> Just trying to put together the hot_standby setup
> All docs I read are pointing to use as prefered method to use pg_basebackup to set the base
> So far so good
> But
>
> psql postgres -c "select pg_start_backup('backup')"
> pg_basebackup -D /var/lib/pgsql/sample -Ft -z -P
> psql postgres -c "select pg_stop_backup()"
>
> pg_basebackup does the equivalent of pg_start_backup and pg_stop_backup for you. It is not helpful, and might even sometimes be harmful, to do them yourself when using pg_basebackup.
>
>
> Pretty much every where I looked at -x is not mentioned to be used
>
> So what gives ? What did I miss ? It's gotta be soomething
>
> That certainly isn't my experience. If you find sites that don't mention -x, -X, or --xlog-method, then I would be reluctant to take any of that site's other advice seriously.
>
> But note that in version 10, -x will go away and the default will be changed so that not specifying anything will be the same as -X stream. perhaps you are reading advice aimed at a future version.
>
> Cheers,
>
> Jeff
>
>
> I use pg_basebackup every day and the way I do is:
>
> pg_basebackup -D /destination --checkpoint=fast --xlog-method=stream
>
> The --xlog-method=stream option will copy the wal_files as well (to pg_xlogs directory).
>
> That works pretty well for me. You can either add the compress option too. Hope this was helpful.
>
> Cheers,
> Lucas