Re: [GENERAL] Incremental Backups in postgres

2009-11-11 Thread Greg Smith
akp geek wrote: Got it almost. Thanks a lot. One final question, please bear with me. 1. select pg_start_backup('label') ==> 10 AM 2. PGDATA folder backup ==> 10:05 AM 3. select pg_stop_backup => 10.10AM 4. The archiving will start writing files You've got step (4) in the wrong place. The

Re: [GENERAL] Incremental Backups in postgres

2009-11-11 Thread akp geek
Got it almost. Thanks a lot. One final question, please bear with me. 1. select pg_start_backup('label') ==> 10 AM 2. PGDATA folder backup ==> 10:05 AM 3. select pg_stop_backup => 10.10AM 4. The archiving will start writing files 5. If the disc crashes at 11AM, what will happen to the data bet

Re: [GENERAL] Incremental Backups in postgres

2009-11-11 Thread Scott Mead
On Wed, Nov 11, 2009 at 12:51 PM, akp geek wrote: > Hi All - > I have read the document got a reasonable > understanding of the WAL process. I have some confusion regarding the > process. > > 1. I have set up the archiving process. Now the archive file are going > to a different

Re: [GENERAL] Incremental Backups in postgres

2009-11-11 Thread akp geek
Hi All -                   I have read the document got a reasonable understanding of the WAL process. I have some confusion regarding the process. 1. I have set up the archiving process. Now the archive file are going to a different mount point. 2. I set up job to create a back up of the PGDATA d

Re: [GENERAL] Incremental Backups in postgres

2009-11-10 Thread akp geek
I have set up the replication using Bucardo. This is just an additional set up regards On Tue, Nov 10, 2009 at 5:09 PM, silly wrote: > How about using replication instead of incremental backups? > > On Tue, Nov 10, 2009 at 4:56 PM, Alan Hodgson wrote: > > On Tuesday 10 November 2009, akp g

Re: [GENERAL] Incremental Backups in postgres

2009-11-10 Thread silly8888
How about using replication instead of incremental backups? On Tue, Nov 10, 2009 at 4:56 PM, Alan Hodgson wrote: > On Tuesday 10 November 2009, akp geek wrote: >> So Is it always good to have the backup using PG_dump instead of PITR or >> a combination of both >> > > I like to do both. Ongoing P

Re: [GENERAL] Incremental Backups in postgres

2009-11-10 Thread Alan Hodgson
On Tuesday 10 November 2009, akp geek wrote: > So Is it always good to have the backup using PG_dump instead of PITR or > a combination of both > I like to do both. Ongoing PITR, daily base backups (by updating an rsync copy), and weekly pg_dumps that in turn go to tape. PITR gives a very rece

Re: [GENERAL] Incremental Backups in postgres

2009-11-10 Thread akp geek
So Is it always good to have the backup using PG_dump instead of PITR or a combination of both Please advice Regards On Tue, Nov 10, 2009 at 11:24 AM, Scott Mead wrote: > > On Tue, Nov 10, 2009 at 9:52 AM, Greg Stark wrote: > >> >> It's always worth having the dump, even if you also implement

Re: [GENERAL] Incremental Backups in postgres

2009-11-10 Thread akp geek
I have tested the procedure in the URL and it worked fine. I have accidentally deleted my PGDATA folder after the backup procedure is done. I could able to restore it. But still have few questions Thanks for the help Regards On Mon, Nov 9, 2009 at 11:01 PM, Jing Tan wrote: > I wrote an article

Re: [GENERAL] Incremental Backups in postgres

2009-11-10 Thread Scott Mead
On Tue, Nov 10, 2009 at 9:52 AM, Greg Stark wrote: > > It's always worth having the dump, even if you also implement PITR. > The dump allows you to restore just specific tables or to restore onto > a different type of system. The PITR backup is a physical > byte-for-byte copy which only works if

Re: [GENERAL] Incremental Backups in postgres

2009-11-10 Thread Greg Stark
On Tue, Nov 10, 2009 at 11:03 AM, Alban Hertroys wrote: > IMHO The simplest solution is to just write a dump to the same file every > now and then and have the backup software take care of storing only the > differences. It does have a few drawbacks; it means you'll have a file about > as large as

Re: [GENERAL] Incremental Backups in postgres

2009-11-10 Thread Alban Hertroys
On 10 Nov 2009, at 3:48, akp geek wrote: Dear all - Is there way to create incremental backups in postgres. I am currently using 8.4.1 on solaris.. I am new to postgres. Can you please share your thoughts Regards IMHO The simplest solution is to just write a dump to t

Re: [GENERAL] Incremental Backups in postgres

2009-11-09 Thread Jing Tan
I wrote an article about PITR , incremental backups and multiple timelines. check out. http://jinxter555.blogspot.com/ it should be an easy read. akp geek ha escrito: Dear all - Is there way to create incremental backups in postgres. I am currently using 8.4.1 on solaris. I

Re: [GENERAL] Incremental Backups in postgres

2009-11-09 Thread Richard Broersma
On Mon, Nov 9, 2009 at 6:48 PM, akp geek wrote: >   Is there way to create incremental backups in postgres. I > am currently using 8.4.1 on solaris. I am new to postgres. Can you please > share your thoughts I've read more about continuous back-ups: http://www.postgresql.org/docs

Re: [GENERAL] Incremental Backups in postgres

2009-11-09 Thread Ben Chobot
Saving off the transaction log WAL files is a good way to do this. Read this part of the manual: http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html ...and see if that answers your questions. On Nov 9, 2009, at 6:48 PM, akp geek wrote: Dear all - Is t

[GENERAL] Incremental Backups in postgres

2009-11-09 Thread akp geek
Dear all - Is there way to create incremental backups in postgres. I am currently using 8.4.1 on solaris. I am new to postgres. Can you please share your thoughts Regards