...
| Code Block |
|---|
drop user fd cascade; drop user ff cascade; drop user fd_admin cascade; |
Import data from backup directory (PostgreSQL) - If you used the automated installer and specified a backup directory, or you used pg_dump
| Code Block | ||
|---|---|---|
| ||
if you used pg_dump (what the automated installer uses when you specify the backup directory in your config file) pg_restore --host ${HOST} --port ${PORT} --schema FD --username postgres -W --verbose --format d --file ${PATH/TO/BACKUP}/FD flexdeploy pg_restore --host ${HOST} --port ${PORT} --schema FF --username postgres -W --verbose --format d --file ${PATH/TO/BACKUP}/FF flexdeploy pg_restore --host ${HOST} --port ${PORT} --schema FD_ADMIN --username postgres -W --verbose --format d --file ${PATH/TO/BACKUP}/FD_ADMIN flexdeploy |
Import data from backup schema (PostgreSQL) - If you used the automated installed and omitted backup directory
| Code Block | ||
|---|---|---|
| ||
sudo su - postgres
psql --host ${HOST} --port ${PORT} -d flexdeploy
alter schema FD_bak rename to FD
alter schema FF_bak rename to FF
alter schema FD_ADMIN_bak rename to FD_ADMIN |
Import data (PostgreSQL) from pg_dumpall
| Code Block |
|---|
psql -U postgres --host ${HOST} --port ${PORT} < fd_db_bkp.bkp
#or if it was gz compressed dumpall,
gunzip -c fd_db_bkp.bkp.gz | psql -U postgres --host ${HOST} --port ${PORT} |
Import data from backup (Oracle)
...