From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | armand pirvu <armand(dot)pirvu(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: hot standby questions |
Date: | 2017-08-03 17:58:06 |
Message-ID: | CAMkU=1wGGnkh5L5ueEJ2e4W-ubfMOgjX5OA+pmmVu3d7Lk9bZQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Aug 2, 2017 at 8:19 PM, armand pirvu <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
From | Date | Subject | |
---|---|---|---|
Next Message | k b | 2017-08-03 18:22:32 | cast issue in WITH RECURION |
Previous Message | Jeff Janes | 2017-08-03 17:22:24 | Re: select md5 result set |