Respaldo y Restauracion Request Tracker 4.4.2

Respaldar RT-4.4.2 con Postgresql 9.4

# 1.1 Respaldo Forma 1

# pg_dump -i -h localhost -p 5432 -U postgres -F c -b -v -f rt4

 # 1.1 Respaldo Forma 2

# pg_dump rt4 | gzip > /tmp/rt-`date +%Y%m%d`.backup

# 1.3 Respaldo Forma 3

# pg_dump -v -U mega rt4 > /tmp/RTDBk-`date +%Y%m%d`.backup

 # 1.4 Respaldo Forma 4

# pg_dump -i -h localhost -p 5432 -U postgres -F c -b -v -f "/appl/respaldodb/RTDBk-`date +%Y%m%d`.backup" rtdb

Restaurar RT-4.4.2 con Postgresql 9.4

# 2.1 Restaurar Forma 1

# psql -h localhost -p 5432 -U postgres -d rt4 -f pg_rt4.backup

# 2.2 Restaurar Forma 2

# pg_restore -i -h localhost -p 5432 -U postgres -d rt4 pg_rt4.backup

# 2.3 Restaurar Forma 3 (Importante tomar en cuenta)

# pg_restore -i -h localhost -p 5432 -U postgres -d rt4 pg_rt4.backup

# 2.2 Restaurar Forma4

# pg_restore -i -h localhost -p 5432 -U postgres -d rt4 -v rt4