Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore from split files - Mailing list pgsql-general

From Igor Neyman
Subject Re: pg_restore from split files
Date
Msg-id A76B25F2823E954C9E45E32FA49D70EC13C6B7DF@mail.corp.perceptron.com
Whole thread Raw
In response to Re: pg_restore from split files  (akp geek <akpgeek@gmail.com>)
List pgsql-general
Tree view

I don’t think pg_restore is able to deal with your split files.

What was the reasoning for doing this?  Did you try first on smaller table/files to see if your dump/split/restore procedure would work?

 

Igor Neyman

 

 

From: akp geek [mailto:akpgeek@gmail.com]
Sent: Monday, April 22, 2013 3:47 PM
To: Igor Neyman
Cc: pgsql-general
Subject: Re: [GENERAL] pg_restore from split files

 

pg_dump dbname -n schemaname -t table_name -Fc | split -b 500m -t table.dump

 

On Mon, Apr 22, 2013 at 3:41 PM, Igor Neyman <ineyman@perceptron.com> wrote:

How exactly did you create “split” dump?

 

Igor Neyman

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of akp geek
Sent: Monday, April 22, 2013 3:36 PM
To: pgsql-general
Subject: [GENERAL] pg_restore from split files

 

Hi All -

 

    I have created a dump of a big table into 5 split files.  What is the procedure to restore them using pg_dump.

 

I am getting the following error

 

pg_restore: [custom archiver] could not read from input file: end of file

pg_restore: *** aborted because of error

 

Appreciate your help.

 

Regards

 

pgsql-general by date:

Previous
From: akp geek
Date:
Subject: Re: pg_restore from split files
Next
From: Steven Schlansker
Date:
Subject: Re: pg_restore from split files