| From: | Noah Misch <noah(at)leadboat(dot)com> |
|---|---|
| To: | Dmitry Voronin <carriingfate92(at)yandex(dot)ru> |
| Cc: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_dump |
| Date: | 2015-10-29 02:51:37 |
| Message-ID: | 20151029025137.GA771227@tornado.leadboat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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's not good.
It's a problem. See this recent discussion:
http://www.postgresql.org/message-id/flat/20150710115735(dot)GH26521(at)alap3(dot)anarazel(dot)de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2015-10-29 03:16:28 | Small improvement to tlist_matches_tupdesc() |
| Previous Message | Tom Lane | 2015-10-29 02:30:12 | Re: Personal note: changing employers |