--- On Tue, 22/6/10, Kevin Grittner kevin.gritt...@wicourts.gov wrote:
Glyn Astill glynast...@yahoo.co.uk
wrote:
so far I can only get the same error with large dump
files.
Large being a relative term --
ever see it on a file smaller than 2GB?
Good point. No I've not seen it on a
Glyn Astill glynast...@yahoo.co.uk writes:
Good point. No I've not seen it on a file smaller than 2GB, but the test I
did was pretty basic - I just trimmed down the size of all of my tables to
create a dump that was only 50Mb or so. It looks like Igor has a
reproduceable case now though,
--- On Wed, 23/6/10, Tom Lane t...@sss.pgh.pa.us wrote:
Glyn Astill glynast...@yahoo.co.uk
writes:
Good point. No I've not seen it on a file
smaller than 2GB, but the test I did was pretty basic - I
just trimmed down the size of all of my tables to create a
dump that was only 50Mb or so.
I'm testing 8.4.4 (on Windows) before upgrading our app to this PG
version.
When running pg_restore with -j 2 parallel option, I'm getting the
following error:
pg_restore: [custom archiver] dumping a specific TOC data block out of
order is not supported without ID on this input stream (fseek
Igor Neyman iney...@perceptron.com wrote:
I'm testing 8.4.4
pg_restore with -j 2 parallel option
using pg_dump version 8.2.5.
Is this error results from version differences between pg_dump and
pg_restore?
Yeah, probably.
I suspect that you have the choice of dumping with the newer
Igor Neyman iney...@perceptron.com writes:
I'm testing 8.4.4 (on Windows) before upgrading our app to this PG
version.
When running pg_restore with -j 2 parallel option, I'm getting the
following error:
pg_restore: [custom archiver] dumping a specific TOC data block out of
order is not
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, June 22, 2010 10:37 AM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] parallel option in pg_restore
Igor Neyman iney...@perceptron.com writes:
I'm testing 8.4.4 (on Windows
From: Igor Neyman iney...@perceptron.com
Subject: Re: [ADMIN] parallel option in pg_restore
To: Tom Lane t...@sss.pgh.pa.us
Cc: pgsql-admin@postgresql.org
Date: Tuesday, 22 June, 2010, 16:05
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, June 22
Igor Neyman iney...@perceptron.com writes:
Is that the information you asked for, or you want a sample of small
backup file attached?
I'm attaching pg_restore log file, if it's of any help.
If you can make a small archive file that provokes the problem, yes
please send it. Also, please show
On Tue, Jun 22, 2010 at 11:05:02AM -0400, Igor Neyman wrote:
Igor Neyman iney...@perceptron.com writes:
I'm testing 8.4.4 (on Windows) before upgrading our app to this PG
version.
When running pg_restore with -j 2 parallel option, I'm getting the
following error:
pg_restore:
-Original Message-
From: John Rouillard [mailto:rou...@renesys.com]
Sent: Tuesday, June 22, 2010 11:52 AM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] parallel option in pg_restore
On Tue, Jun 22, 2010 at 11:05:02AM -0400, Igor Neyman wrote:
Igor
--- On Tue, 22/6/10, Igor Neyman iney...@perceptron.com wrote:
From: Igor Neyman iney...@perceptron.com
Subject: Re: [ADMIN] parallel option in pg_restore
To: John Rouillard rou...@renesys.com
Cc: pgsql-admin@postgresql.org
Date: Tuesday, 22 June, 2010, 17:34
No piping, just regular
-Original Message-
From: Glyn Astill [mailto:glynast...@yahoo.co.uk]
Sent: Tuesday, June 22, 2010 12:36 PM
To: John Rouillard; Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] parallel option in pg_restore
--- On Tue, 22/6/10, Igor Neyman iney...@perceptron.com
Glyn Astill glynast...@yahoo.co.uk wrote:
so far I can only get the same error with large dump files.
Large being a relative term --
ever see it on a file smaller than 2GB?
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Tuesday, June 22, 2010 12:40 PM
To: Igor Neyman; John Rouillard; Glyn Astill
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] parallel option in pg_restore
Glyn Astill glynast...@yahoo.co.uk
Igor Neyman iney...@perceptron.com writes:
Attached are couple smallish files (I suspect, CM_200909.bac might have
just empty tables, no data - but it still produces an errror).
Hmm. I get
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, June 22, 2010 1:10 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] parallel option in pg_restore
Igor Neyman iney...@perceptron.com writes:
Attached are couple smallish files
Igor Neyman iney...@perceptron.com writes:
Attached is script that could be used to pre-create parent tables
(from which partitions were inherited).
Thanks. Now that I dig into it, it looks like the actual trigger for
the problem is that pg_dump, not pg_restore, couldn't seek while it
was
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, June 22, 2010 2:41 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] parallel option in pg_restore
Igor Neyman iney...@perceptron.com writes:
Attached is script that could
19 matches
Mail list logo