Re: Backup roles / users
От
Matthias.Pitzl@izb.de
Тема
Re: Backup roles / users
Дата
Msg-id
11EC9A592C31034C88965C87AF18C2A70CFC63@m0000s61
Список
Дерево обсуждения
Backup roles / users "Alain Roger" <raf.news@gmail.com>
Re: Backup roles / users Vivek Khera <vivek@khera.org>
Hi Alain!
To get all the users and so on to the other machine, you have to use the pg_dumpall tool with the -g switch. This will dump out all the users, groups and roles i think.
-- Matthias
-----Original Message-----Hi,
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Alain Roger
Sent: Friday, September 22, 2006 9:20 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Backup roles / users
I've checked in pg_dump and i did not find anything regarding backuping roles ?
When i migrate my DB to another computer, should i recreate all roles manually ?
thx.
Alain
В списке pgsql-general по дате отправления
От: Matthias.Pitzl@izb.de
Дата:
