From: | armand pirvu <armand(dot)pirvu(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | unexpected pageaddr |
Date: | 2017-08-03 03:34:48 |
Message-ID: | 5F2BBED6-8677-4B89-AC37-84C692A94CA8@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
Setting up the hot_standby the only way I could it get the base remote cluster running was including pg_xlog
Now using rsync as opposed to pg_basebackup seems ok aka
psql postgres -c "select pg_start_backup('backup')"
rsync -a /var/lib/pgsql/9.5/data postgres(at)192(dot)168(dot)5(dot)252:/var/lib/pgsql/9.5
psql postgres -c "select pg_stop_backup()"
But
cp: cannot stat ‘/var/lib/pgsql/pg_xlog_archive/000000010000000000000078’: No such file or directory
< 2017-08-02 22:30:40.949 CDT >LOG: unexpected pageaddr 0/3D000000 in log segment 000000010000000000000078, offset 0
and later
cp: cannot stat ‘/var/lib/pgsql/pg_xlog_archive/000000010000000000000079’: No such file or directory
< 2017-08-02 22:30:40.949 CDT >LOG: unexpected pageaddr 0/3D000000 in log segment 000000010000000000000079, offset 0
cp: cannot stat ‘/var/lib/pgsql/pg_xlog_archive/000000010000000000000079’: No such file or directory
Things seem okay but the unexpected pageaddr error is a bit unsettling .
Any thougts ? Something to be really worried about ? Did I miss it again ? :))
Thanks
Armand
From | Date | Subject | |
---|---|---|---|
Next Message | Murtuza Zabuawala | 2017-08-03 07:03:29 | standby database crash |
Previous Message | armand pirvu | 2017-08-03 03:19:02 | hot standby questions |