Restoring Users and Roles

To restore roles and users to a PostgreSQL Cluster, the roles.sql file located in /@PG/<service>/roles.sql needs to be selected.

Then, using where=/ or where=, the Plugin will load this SQL file to the database. If some roles already exist, errors will be printed to the Job log.

Note

It is possible to restore the roles.sql file to a local directory, edit it, and load it using psql to restore only a selection of its original contents.

PostgreSQL Cluster Contents During Restore

See also

Go to:

• Restoring Database Structure

• Restoring Single Database

• Restoring Dump Files To Directory

• Restoring Single Table

Go back to the Restoring Using Dumps page.

Go back to the Restore page.

Go back to the main Operations page.