PostgresSQL 8.4 Db full backup and restoring
Budget: $10 – $30 USD
PostgresSQL 8.4 Db full backup and restoring
Need to backup a DB from working server (better without stopping the DB service).
Then need to restore this DB on migrated server (the DB already exists there but has errors, so needs to be droped and restored from scratch)
DB has a lot of tables and functions.
NB: older PostgresSQL (like 7.x) knowledge is also needed (new db creating can give errors like: unknown option "stats_block_level")
also some reserach of DB structures could be needed.
PostgressSQL knowledge is a must.
Need to backup a DB from working server (better without stopping the DB service).
Then need to restore this DB on migrated server (the DB already exists there but has errors, so needs to be droped and restored from scratch)
DB has a lot of tables and functions.
NB: older PostgresSQL (like 7.x) knowledge is also needed (new db creating can give errors like: unknown option "stats_block_level")
also some reserach of DB structures could be needed.
PostgressSQL knowledge is a must.