[GENERAL] pg_restore from split files

2013-04-22 Thread akp geek
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.

Re: [GENERAL] pg_restore from split files

2013-04-22 Thread Igor Neyman
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

Re: [GENERAL] pg_restore from split files

2013-04-22 Thread akp geek
-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

Re: [GENERAL] pg_restore from split files

2013-04-22 Thread Igor Neyman
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 iney...@perceptron.commailto:iney...@perceptron.com wrote: How exactly did you create split

Re: [GENERAL] pg_restore from split files

2013-04-22 Thread Steven Schlansker
: 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

Re: [GENERAL] pg_restore from split files

2013-04-22 Thread akp geek
” 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