| From: | Alan Nilsson <anilsson(at)apple(dot)com> |
|---|---|
| To: | PostgreSQL General Discussion Forum <pgsql-general(at)postgresql(dot)org> |
| Subject: | pg_basebackup and checkpoints |
| Date: | 2014-02-05 08:15:15 |
| Message-ID: | 5BEE067A-6EEA-4256-A4B0-42D56BA76999@apple.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I tried (and finally succeeded) to do a base backup tonight using pg_basebackup. I was backing up a server that had no activity on it. The backup connected but no data was transferring, both ends sitting idle. It finally occurred to me to try a manual checkpoint and it then the backup took off and completed.
According to 24.3 in the docs, pg_start_backup() performs a checkpoint. So I was surpassed that using the pg_baseback utility I had to manual kick a checkpoint before the transfer would start.
Is this correct behavior?
alan
fwiw, invocation:
pg_basebackup -P --xlog —host=XXXXX --pgdata=pgsql --user=replicate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2014-02-05 09:01:45 | Re: pg_basebackup and checkpoints |
| Previous Message | Roy Anderson | 2014-02-05 04:06:00 | Offending My Tender Sensibilities -OR- OLTP on a Star Schema |