Re: [GENERAL] pg_restore from split files

2013-04-22 Thread akp geek
It works ... " combine them again. " Thank you all Regards On Mon, Apr 22, 2013 at 3:57 PM, Steven Schlansker wrote: > > On Apr 22, 2013, at 12:47 PM, akp geek wrote: > > > pg_dump dbname -n schemaname -t table_name -Fc | split -b 500m -t > table.dump > > Since you split the files outside

Re: [GENERAL] pg_restore from split files

2013-04-22 Thread Steven Schlansker
On Apr 22, 2013, at 12:47 PM, akp geek 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 t

Re: [GENERAL] pg_restore from split files

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

Re: [GENERAL] pg_restore from split files

2013-04-22 Thread akp geek
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 wrote: > How exactly did you create “split” dump? > > ** ** > > Igor Neyman > > ** ** > > *From:* pgsql-general-ow...@postgresql.org [mailto: > pgsql-general-ow...@

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 a du