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 по дате отправления