Re: WAL archiving - Mailing list pgsql-admin
From | Shilpa Sudhakar |
---|---|
Subject | Re: WAL archiving |
Date | |
Msg-id | 47C24BA3.90609@internode.com.au Whole thread Raw |
In response to | Re: WAL archiving (Vishal Arora <aroravishal22@hotmail.com>) |
List | pgsql-admin |
Thanks for the link Vishal Regards, Shilpa Vishal Arora wrote: > > You can have a warm standby system in place. Pls check this link - > http://archives.postgresql.org/sydpug/2006-10/msg00001.php > > > > > ------------------------------------------------------------------------ > > > Date: Mon, 25 Feb 2008 09:54:34 +1030 > > From: ssudhakar@internode.com.au > > To: aroravishal22@hotmail.com > > CC: pgsql-admin@postgresql.org > > Subject: Re: [ADMIN] WAL archiving > > > > Shilpa Sudhakar wrote: > > > Hi Vishal, > > > > > > Below is the setup in the postgresql.conf file > > > > > > fsync = true # turns forced synchronization on or off > > > wal_sync_method = fsync # the default varies across platforms: > > > #wal_buffers = 8 # min 4, 8KB each > > > #commit_delay = 0 # range 0-100000, in microseconds > > > #commit_siblings = 5 # range 1-1000 > > > > > > # - Checkpoints - > > > > > > checkpoint_segments = 3 # in logfile segments, min 1, 16MB each > > > checkpoint_timeout = 300 # range 30-3600, in seconds > > > checkpoint_warning = 30 # 0 is off, in seconds > > > > > > # - Archiving - > > > > > > archive_command = 'cp -i %p /usr/local/var/pgsql/data/wal_log/%f' > > > # command to use to archive a logfile segment > > > > > > Since this is the test system i've put the wal_log folder in the data > > > folder itself. But, later on i'll be moving this to a different disk. > > > > > > We have thousands and thousands of records that get inserted and > > > updated so the wal logs would be increasing in a large rate. I was > > > thinking if i want to delete the wal logs after a period of time, > do i > > > take a base backup again and then delete those old files? > > > > > > Thanks and Regards, > > > Shilpa > > > > > > > > > Vishal Arora wrote: > > >> > > >> Hi Shilpa, > > >> > > >> You need not take base backup again and again. You have WAL > > >> Archiveing in place, that is enough to restore the database. BTW, > > >> what archiving command are you using for WAL Archiving in you > > >> postgresql.conf. > > >> > > >> - Vishal > > >> > > >> > ------------------------------------------------------------------------ > > >> > > >> > Date: Fri, 22 Feb 2008 09:53:25 +1030 > > >> > From: ssudhakar@internode.com.au > > >> > To: pgsql-admin@postgresql.org > > >> > Subject: [ADMIN] 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 > > >> > > >> > > >> > ------------------------------------------------------------------------ > > >> It's about getting married. Click here! Try it! > > >> <http://ss1.richmedia.in/recurl.asp?pid=201> > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 7: You can help support the PostgreSQL project by donating at > > > > http://www.postgresql.org/about/donate > > > ------------------------------------------------------------------------ > Post free auto ads on Yello Classifieds now! Try it now! > <http://ss1.richmedia.in/recurl.asp?pid=255>
pgsql-admin by date: