I need suggestion to backup my postgresql server. The database is growing 1/2 Gb a day and I am looking for a solution that would push the data off to the backup server periodically with minimal amount of load to the server (I am trying to avoid table locking). I am thinking to use rsync to sync
Apu Islam [EMAIL PROTECTED] writes:
I need suggestion to backup my postgresql server. The database is growing
1/2 Gb a day and I am looking for a solution that would push the data off
to the backup server periodically with minimal amount of load to the
server (I am trying to avoid table
Am Freitag, den 21.10.2005, 12:22 -0500 schrieb Apu Islam:
I need suggestion to backup my postgresql server. The database is
growing 1/2 Gb a day and I am looking for a solution that would push
the data off to the backup server periodically with minimal amount of
load to the server (I am
* Apu Islam ([EMAIL PROTECTED]) wrote:
I need suggestion to backup my postgresql server. The database is growing
1/2 Gb a day and I am looking for a solution that would push the data off to
the backup server periodically with minimal amount of load to the server (I
am trying to avoid table
On Fri, 2005-10-21 at 12:22, Apu Islam wrote:
I need suggestion to backup my postgresql server. The database is
growing 1/2 Gb a day and I am looking for a solution that would push
the data off to the backup server periodically with minimal amount of
load to the server (I am trying to avoid
On Fri, 2005-10-21 at 13:38, Scott Marlowe wrote:
On Fri, 2005-10-21 at 12:22, Apu Islam wrote:
I need suggestion to backup my postgresql server. The database is
growing 1/2 Gb a day and I am looking for a solution that would push
the data off to the backup server periodically with minimal
Seems like WAL backup is the way to go with PITR. database will not have to be exhaused over and over with pg_dump and if I do rsync hourly, I could minimize the network traffic significantly as well. I already like the term 'hot standby' from the doc already.
Thanks for your help.
-apu
On