Re: Dumping roles improvements?
| От | Pavel Stehule |
|---|---|
| Тема | Re: Dumping roles improvements? |
| Дата | |
| Msg-id | CAFj8pRCwYkaM+8WB6hQZSgfUh1AidqXdWv4_CKrT3deH5DoV4A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Dumping roles improvements? (Josh Berkus <josh@agliodbs.com>) |
| Список | pgsql-hackers |
Hello 2011/10/11 Josh Berkus <josh@agliodbs.com>: > It occurs to me that we could really use two things to make it easier to > move copies of database stuff around: > > pg_dump -r, which would include a CREATE ROLE for all roles needed to > restore the database (probably without passwords), and > > pg_dumpall -r --no-passwords which would dump the roles but without > CREATE PASSWORD statements. This would be useful for cloning databases > for use in Dev, Test and Staging, where you don't what to copy the md5s > of passwords for possible cracking. > maybe some switch for "complete" dump of one database with related roles. Pavel > -- > Josh Berkus > PostgreSQL Experts Inc. > http://pgexperts.com > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >
В списке pgsql-hackers по дате отправления: