Dumping pg_shadow and pg_database as SQL using pg_dump

Поиск
Список
Период
Сортировка
От David Garamond
Тема Dumping pg_shadow and pg_database as SQL using pg_dump
Дата
Msg-id 413DBC0C.5050800@zara.6.isreserved.com
обсуждение исходный текст
Список pgsql-general
I'd like to save the list of users, groups, and databases regularly to a
separate file (just in case). The output of pg_dumpall suffices for my need:

=================================
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database
WHERE datname = 'template0');
CREATE USER ... WITH SYSID ... PASSWORD '...' NOCREATEDB NOCREATEUSER;
...

DELETE FROM pg_group;
...

CREATE DATABASE ... WITH OWNER = ... TEMPLATE = ... ENCODING = '...';
...
=================================

But can I get these with pg_dump?

--
dave


В списке pgsql-general по дате отправления:

Предыдущее
От: David Garamond
Дата:
Сообщение: Salt in encrypted password in pg_shadow
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: error: insert has more expressions than target column