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:[email protected]] 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 <[email protected]<mailto:[email protected]>> wrote: How exactly did you create "split" dump? Igor Neyman From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] 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
