Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> writes:
> You might not want to keep a copy of the whole data directory around, as you
> have to in a cascading standby. I can see value in a separate WAL proxy
> software, especially if it's integrated into a larger backup manager program
> like barman or wal-e.
+1
I somehow forgot about $PGDATA here. Time for a little break I guess :)
Another idea is to have a daemon mode pg_receivexlog where not only it
can maintain a local archive but also feed it using the replication
protocol to standbies, keeping track of their position.
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
In response to
Responses
pgsql-hackers by date
| Next: | From: Thom Brown | Date: 2013-01-22 13:37:21 |
| Subject: Re: Event Triggers: adding information |
| Previous: | From: Andres Freund | Date: 2013-01-22 13:32:51 |
| Subject: Re: Prepared statements fail after schema changes with surprising
error |