[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: postgres complete recovery
From:       "David G. Johnston" <david.g.johnston () gmail ! com>
Date:       2019-04-22 22:19:55
Message-ID: CAKFQuwb-HYedY9r2NKZWkCswEA5wuTOYPPX=EoDj6k=1VqxVTg () mail ! gmail ! com
[Download RAW message or body]

On Mon, Apr 22, 2019 at 3:02 PM Pavan Kumar <pavan.dba27@gmail.com> wrote:

> Hello David,
>
> Thank you so much for clarification.
> is there any way to keep redundant copy of current wall log on same
> server? means, as soon as transaction commits, it it going to make an entry
> in wal log and  the same log in different location ?
> please advise
>

PostgreSQL itself will only write to a single file.  It may be possible to
setup an operating system tool (like inotifywait) to accomplish this but
its not something I've tried or seen discussed or recommended in my reading.

David J.

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr"><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><span \
style="font-family:Arial,Helvetica,sans-serif">On Mon, Apr 22, 2019 at 3:02 PM Pavan \
Kumar &lt;<a href="mailto:pavan.dba27@gmail.com">pavan.dba27@gmail.com</a>&gt; \
wrote:</span><br></div></div><div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hello \
David,<div><br></div><div>Thank you so much for clarification.</div><div>is there any \
way to keep redundant copy of current wall log on same server? means, as soon as \
transaction commits, it it going to make an entry in wal log and   the same log in \
different location ?</div><div>please advise  \
</div></div></blockquote><div><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">PostgreSQL itself will only write to a \
single file.   It may be possible to setup an operating system tool (like \
inotifywait) to accomplish this but its not something I&#39;ve tried or seen \
discussed or recommended in my reading.</div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">David J.</div><div \
class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]