PostgreSQL yana ba da hanyoyi da yawa na jiyya — jiyyoyi masu hankali (pg_dump) da jiyyoyi jiki (tushen jiyya + WAL don sake dawo zuwa lokaci daidai). Dabarar jiyya-da-sake-dawo mai ƙarfi tana da mahalaci wajen karewa daga riba data, kuma a maimaitawa, dole ne a gwada jiyyoyi.
Jiyyoyi masu hankali — pg_dump
pg_dump -U user -d mydb -F c -f backup.dump
pg_dump -U user -d mydb > backup.sql
pg_dumpall > all.sql
pg_restore -U user -d mydb backup.dump
psql -U user -d mydb -f backup.sql
