Postgres Pro
Downloads
Home   >   mailing lists

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

From akp geek
Subject Re: pg_restore from split files
Date
Msg-id CACnhOfKPO0e9YpKzv6P_rWw3mA7YvQevxyhWDQCmGP3e4cMJrA@mail.gmail.com
Whole thread Raw
In response to Re: pg_restore from split files  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: pg_restore from split files
Re: pg_restore from split files
List pgsql-general
Tree view
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: Igor Neyman
Date:
Subject: Re: pg_restore from split files
Next
From: Igor Neyman
Date:
Subject: Re: pg_restore from split files