Re: Taking backup of login roles in postgresql 8.2

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: Taking backup of login roles in postgresql 8.2
Дата
Msg-id Pine.LNX.4.64.0710241959220.29776@discord.home.frostconsultingllc.com
обсуждение исходный текст
Ответ на Taking backup of login roles in postgresql 8.2  (arun <arunpjohny@gmail.com>)
Список pgsql-admin
Arun,

You have to use pg_dumpall with the --globals setting like so:

pg_dumpall --globals > globals.sql

or pass it through gzip first:

pg_dumpall --globals | gzip > globals.sql.gz


On Thu, 25 Oct 2007, arun wrote:

> Hi all,
>    I'm new to this forum. Can any one tell me how to take backup of login
> roles in postgresql.
> I know how to take database backup. It is giving me all the schemas in the
> selected database, but not creating the login roles required when restoring
> the database
>
> Thank you
>

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

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

Предыдущее
От: arun
Дата:
Сообщение: Taking backup of login roles in postgresql 8.2
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: l need help