Re: [GENERAL] unexpected pageaddr - Mailing list pgsql-general

From armand pirvu
Subject Re: [GENERAL] unexpected pageaddr
Date
Msg-id 38A94EFF-6673-4613-8475-3D03955126E0@gmail.com
Whole thread Raw
In response to [GENERAL] unexpected pageaddr  (armand pirvu <armand.pirvu@gmail.com>)
List pgsql-general
Well this reproduces with pg_basebackup

Disturbing. I wonder what else if lurking around



> On Aug 2, 2017, at 10:34 PM, armand pirvu <armand.pirvu@gmail.com> wrote:
>
> 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@192.168.5.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
>



pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] Would you add a --dry-run to pg_restore?
Next
From: Igor Korot
Date:
Subject: [GENERAL] Check if prepared statement exist?