Postgres Pro
Downloads
Home   >   mailing lists

pg_dump - Mailing list pgsql-hackers

From Dmitry Voronin
Subject pg_dump
Date
Msg-id 2113521446018277@web20g.yandex.ru
Whole thread Raw
Responses Re: pg_dump  (Noah Misch <noah@leadboat.com>)
List pgsql-hackers
Tree view 
Hello, guys.

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.
 

-- 
Best regards, Dmitry Voronin

pgsql-hackers by date:

Previous
From: Valery Popov
Date:
Subject: [PROPOSAL] Max recursion depth in WITH Queries (Common Table Expressions)
Next
From: Pavel Stehule
Date:
Subject: Re: [PROPOSAL] Max recursion depth in WITH Queries (Common Table Expressions)