Re: unexpected pageaddr

From: armand pirvu <armand(dot)pirvu(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: unexpected pageaddr
Date: 2017-08-03 14:28:01
Message-ID: 38A94EFF-6673-4613-8475-3D03955126E0@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)pirvu(at)gmail(dot)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(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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2017-08-03 15:05:37 Check if prepared statement exist?
Previous Message Merlin Moncure 2017-08-03 12:58:02 Re: Would you add a --dry-run to pg_restore?