Thread: 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
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
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
On Sep 22, 2006, at 3:20 AM, Alain Roger wrote:
When i migrate my DB to another computer, should i recreate all roles manually ?
either that or use this command to dump the roles as an SQL file you can feed into the new server. it will complain about trying to recreate the superuser, but that's ignorable:
pg_dumpall --globals-only -U ${pguser} > users.sql
where pguser is defined as the postgres superuser you use.