WAL archiving - Mailing list pgsql-admin

From Shilpa Sudhakar
Subject WAL archiving
Date
Msg-id 47BE07ED.1070802@internode.com.au
Whole thread Raw
Responses Re: WAL archiving  ("Vladimir Rusinov" <vladimir@greenmice.info>)
unsubscribe  ("Lucian DRAGUS" <lucid@eurogama.ro>)
List pgsql-admin
Hi All,

I am new to postgres and have been slowly learning the concepts.

Regarding WAL archiving, we first take a base backup and then save all
the wal logs for PITR.

Both the base backup and wal logs are stored in another disk.

Since the wal logs keep increasing, do we take the base backup every now
and then so that we can delete the old log files?
How often do we take a base filesystem backup keeping in mind that our
systems are 24 x 7.

Any suggestions are appreciated.

Thanks and Regards,
Shilpa


pgsql-admin by date:

Previous
From: Shilpa Sudhakar
Date:
Subject: Re: pg_ctl reload query
Next
From: Decibel!
Date:
Subject: Re: vaccuming very large table problem