| From: | Dmitry Voronin <carriingfate92(at)yandex(dot)ru> |
|---|---|
| To: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | pg_dump |
| Date: | 2015-10-28 07:44:37 |
| Message-ID: | 2113521446018277@web20g.yandex.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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's not good.
--
Best regards, Dmitry Voronin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2015-10-28 07:58:58 | Re: [PROPOSAL] Max recursion depth in WITH Queries (Common Table Expressions) |
| Previous Message | Valery Popov | 2015-10-28 07:33:19 | [PROPOSAL] Max recursion depth in WITH Queries (Common Table Expressions) |