Re: Last Commited Transaction

From: Ricardo Manuel Pereira Vilaça <rmvilaca(at)di(dot)uminho(dot)pt>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Last Commited Transaction
Date: 2006-04-11 13:06:59
Message-ID: 443BA9F3.5000807@di.uminho.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Fuhr wrote:

>On Tue, Apr 11, 2006 at 12:54:12PM +0100, Ricardo Manuel Pereira Vilaça wrote:
>
>
>>How I can determine information about the last committed transaction in
>>postgresql?
>>
>>
>
>What information are you looking for? What are you trying to do?
>
>
>
When a server restarts, and possible recovery, how can I know the id of
the last commited transaction?
I need that information for synchronization with other servers.
Can I add some application specific information to postgresql write
ahead log?

Thanks,

Ricardo Vilaça

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2006-04-11 13:16:37 Re: Debian package for freeradius_postgresql module
Previous Message Martijn van Oosterhout 2006-04-11 13:05:13 Re: sound index