pg_dump - groups and users.

Поиск
Список
Период
Сортировка
От John Herreshoff
Тема pg_dump - groups and users.
Дата
Msg-id 200202181527.g1IFRTg26717@mail3.centurytel.net
обсуждение исходный текст
Ответы Re: pg_dump - groups and users.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
How does one cause pg_dump to save groups and users in the backup file?

If I use -C to create the database, psql complains that it cannot find such
and such a group or user.   psql builds the database, of course, but there
are no groups or users in the database.

Using -C with pg_restore causes pg_restore to quite when it cannot find the
first user.

Of course if I run pg_dump without the -C, and then create the database,
groups, and users, and then run psql, everything is fine.  Considering that
I'll have about 150 + users, I'd really like to have the backup contain users
and groups.

Is there a trick or switch that I've over looked?

John.

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

Предыдущее
От: Ivan Horvath
Дата:
Сообщение: timestamp default value
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump - groups and users.