[GENERAL] Re: pg_restore fails on Windows

2008-08-21 Thread Tom Tom
Magnus Hagander wrote: > >>> 2.Our production PG version is 8.1.3. For some reasons it is not possible > to > >> upgrade to the LATEST; > >>> I tested the libpq also on this version and it worked. Is it OK? I mean, > did > >> it worked by chance or the library > >>> API & contracts didn't change b

[GENERAL] Re: pg_restore fails on Windows

2008-08-20 Thread Tom Tom
Magnus Hagander wrote > Tom Tom wrote: > > Magnus Hagander wrote > >> Tom Lane wrote: > >>> =?us-ascii?Q?Tom=20Tom?= <[EMAIL PROTECTED]> writes: > Magnus Hagander wrote: > > Attached is a pg_restore.exe off CVS tip today, which should include the > > patch. Please try this one. >

Re: [GENERAL] Re: pg_restore fails on Windows

2008-08-18 Thread Tom Lane
=?us-ascii?Q?Tom=20Tom?= <[EMAIL PROTECTED]> writes: > Magnus Hagander wrote: >> Attached is a pg_restore.exe off CVS tip today, which should include the >> patch. Please try this one. > I tested the restore using the provided pg_restore.exe. The output is: > pg_restore: [archiver (db)] could not

[GENERAL] Re: pg_restore fails on Windows

2008-08-18 Thread Tom Tom
Magnus Hagander wrote: > Tom Lane wrote: > > I wrote: > >> Of course the larger issue is why it's failing --- 150MB doesn't seem > >> like that much for a modern machine. I suspect that PQerrorMessage() > >> would tell us something useful, but pg_restore isn't letting us see it. > > > > I've appl

Re: [GENERAL] Re: pg_restore fails on Windows

2008-08-15 Thread Tom Lane
I wrote: > Of course the larger issue is why it's failing --- 150MB doesn't seem > like that much for a modern machine. I suspect that PQerrorMessage() > would tell us something useful, but pg_restore isn't letting us see it. I've applied a patch for the latter issue. But the only way we can fin

Re: [GENERAL] Re: pg_restore fails on Windows

2008-08-15 Thread Tom Lane
=?us-ascii?Q?Tom=20Tom?= <[EMAIL PROTECTED]> writes: > Magnus Hagander wrote: >> Can you set up a reproducible test-case that doesn't involve your data, > - test row was inserted using the Java client code > INSERT INTO hibtableattachmentxmldata VALUES (?,?,?) > where value 1 is "" > value 2 i

[GENERAL] Re: pg_restore fails on Windows

2008-08-15 Thread Tom Tom
Magnus Hagander wrote: > Tom Tom wrote: > > Magnus Hagander wrote: > >> Tom Tom wrote: > Tom Tom wrote: > > Hello, > > > > We have a very strange problem when restoring a database on Windows XP. > > The PG version is 8.1.10 > > The backup was made with the pg_dump on the sa

[GENERAL] Re: pg_restore fails on Windows

2008-08-14 Thread Tom Tom
Magnus Hagander wrote: > Tom Tom wrote: > >> Tom Tom wrote: > >>> Hello, > >>> > >>> We have a very strange problem when restoring a database on Windows XP. > >>> The PG version is 8.1.10 > >>> The backup was made with the pg_dump on the same machine. > >>> > >>> pg_restore -F c -h localhost -p 543