Postgres Pro
Downloads
Home   >   mailing lists

Thread: Synchronize Postgres with an other database

Synchronize Postgres with an other database

From
"hue"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial;mso-ansi-language:EN-GB">I would like to read Postgres transaction log files to update <span
class="GramE">another</span> database with an old structure base on files.</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-GB"style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB">The only solution I found is to read WAL files, but, the only way is
withc program, I did not find a way to use WAL files with java program.</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><span class="GramE"><font
face="Arial"size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:Arial;mso-ansi-language:EN-GB">Regards,
Olivier.</span></font></span><fontface="Arial" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:Arial;mso-ansi-language:EN-GB"></span></font><pclass="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-GB" style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-GB"style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB"> </span></font></div>

Re: Synchronize Postgres with an other database

From
David Stanaway
Date:
How many changes per minute are you planning for? Looking to the WAL
files seems very low level, and I don't imagine it would be a good idea
unless performance dictated it.

Have you thought of setting up a trigger to log inserts/updates/deletes
into a transaction table/tables that you can poll with a java
application or whatever other language you want?


On Mon, 2005-09-26 at 17:55 +0200, hue wrote:
> Hi,
> 
>  
> 
> I would like to read Postgres transaction log files to update an other
> database with an old structure base on files.
> 
>  
> 
> The only solution I found is to read WAL files, but, the only way is
> with c program, I did not find a way to use WAL files with java
> program.
> 
>  
> 
> Regards, Olivier.
> 
>  
> 
>  
> 
>