Dumping roles improvements?

Поиск
Список
Период
Сортировка
Искать
От
Josh Berkus
Тема
Dumping roles improvements?
Дата
Msg-id
4E939365.308@agliodbs.com
Список
Дерево обсуждения
Dumping roles improvements? Josh Berkus <josh@agliodbs.com>
Re: Dumping roles improvements? Bruce Momjian <bruce@momjian.us>
Re: Dumping roles improvements? Andrew Dunstan <andrew@dunslane.net>
Re: Dumping roles improvements? Bruce Momjian <bruce@momjian.us>
Re: Dumping roles improvements? Josh Berkus <josh@agliodbs.com>
Re: Dumping roles improvements? Bruce Momjian <bruce@momjian.us>
Re: Dumping roles improvements? Josh Berkus <josh@agliodbs.com>
Re: Dumping roles improvements? Bruce Momjian <bruce@momjian.us>
Re: Dumping roles improvements? Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: Dumping roles improvements? Andrew Dunstan <andrew@dunslane.net>
Re: Dumping roles improvements? Josh Berkus <josh@agliodbs.com>
Re: Dumping roles improvements? Tom Lane <tgl@sss.pgh.pa.us>
Re: Dumping roles improvements? Josh Berkus <josh@agliodbs.com>
Re: Dumping roles improvements? Tom Lane <tgl@sss.pgh.pa.us>
Re: Dumping roles improvements? Josh Berkus <josh@agliodbs.com>
Re: Dumping roles improvements? Andrew Dunstan <andrew@dunslane.net>
Re: Dumping roles improvements? Andrew Dunstan <andrew@dunslane.net>
Re: Dumping roles improvements? Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: Dumping roles improvements? Tom Lane <tgl@sss.pgh.pa.us>
Re: Dumping roles improvements? Andrew Dunstan <andrew@dunslane.net>
Re: Dumping roles improvements? Pavel Stehule <pavel.stehule@gmail.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.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

В списке pgsql-hackers по дате отправления
От: Peter Geoghegan
Дата:
От: Robert Haas
Дата:
FAQ