[HACKERS] connect to 7.5 devel(win32) failed

2004-07-30 Thread Coloring Graph
I am has some trouble when connect to 7.5 devel PostgreSQL server, see belows my setup:===os=Windows2000server version=the non-MSI snapshot at http://www.hagander.net/pgsql/win32snap/ has been "downgraded" to the latest known working snapshot

Re: [HACKERS] connect to 7.5 devel(win32) failed

2004-07-30 Thread Scott Marlowe
Moving the -admin, please don't reply to -hackers on this. On Fri, 2004-07-30 at 00:04, Coloring Graph wrote: I am has some trouble when connect to 7.5 devel PostgreSQL server, see belows my setup: === os=Windows2000 server version=the non-MSI snapshot at

[HACKERS] Regarding the logging in Postgres

2004-07-30 Thread Mamta Singh
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

Re: [HACKERS] Point in Time Recovery

2004-07-30 Thread Zeugswetter Andreas SB SD
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 extracted

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

2004-07-30 Thread Thomas Hallgren
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

[HACKERS] Where does the xlateSqlType symbol point to?

2004-07-30 Thread LISTMAN
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

Re: [HACKERS] Point in Time Recovery

2004-07-30 Thread Bruce Momjian
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) would enable

Re: [HACKERS] Point in Time Recovery

2004-07-30 Thread Tom Lane
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] [ADMIN] Where does the xlateSqlType symbol point to?

2004-07-30 Thread Tom Lane
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 file

Re: [HACKERS] Point in Time Recovery

2004-07-30 Thread Mark Kirkwood
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