It works ... " combine them again. " Thank you all Regards
On Mon, Apr 22, 2013 at 3:57 PM, Steven Schlansker <ste...@likeness.com>wrote: > > On Apr 22, 2013, at 12:47 PM, akp geek <akpg...@gmail.com> wrote: > > > pg_dump dbname -n schemaname -t table_name -Fc | split -b 500m -t > table.dump > > Since you split the files outside of the Postgres world, you have to > combine them again. Roughly, > > cat table.dump.* > table.dump.combined > pg_restore --usual-arguments table.dump.combined > > > > On Mon, Apr 22, 2013 at 3:41 PM, Igor Neyman <iney...@perceptron.com> > wrote: > > How exactly did you create “split” dump? > > > > > > > > Igor Neyman > > > > > > > > From: pgsql-general-ow...@postgresql.org [mailto: > pgsql-general-ow...@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 > > > > > >
