Re: [GENERAL] Online Backups PostGre

2009-05-03 Thread PostGre Newbie
Thanks everyone for replying. I will definitely try out the methods outlined. Thanks once again :) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Online Backups PostGre

2009-05-03 Thread PostGre Newbie
Thanks everyone for replying. I will definitely try out the methods outlined. Thanks once again :) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Online Backups PostGre (rsync for Windows)

2009-05-03 Thread Brent Wood
Hi There are a few rsync on Windows options, just google rsync windows One we've found works well is DeltaCopy, which may meet your requirements. Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand >>> Adam Ruth 05/02/09 1:01 PM >>> Cygwin comes with rsync on

Re: [GENERAL] Online Backups PostGre

2009-05-01 Thread Adam Ruth
Cygwin comes with rsync on Windows. On 02/05/2009, at 4:06 AM, John R Pierce wrote: Joshua D. Drake wrote: Well that's just it. Out of the box it doesn't actually work. PostgreSQL only gives you the facilities to roll your own PITR solution. You can look at PITR Tools: https://projects.comm

Re: [GENERAL] Online Backups PostGre

2009-05-01 Thread Scott Marlowe
On Fri, May 1, 2009 at 12:06 PM, John R Pierce wrote: > Joshua D. Drake wrote: >> >> Well that's just it. Out of the box it doesn't actually work. PostgreSQL >> only gives you the facilities to roll your own PITR solution. You can >> look at PITR Tools: >> >> https://projects.commandprompt.com/pub

Re: [GENERAL] Online Backups PostGre

2009-05-01 Thread Adrian Klaver
- "Joshua D. Drake" wrote: > On Fri, 2009-05-01 at 09:22 -0700, PostGre Newbie wrote: > > Hi everyone, > > > I searched the web and I know I should get a snapshot of the > > filesystem and then backup the WAL archive logs but this is the > part > > where I am confused. I do not know of any

Re: [GENERAL] Online Backups PostGre

2009-05-01 Thread John R Pierce
Joshua D. Drake wrote: Well that's just it. Out of the box it doesn't actually work. PostgreSQL only gives you the facilities to roll your own PITR solution. You can look at PITR Tools: https://projects.commandprompt.com/public/pitrtools It doesn't quite work on Windows due to lack of rsync and

Re: [GENERAL] Online Backups PostGre

2009-05-01 Thread Alan Hodgson
On Friday 01 May 2009, PostGre Newbie wrote: >I do not know of any open source backup utilities > that can take snapshots of the filesystem. I get the overall concept > of online backups but I am still unclear EXACTLY how the system works. > I would be grateful if anyone could explain it to me. I

Re: [GENERAL] Online Backups PostGre

2009-05-01 Thread Joshua D. Drake
On Fri, 2009-05-01 at 09:47 -0700, Ben Chobot wrote: > On Fri, 1 May 2009, PostGre Newbie wrote: > > > I know that taking the backup of the whole database every 10 minutes > > is a very bad way to go about it but until I find a better way to do > > it, it will have to do for now. Any suggestions/t

Re: [GENERAL] Online Backups PostGre

2009-05-01 Thread Joshua D. Drake
On Fri, 2009-05-01 at 09:22 -0700, PostGre Newbie wrote: > Hi everyone, > I searched the web and I know I should get a snapshot of the > filesystem and then backup the WAL archive logs but this is the part > where I am confused. I do not know of any open source backup utilities > that can take sna

Re: [GENERAL] Online Backups PostGre

2009-05-01 Thread Ben Chobot
On Fri, 1 May 2009, PostGre Newbie wrote: I know that taking the backup of the whole database every 10 minutes is a very bad way to go about it but until I find a better way to do it, it will have to do for now. Any suggestions/tips/articles on how to do the backup would be appreciated very much