From: | Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 9.0 standby - could not open file global/XXXXX |
Date: | 2019-02-26 11:45:39 |
Message-ID: | CAP_rwwkkDwZpSsD5ESrX5b-YVYCbLdyTJZz2LiTN=ycsNesoog@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Feb 26, 2019 at 2:39 AM Andres Freund <andres(at)anarazel(dot)de> wrote:
>
> > 2. base backup is transferred directly to new server using
> > pg_start_backup + rsync + pg_stop_backup.
>
I excluded contents of pg_xlog only. Exact command was:
# start script
psql -Xc "select pg_start_backup('mirror to $standby', true)"
( cd $PGDATA \
&& find . -type d \( -path ./pg_xlog \) -prune -o -type f -print \
| xargs -n $nargs \
| xargs -P $njobs -I {} bash -c "while ! rsync -a -u -z -R --inplace
{} $standby:$PGDATA; do echo retrying; done"
)
psql -Xc "select pg_stop_backup()"
# end script
Actually I am now in the process of repeating this with
single-threaded rsync - and I'll see if same issue happens.
This is what I'm going to use:
rsync -a -z --inplace $PGDATA/ $standby:$PGDATA/
But it's unlikely to change anything. Still no idea what could be the
root cause.
Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Atkins | 2019-02-26 11:48:44 | Re: Replication |
Previous Message | Filip Rembiałkowski | 2019-02-26 11:39:20 | Re: Replication |