Re: [HACKERS] xlogdump behaviour translating dropped relations

2006-07-26 Thread Diogo Biazus
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 r

Re: [HACKERS] xlogdump behaviour translating dropped relations

2006-07-26 Thread Diogo Biazus
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

[HACKERS] xlogdump behaviour translating dropped relations

2006-07-26 Thread Diogo Biazus
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

Re: [HACKERS] xlogdump enhancements

2006-07-14 Thread Diogo Biazus
#x27;m taking a look in that program. Is good to have a starting point :-)-- Diogo Biazus - [EMAIL PROTECTED]Móvel Consultoriahttp://www.movelinfo.com.brhttp://www.postgresql.org.br

[HACKERS] xlogdump enhancements

2006-07-14 Thread Diogo Biazus
s this right? I'd like to have 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

Re: [HACKERS] xlog viewer prototype and new proposal

2006-07-08 Thread Diogo Biazus
to extract especific data from diferent 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

Re: [HACKERS] xlog viewer prototype and new proposal

2006-07-07 Thread Diogo Biazus
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 >

[HACKERS] xlog viewer prototype and new proposal

2006-07-06 Thread Diogo Biazus
size).- a CSV output (to read it's data on another programs, including the backend)There's one functionality I 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

Re: [HACKERS] xlog viewer proposal

2006-06-25 Thread Diogo Biazus
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 xl

Re: [HACKERS] xlog viewer proposal

2006-06-23 Thread Diogo Biazus
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 stand

Re: [HACKERS] xlog viewer proposal

2006-06-23 Thread Diogo Biazus
bles the log files refer to. How would we be certain that theOID-to-tablename match would be a reliable one?Good 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 solu

Re: [HACKERS] xlog viewer proposal

2006-06-22 Thread Diogo Biazus
atest version I would be very glad. -- Diogo Biazus - [EMAIL PROTECTED]Móvel Consultoriahttp://www.movelinfo.com.brhttp://www.postgresql.org.br

Re: [HACKERS] xlog viewer proposal

2006-06-22 Thread Diogo Biazus
nments is a good way to ensurethat this summer project doesn't get finished :-( regards, tom lane-- Diogo Biazus - [EMAIL PROTECTED]Móvel Consultoria http://www.movelinfo.com.brhttp://www.postgresql.org.br

[HACKERS] xlog viewer proposal

2006-06-22 Thread Diogo Biazus
20  | 0/01F0 | 4 | BTREE   |We could also query for a list of committed transactions:SELECT    xlog.xid, count(1), sum(xlog.record_size)FROM    xlogviewer_file('0001000F') xlogWHERE    xlog.operation = 'XACT'    xlog.info =

Re: [HACKERS] [GENERAL] Anyone want to assist with the translation of the Advocacy

2002-10-04 Thread Diogo Biazus
> > >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