We have several Postgres 9.4 databases on Solaris 10 that are structural clones but with different data . While running multiple concurrent pg_dump exports for these databases, we get sporadic errors like this:
pg_dump: dumping contents of table attachment
pg_dump: [custom archiver] could not write to output file: Permission denied
pg_dump: *** aborted because of error
This is after successfully dumping several tables. The table that triggers the failure varies from run to run, and is not (or, so far has not been) the first table processed. These failures only occur during concurrent runs – we have not seen them when we single-thread the pg_dump exports.
The command used to invoke pg_dump is as follows:
${currentCodeDir}/thirdPartyLinks/postgres/bin/pg_dump --file=${currentDataDir}/${db_name}.dmp --format=custom --host=${PostgreSQLServer} --port=${db_port} --username=xxxx --no-privileges --verbose ${db_name}
Any ideas?
Michael Tefft
Snap-on Business Solutions
4025 Kinross Lakes Parkway
Richfield, OH 44286
330-659-1840
Michael.J.Tefft@snapon.com