Versions Compared

Old Version 2

changes.mady.by.user Chandresh Patel

Saved on

compared with

New Version Current

changes.mady.by.user Keith Ecker

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
drop user fd cascade;
drop user ff cascade;
drop user fd_admin cascade;

Import data from backup directory (PostgreSQL)

Code Block
languagebash
sudo su - postgres
 
/usr/pgsql-12/bin/psql -U postgres -p 5436 -d flexdeploy -f input.bkp | tee logfile.outpg_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)

Code Block
languagebash
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 from backup (Oracle)

...