[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 t

[GENERAL] Re: Re: pg_restore fails on Windows

2008-08-20 Thread Tom Tom
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. > > > >> I tested the restore using the provided pg_restore.

[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

[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 X

[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

[GENERAL] Re:[GENERAL] restoring one table?

2008-08-08 Thread Tom Tom
Brian Maguire wrote: > We need to restore one table from a backup. What is the proper way to do > this? > > Our backup command looks like this: > > pg_dump -C -Fc -S postgresql mydatabase > today.backup.sqlc > > I am using PostgreSQL 8.1. > > -- > Sent via pgsql-general mailing list (pgsql-

[GENERAL] Re: [GENERAL] pg_restore fails on Windows

2008-08-08 Thread Tom Tom
> 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

[GENERAL] pg_restore fails on Windows

2008-08-07 Thread Tom Tom
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 5432 -U postgres -d "configV3" -v "c:\Share\POSTGRES.backup" pg_restore: connecting to database for re