Reducing pg_dumpall errors

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>
To: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Date: 2012-12-04T03:37:21Z
Lists: pgsql-hackers

Attachments

I recently applied the attached patch to prevent recreation of the
current database user in the dump file when in binary upgrade mode. 
This was necessary because pg_upgrade will fail on any error from a
pg_dumpall restore.

It would be nice of we could do the same for non-binary-upgrade
pg_dumpall dumps, but I assume we can't because the restore might be
performed by a super user who is different from the dump user, right?

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +