Search Postgresql Archives
Recommendations for postgres upgrade of database with lobs
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-general@xxxxxxxxxxxxxx
- Subject: Recommendations for postgres upgrade of database with lobs
- From: "CAJ CAJ" <pguser@xxxxxxxxx>
- Date: Fri, 9 Mar 2007 21:01:41 -0800
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=DLPUKmHj7C24Setbl1neEfn4nqWIV5YlQXTDGQGx4EQQXM6yNG8QaR3JqTc63H2QXGPfZMkAuh0tE05fQnlbmueTGRy+y2mPUQlxG/izUeJvxh14ROo+TYY6S6cvvA+MI7WSIrIfU8c//XaHTnRDJo95rTmf0Kv0u1aMbxsrNGs=
Hello,
We have several independent database servers with ~50GB+ databases running postgres 8.0.x. We are planning to upgrade these databases to postgres 8.2.x over the weekend
We plan to use the following steps to upgrade each server,
1. Dump the 8.0.x database cluster using 8.2.x pg_dumpall
% ./pg_dumpall > pgdumpall_backup.sql
2.Dump the 8.0.x database including large objects in compressed custom format using 8.2.x pg_dump
% ./pg_dump -Fc -b -Z9 dbname > pgdump_lobs_backup
Restoring database
1. Initialize 8.2.x darabase
% initdb -D /data/pgdata
2. Restore template1 database from cluster dump
% ./psql -d template1 < pgdumpall_backup.sql
3. Delete database dbname else restoring will give error about existing dbname
% dropdb dbname
4. Create fresh dbname
% createdb -O dbowner dbname
5. Restore database with lobs
% ./pg_restore -v -Fc -d dbname -e -U dbowner < pgdumpall_lobs_backup
Some of the problems we have are,
1. We are not sure if all of the data will be available after dump/restore with above process
2. The dump and restore process is very very slow to be complete over the weekend (takes approx 1GB/hr to dump on a dual G5 PPC 2Ghz with 1GB RAM and RAID 1 disks)
What is the fastest way to upgrade postgres for large databases that has binary objects?
Thanks for all your help.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]