--- On Wed, 23/6/10, Tom Lane wrote:
> Glyn Astill
> 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 reprodu
Glyn Astill 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, so hopefully Tom ca
--- On Tue, 22/6/10, Kevin Grittner wrote:
> Glyn Astill
> 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 file smaller than 2GB, but the test I
> -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" writes:
> > Atta
"Igor Neyman" 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 creating the dump fil
> -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" writes:
> > Attac
"Igor Neyman" 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 2741; 1259 30866 T
> -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 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:
http://www.postgresql.org
> -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/
--- On Tue, 22/6/10, Igor Neyman wrote:
> From: Igor Neyman
> Subject: Re: [ADMIN] parallel option in pg_restore
> To: "John Rouillard"
> Cc: pgsql-admin@postgresql.org
> Date: Tuesday, 22 June, 2010, 17:34
>
> No piping, just regular restore from the backup
> -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
On Tue, Jun 22, 2010 at 11:05:02AM -0400, Igor Neyman wrote:
> > "Igor Neyman" 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: [cu
"Igor Neyman" 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 the exact pg_restor
> From: Igor Neyman
> Subject: Re: [ADMIN] parallel option in pg_restore
> To: "Tom Lane"
> Cc: pgsql-admin@postgresql.org
> Date: Tuesday, 22 June, 2010, 16:05
> > -Original Message-
> > From: Tom Lane [mailto:t...@sss.pgh.pa.us]
>
> > Sent
> -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" writes:
> &g
"Igor Neyman" 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 supported without
"Igor Neyman" 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
pg_dump, or n
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
19 matches
Mail list logo
