From: | armand pirvu <armand(dot)pirvu(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | hot standby questions |
Date: | 2017-08-03 03:19:02 |
Message-ID: | A16CAC72-B19F-42E2-B820-9283BCFAF12E@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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()"
will get me on target
< 2017-08-02 22:09:45.348 CDT >LOG: database system was interrupted; last known up at 2017-08-02 22:06:28 CDT
< 2017-08-02 22:09:45.353 CDT >LOG: entering standby mode
< 2017-08-02 22:09:45.353 CDT >LOG: invalid primary checkpoint record
< 2017-08-02 22:09:45.353 CDT >LOG: invalid secondary checkpoint record
< 2017-08-02 22:09:45.353 CDT >PANIC: could not locate a valid checkpoint record
< 2017-08-02 22:09:45.523 CDT >LOG: startup process (PID 10895) was terminated by signal 6: Aborted
< 2017-08-02 22:09:45.523 CDT >LOG: aborting startup due to startup process failure
where as
psql postgres -c "select pg_start_backup('backup')"
pg_basebackup -D /var/lib/pgsql/sample -Ft -z -P -x
psql postgres -c "select pg_stop_backup()"
I am good to go
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
Thanks
Armand
From | Date | Subject | |
---|---|---|---|
Next Message | armand pirvu | 2017-08-03 03:34:48 | unexpected pageaddr |
Previous Message | James Sewell | 2017-08-03 00:38:36 | Re: Interesting streaming replication issue |