Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup roles / users - Mailing list pgsql-general

From Matthias.Pitzl@izb.de
Subject Re: Backup roles / users
Date
Msg-id 11EC9A592C31034C88965C87AF18C2A70CFC63@m0000s61
Whole thread Raw
In response to Backup roles / users  ("Alain Roger" <raf.news@gmail.com>)
List pgsql-general
Tree view
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-----
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

Hi,

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 by date:

Previous
From: "Alain Roger"
Date:
Subject: Backup roles / users
Next
From: Matthias.Pitzl@izb.de
Date:
Subject: Re: Strange database corruption with PostgreSQL 7.4.x o