Timeline for answer to Streaming replication archive folder taking all space- Postgresql- 9.4 by jjanes
Current License: CC BY-SA 4.0
Post Revisions
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 17, 2019 at 14:05 | comment | added | SinghVK | Also, for recovery purpose, I will write a script which will be scheduled as cronjob which will take pg_dump and pg_dumpall backup of databases on weekly basis(pg_dump) and twice in a week(pg_dump). This will be used to recover database/restore database of old days. | |
| Jan 17, 2019 at 14:04 | comment | added | SinghVK | Hello jjanes,We only wanted to setup streaming replication. I followed the video tutorial([link]youtube.com/watch?v=XFp8wHNtP3s&vl=en). As per your suggestion, I will turn off archive_mode=off (I guess this is only change needs to be done in postgresql.conf in master and restart postgresql-9.4 services. Can you suggest if service restart is required, do we need to do any changes in slave conf files also?). | |
| Jan 16, 2019 at 20:15 | history | answered | jjanes | CC BY-SA 4.0 |