Skip site navigation (1) Skip section navigation (2)

Restoring roles information

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Restoring roles information
Date: 2012-03-27 22:52:37
Message-ID: CAAY=A7_TFXiQCqwJmNmvxTQuQbOObBZHYkNv2VZkdwu3AnMexg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I am upgrading from PostgreSQL v9.0 to v9.1 and I have a plain format
backup. I reviewed the backup file and I see that it contains everything
except the creation of "login roles" and "group roles".

Is there a way to include the creation of roles in a backup or do I have to
create them manually before performing the restore operation?

Respectfully,
Jorge Maldonado

Responses

pgsql-novice by date

Next:From: Steve CrawfordDate: 2012-03-27 23:04:11
Subject: Re: Restoring roles information
Previous:From: Rob RichardsonDate: 2012-03-23 18:06:29
Subject: Re: Define a function that accepts query result as a parameter

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group