Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxxAPC, How to unsubscrube from dategen spam, WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text

Links

XODOX
Impressum

#1: How to identify the current WAL segment file

Posted on 2007-12-03 11:21:09 by Tommy Cheng

------=_Part_6177_24752580.1196677269566
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi everyone,

I am new to postgresql. So point me to somewhere else if you got the right
direction.

i am using PostgreSQL 8.1.9 on a linux system and i want to setup PITR. i
found that the segment size is too large that the copying frequency is not
high enough.

So, i want to set up a cron job that periodically identifies the current WAL
segment file once a minute and scp it to other server.

How to do that, can someone give me a template script?

Btw, i saw archieve_timeout setting in
http://www.postgresql.org/docs/8.2/static/continuous-archivi ng.html
that may suits my need, can i use it in 8.1.9?

------=_Part_6177_24752580.1196677269566
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi everyone,<br><br>I am new to postgresql. So point me to somewhere else if you got the right direction.<br><br>i am using PostgreSQL 8.1.9 on a linux system and i want to setup PITR. i found that the segment size is too large that the copying frequency is not high enough.
<br><br>So, i want to set up a <span class="APPLICATION">cron</span> job that periodically identifies the current WAL segment file once a minute and scp it to other server.<br><br>How to do that, can someone give me a template script?
<br><br>Btw, i saw archieve_timeout setting in <a href="http://www.postgresql.org/docs/8.2/static/continuous-archiving.html"> http://www.postgresql.org/docs/8.2/static/continuous-archivi ng.html</a><br>that may suits my need, can i use it in
8.1.9?<br><br><br>

------=_Part_6177_24752580.1196677269566--

Report this message