| From: | ahappy postgresuser <ahappypostgresuser(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Streaming replication and pg_dump |
| Date: | 2013-04-23 10:47:54 |
| Message-ID: | CAGvhmL21yQF6YBDbvVyBHY0Krm94qxUnZ7hTk5RBQw3+mN=DzA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I have a streaming replication slave, which I've setup for backup purposes
only. After running pg_dump on it (took around 8 hours) I ended up with 64
".ready" files in pg_xlog/archive_status.
These files have been there now for more than 24 hours.
These are some related configuration settings I modified, in order to be
able to run pg_dump for such amount of time:
max_standby_archive_delay = 1h
max_standby_streaming_delay = 10h
I've been reading postgres documentation, but I still have not a clear
understanding of what are the implication of these files being there, if
they should be removed by postgres, or if something failed and I should
redo the replication from scratch.
I'd appreciate any comment.
Many thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Cristian Cruz | 2013-04-23 11:23:08 | Re: Memory usage after upgrade to 9.2.4 |
| Previous Message | Rafał Pietrak | 2013-04-23 10:24:45 | Re: using text search |