Re: [HACKERS] Point in Time Recovery

Ok - that is a much better way of doing it! regards Mark Tom Lane wrote: "Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes: If you use a readable file you will also need a feature for restore (or a tool) to create an appropriate pg_control file, or are you intending to still require that pg

Re: [HACKERS] [ADMIN] Where does the xlateSqlType symbol point to?

LISTMAN <[EMAIL PROTECTED]> writes: > Having tried various options, I still cannot find the clue where to llok > at concerning the following error message: > Load of file /usr/lib/pgsql/plpgsql.so failed: > /usr/lib/pgsql/plpgsql.so: undefined symbol: xlateSqlType I'd say you have a plpgsql.so fi

Re: [HACKERS] Point in Time Recovery

"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes: > If you use a readable file you will also need a feature for restore > (or a tool) to create an appropriate pg_control file, or are you > intending to still require that pg_control be the first file backed > up. No, the entire point of this

Re: [HACKERS] Point in Time Recovery

Zeugswetter Andreas SB SD wrote: > > > > I was wondering about this point - might it not be just as reasonable > > > for the copied file to *be* an exact image of pg_control? Then a very > > > simple variant of pg_controldata (or maybe even just adding switches to > > > pg_controldata itself)

[HACKERS] Where does the xlateSqlType symbol point to?

Hi all, Having tried various options, I still cannot find the clue where to llok at concerning the following error message: Load of file /usr/lib/pgsql/plpgsql.so failed: /usr/lib/pgsql/plpgsql.so: undefined symbol: xlateSqlType Searched for various libraries, but couldn't find anything. Do I n

Re: [HACKERS] try/catch macros for Postgres backend

Tom Lane wrote: Joe Conway <[EMAIL PROTECTED]> writes: This is especially a problem when the cleanup needs to be done inside the embedded interpreter. I found that with R, I had to throw an error in the R interpreter in order to allow the interpreter to clean up its own state. That left me with

Re: [HACKERS] Point in Time Recovery

> > I was wondering about this point - might it not be just as reasonable > > for the copied file to *be* an exact image of pg_control? Then a very > > simple variant of pg_controldata (or maybe even just adding switches to > > pg_controldata itself) would enable the relevant info to be extrac

[HACKERS] Regarding the logging in Postgres

Hi I went through the code, but couldnt figure out the exact flow of recovery. Could you please explain this stuff, like from where xlog_redo function is getting called etc. Thanks Mamta Yahoo! India Matrimony: Find your l