I'm not sure about how the xlogdump should behave when translating oids of dropped relations.Now I'm just showing the oid, and ignoring the translation in these cases.But may be it's a good idea to giva a hint to the user (printing dropped).
Any advices?-- Diogo Biazus - [EMAIL PROTECTED]Móvel
On 7/26/06, Tom Lane [EMAIL PROTECTED] wrote:
Diogo Biazus [EMAIL PROTECTED] writes: I'm not sure about how the xlogdump should behave when translating oids of dropped relations.I'm not sure it should be making any attempt to translate anything.
What makes you think the oids even refer
On 7/26/06, Tom Lane [EMAIL PROTECTED] wrote:
Diogo Biazus [EMAIL PROTECTED] writes: On 7/26/06, Tom Lane [EMAIL PROTECTED] wrote: I'm not sure it should be making any attempt to translate anything.
What makes you think the oids even refer to the current database? I'm getting a new database
opinions on the subject. If somebody could give me some advice on how to start the last feature (decode the statemets) I'd apreciate very much.-- Diogo Biazus -
[EMAIL PROTECTED]Móvel Consultoria
http://www.movelinfo.com.br
http://www.postgresql.org.br
to have a starting point :-)-- Diogo Biazus -
[EMAIL PROTECTED]Móvel Consultoriahttp://www.movelinfo.com.brhttp://www.postgresql.org.br
operations.But I was hoping to get more input about the functionality expected in the standalone tool, what could improve the existing xlogdump?
-- Diogo Biazus - [EMAIL PROTECTED]Móvel Consultoriahttp://www.movelinfo.com.br
http://www.postgresql.org.br
On 07 Jul 2006 09:58:29 -0400, Greg Stark [EMAIL PROTECTED]
wrote:
Diogo Biazus [EMAIL PROTECTED] writes: I exposed the idea of bringing the xlogdump functionality to a backend
module. The main drawback is the use case where the database is down. But
the access to a failed cluster isn't
would like to work on but I don't how dificult it would be to acomplish in time:
- Extract the exact operation done in cases of xlog generated by insert/update/delete.-- Diogo Biazus - [EMAIL PROTECTED]Móvel Consultoria
http://www.movelinfo.com.brhttp://www.postgresql.org.br
xlogviewer.tar.gz
Alright, I'm working on a fast prototype using the SRF.On 6/23/06, Simon Riggs [EMAIL PROTECTED] wrote:
On Fri, 2006-06-23 at 10:59 -0300, Diogo Biazus wrote: On 6/23/06, Simon Riggs
[EMAIL PROTECTED] wrote: - give more flexibility for managing the xlogs remotely Not sure what you mean. - I
question, It seems to me that the only case where this have a trivial aswer is if your inside the backend querying the current xlog directory.
I'm still thinking about the solution for the other cases (inside or outside the backend).-- Diogo Biazus -
[EMAIL PROTECTED]Móvel Consultoriahttp
On 6/23/06, Diogo Biazus [EMAIL PROTECTED] wrote:
On 6/23/06, Simon Riggs
[EMAIL PROTECTED]
wrote:
- give more flexibility for managing the xlogs remotelyNot sure what you mean.I can connect to the server if I want to query xlogs in a remote machine.
If i depend on a standalone tool that reads
transactions:SELECT
xlog.xid, count(1), sum(xlog.record_size)FROM xlogviewer_file('0001000F') xlogWHERE xlog.operation = 'XACT' xlog.info = 'COMMIT'GROUP BY
xlog.xid-- Diogo Biazus - [EMAIL PROTECTED]Móvel Consultoriahttp://www.movelinfo.com.br
http://www.postgresql.org.br
:-(
regards, tom lane-- Diogo Biazus - [EMAIL PROTECTED]Móvel Consultoria
http://www.movelinfo.com.brhttp://www.postgresql.org.br
would be very glad.
-- Diogo Biazus - [EMAIL PROTECTED]Móvel Consultoriahttp://www.movelinfo.com.brhttp://www.postgresql.org.br
Hi everyone,
Have just put together a prototype page to show off the multi-lingual
capabilities that the Advocacy sites' infrastructure has:
http://advocacy.postgresql.org/?lang=de
The text was translated to german via Altavista's Babelfish, so it's
probably only about 80% accurate, but it
15 matches
Mail list logo
