Database Backup and Restore Procedure

perform the following steps only if the database backup is required backing up database switch user to enterprisedb \[root\@kronpam ]# su – enterprisedb set the password variable \[enterprisedb\@kronpam ]$ export pgpassword="1qaz2wsx" export the radius schema \[enterprisedb\@kronpam ]$ /u01/postgresplus/9 5as/bin/pg dump p 5444 w u enterprisedb n radius fp f "backup schema radius dmp" aioc export the aioc schema \[enterprisedb\@kronpam ]$ /u01/postgresplus/9 5as/bin/pg dump p 5444 w u enterprisedb n aioc fp f "backup schema aioc dmp" aioc restoring database to import a database, you need to install a new database and remove the default kron pam parameters or existing schemas set password variable \[enterprisedb\@kronpam ]$ export pgpassword="1qaz2wsx" connect to the new database and create users change the passwords with proper values \[enterprisedb\@kronpam ]$ /psql p 5444 d edb u enterprisedb edb=# create role aioc login password ‘aioc’ superuser inherit createdb createrole replication; edb=# create role radius login password ‘radius’ superuser inherit createdb createrole replication; edb=# alter role aioc set search path = "$user", public, radius; edb=# alter role radius set search path = "$user", aioc, public; create aioc table edb=# create database aioc with owner = aioc encoding = 'utf8' tablespace = pg default lc collate = 'en us utf8' lc ctype = 'en us utf8' connection limit = 1; import schemas \[enterprisedb\@kronpam ]$ /psql p 5444 d aioc u enterprisedb f "backup schema radius dmp" \[enterprisedb\@kronpam ]$ /psql p 5444 d aioc u enterprisedb f "backup schema aioc dmp"