Re: Postgres storage migration
| От | Rajesh Kumar |
|---|---|
| Тема | Re: Postgres storage migration |
| Дата | |
| Msg-id | CAJk5AtbewU4nZhJhVT2mK6_kU01Lotr=38ck311MjCEwoEcr5Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Postgres storage migration (Scott Ribe <scott_ribe@elevated-dev.com>) |
| Список | pgsql-admin |
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 по дате отправления: