-----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Shilpa Sudhakar Sent: Friday, February 22, 2008 1:23 AM To: pgsql-admin@xxxxxxxxxxxxxx Subject: WAL archiving 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
