Re: pg_dump

On Wed, Oct 28, 2015 at 10:44:37AM +0300, Dmitry Voronin wrote:
> I have a database testdb with commet 'test comment' and security label 'classified'. I create dump by pg_dump:
> 
> pg_dump -h 127.0.0.1 -d testdb -U postgres --format c dump
> 
> So, I want to restore a dump with comment and security label to testdb_restore. I run:
> 
> pg_restore -h 127.0.0.1 -d testdb_restore dump
> 
> So, we have, that SECURITY LABEL and COMMENT will be applied to database testdb but not testdb_restore. I think, that
it'snot good.
 

It's a problem.  See this recent discussion:
http://www.postgresql.org/message-id/flat/20150710115735.GH26521@alap3.anarazel.de