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@xxxxxxxxxxxxxx> wrote:
How exactly did you create “split” dump?
Igor Neyman
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of akp geek
Sent: Monday, April 22, 2013 3:36 PM
To: pgsql-general
Subject: 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
