On 08/12/2023 09:43, Rajesh Kumar wrote:
Hi
We are using openshift environment and postgres version 15.2. We want
to change storage from ceph to local storage. So, Storage team made
default storage as local. Now, I created a new cluster with same
postgres version and I am planning to take backup from old cluster to
new cluster. Size is 100gb. Ram 24gb, cpu 2.
My question is, is there a combination of pg_dump and pg_restore that
takes less time to complete the task?
Last time it took more than 8hours. We were taking schema only dump
using dumpall . Then data only backup using pg_dump in directory format.
If you are using the same (major) version of PostgreSQL, you are moving
the whole cluster, and can stop the services on both ends first, then
you can:
- stop the services (both old and new)
- empty the data directory in the new location
- copy the whole data directory from the old location to the new
location (using copy, rsync, scp, whatever)
- start the service on the new location
Obviously backup everything before doing anything destructive.
If you want to do it while the database is still running, then use
replication and fail-over instead.
Paul
