There is no problem dumping large tables using parallel dump. My script had
limit on the file size that was causing parallel dump to abort on large tables.
Thanks everyone for their valuable suggestion.
Thanks
shanker
From: Shanker Singh
Sent: Monday, February 23, 2015 6:18 PM
To: Sterfield
Cc
vmemoryuse unlimited
descriptors 25000
memorylocked 64 kbytes
maxproc 1024
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
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
postgresql server
with
Command similar to “nohup ./postages_dumpdb &”;
Thanks
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 l
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
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:
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
