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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
16 matches
Mail list logo