Re: [ADMIN] pg_basebackup recovery failure

Поиск
Список
Период
Сортировка
От Jorge Torralba
Тема Re: [ADMIN] pg_basebackup recovery failure
Дата
Msg-id CACut7uTy+9K4fx3gOHRnvKLX615cghQZ6LJ3=-NNdoPJ5c_ivA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] pg_basebackup recovery failure  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-admin

For example


standby_mode     =  'on'

primary_conninfo =  'host=primaryserver port=5432 user=replication password=******* '

restore_command  =  'rsync -a -e "ssh -o strictHostKeyChecking=no" server_with_archive_wal_files:/path/to/wal/files/%f %p'


On Tue, Mar 7, 2017 at 12:36 PM, Magnus Hagander <magnus@hagander.net> wrote:
On Tue, Mar 7, 2017 at 12:31 PM, Ray Stell <stellr@vt.edu> wrote:

On this doc page are some command examples for pg_basebackup:

        https://www.postgresql.org/docs/current/static/app-pgbasebackup.html

such as: 

    pg_basebackup -h mydbserver -D /usr/local/pgsql/data

I've never gotten this to work.  When I bring up the copy on an intended standby system I always get the classic:
PANIC:  could not locate a valid checkpoint record
Failing that, I backed up with pg_start_backup/tar/pg_stop_backup as an alternative, but I was always curious what I was doing wrong. 
The wiki page on setting up replication:    https://wiki.postgresql.org/wiki/Streaming_Replication

says use the command with this options:      pg_basebackup -h 192.168.0.10 -D /srv/pgsql/standby -P -U replication --xlog-method=stream

and I stumbled into option:
     --checkpoint=fast

The standby was able to recover when I used one of these, I don't remember which, maybe both. 

Should the doc be updated or am I missing something?    

If you are using pg_basebackup without a log archive, then yes, you need --xlog-method=stream (or fetch). The checkpoint method only affects how quickly the checkpoint runs, it will always run.

If you do have a log archive, it should work fine without --xlog=stream, but you need to put your restore_command into recovery.conf manually.

--



--
Thanks,

Jorge Torralba
----------------------------

Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: [ADMIN] pg_basebackup recovery failure
Следующее
От: Ray Stell
Дата:
Сообщение: Re: [ADMIN] pg_basebackup recovery failure