Re: [GENERAL] parallel dump fails to dump large tables

2015-02-25 Thread Shanker Singh
: Tom Lane; r...@iol.ie; pgsql-general@postgresql.org; Shanker Singh Subject: RE: [GENERAL] parallel dump fails to dump large tables I tried dumping the largest table that is having problem using –j1 flag in parallel dump. This time I got error on the console “File size limit exceeded” but the

Re: [GENERAL] parallel dump fails to dump large tables

2015-02-23 Thread Shanker Singh
general@postgresql.org> Subject: Re: [GENERAL] parallel dump fails to dump large tables "Raymond O'Donnell" mailto:r...@iol.ie>> writes: > On 14/02/2015 15:42, Shanker Singh wrote: >> Hi, >> I am having problem using parallel pg_dump feature in postgres >&g

Re: [GENERAL] parallel dump fails to dump large tables

2015-02-23 Thread Shanker Singh
shanker From: Sterfield [mailto:sterfi...@gmail.com] Sent: Sunday, February 22, 2015 8:50 AM To: Shanker Singh Cc: Tom Lane; r...@iol.ie; pgsql-general@postgresql.org Subject: Re: [GENERAL] parallel dump fails to dump large tables 2015-02-20 14:26 GMT-08:00 Shanker Singh mailto:ssi...@iii.com

Re: [GENERAL] parallel dump fails to dump large tables

2015-02-22 Thread Shanker Singh
sql-general@postgresql.org> Subject: Re: [GENERAL] parallel dump fails to dump large tables "Raymond O'Donnell" mailto:r...@iol.ie>> writes: > On 14/02/2015 15:42, Shanker Singh wrote: >> Hi, >> I am having problem using parallel pg_dump feature in postgres &g

Re: [GENERAL] parallel dump fails to dump large tables

2015-02-22 Thread Sterfield
or related to Postgresql. Thanks, Guillaume > -Original Message- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Saturday, February 14, 2015 9:00 AM > To: r...@iol.ie > Cc: Shanker Singh; pgsql-general@postgresql.org > Subject: Re: [GENERAL] parallel dump fails

Re: [GENERAL] parallel dump fails to dump large tables

2015-02-20 Thread Shanker Singh
ebruary 14, 2015 9:00 AM To: r...@iol.ie Cc: Shanker Singh; pgsql-general@postgresql.org Subject: Re: [GENERAL] parallel dump fails to dump large tables "Raymond O'Donnell" writes: > On 14/02/2015 15:42, Shanker Singh wrote: >> Hi, >> I am having problem us

Re: [GENERAL] parallel dump fails to dump large tables

2015-02-14 Thread Shanker Singh
Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Saturday, February 14, 2015 9:00 AM To: r...@iol.ie Cc: Shanker Singh; pgsql-general@postgresql.org Subject: Re: [GENERAL] parallel dump fails to dump large tables "Raymond O'Donnell" writes: > On 14/02/2015 15:42, Shanker Singh wrote:

Re: [GENERAL] parallel dump fails to dump large tables

2015-02-14 Thread Tom Lane
"Raymond O'Donnell" writes: > On 14/02/2015 15:42, Shanker Singh wrote: >> Hi, >> I am having problem using parallel pg_dump feature in postgres release >> 9.4. The size of the table is large(54GB). The dump fails with the >> error: "pg_dump: [parallel archiver] a worker process died >> unexpected

Re: [GENERAL] parallel dump fails to dump large tables

2015-02-14 Thread Raymond O'Donnell
On 14/02/2015 15:42, Shanker Singh wrote: > Hi, > I am having problem using parallel pg_dump feature in postgres release > 9.4. The size of the table is large(54GB). The dump fails with the > error: "pg_dump: [parallel archiver] a worker process died > unexpectedly". After this error the pg_dump ab

[GENERAL] parallel dump fails to dump large tables

2015-02-14 Thread Shanker Singh
Hi, I am having problem using parallel pg_dump feature in postgres release 9.4. The size of the table is large(54GB). The dump fails with the error: "pg_dump: [parallel archiver] a worker process died unexpectedly". After this error the pg_dump aborts. The error log file gets the following messa