On 04/14/2016 07:28 PM, David Steele wrote:
As far as I know pg_dump share locks everything before it starts so there shouldn't be issues with concurrent DDL. Try creating a new inherited table with FKs, etc. during a pg_dump and you'll see lots of fun lock waits.
I am pretty sure that it does not lock functions, types or casts. So if you rename a function during pg_dump there should be a risk of getting a backup which will fail on restore.
Andreas -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers