Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres storage migration - Mailing list pgsql-admin

From Rajesh Kumar
Subject Re: Postgres storage migration
Date
Msg-id CAJk5AtbewU4nZhJhVT2mK6_kU01Lotr=38ck311MjCEwoEcr5Q@mail.gmail.com
Whole thread Raw
In response to Re: Postgres storage migration  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
Error with pg_restore is secondary. Let's forget that for now. 

I am using Openshift platform, ceph storage. We are changing the storage to local. So, we created a cluster in new Local storage. All I want to know is how to migrate data from one cluster to another cluster in less downtime. 100gb is taking more than 8hrs for backup and restore.

1. Pg_dump and pg_restore good? If so directory format or which format is good? 
2. Or pgbasebackup is possible in a customised Openshift env?


On Sat, 9 Dec, 2023, 9:42 PM Scott Ribe, <scott_ribe@elevated-dev.com> wrote:
> On Dec 8, 2023, at 7:56 PM, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
>
> We are facing error while restoring

What error?

It would really help if you'd give us the full information, instead of having us drag it out of you one tidbit at a time.

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0
Next
From: "Md. Ezhar Ansari"
Date:
Subject: Re: Inquiry Regarding Automatic Tuning Features in PostgreSQL