Обсуждение: Moving from RHEL6 to RHEL8
Can we "just" move the database LUNs (this is on a SAN, and the servers are ESX VMs) from the old server to the new server, and then rebuild all indices with text columns? -- Angular momentum makes the world go 'round.
пт, 4 мар. 2022 г. в 22:12, Ron <ronljohnsonjr@gmail.com>:
Can we "just" move the database LUNs (this is on a SAN, and the servers are
ESX VMs) from the old server to the new server, and then rebuild all indices
with text columns?
Pretty much yes. Though we do it slightly different:
- setup physical replica on the new host
- use amcheck for all btree indexes and add those that needs reindexing to the list
- add all non-btree indexes where we can find attributes with pg_collation.collname NOT IN ('C', 'POSIX') to the same list
- run reindexing in parallel via xargs to measure time required (replica should be re-created after this of course).
Victor Yegorov
I was a storage admin for 12 years. First I would recommend backing your data on the source volume.
I have migrated data both by replication and by actually swinging the SAN volumes from one host to another. The process for Windows and Linux environments is different. I am sure there is a lot of Youtube video or article written on this subject matter.
The windows environment running SQL server was easy to swing the volume from the older OS to the new OS.
Linux environment was a little bit more challenging, but it can be done.
If it's VM, you should be able to import the volume via Vsphere, and then attach the volume to the new Linux VM. Once attached you can run lsblk, lvscan, or fdisk command to view the attached volume. You should be able to work with the device and mount the file system.
Sorry, it's been a while but I know I have moved SAN volumes in Linux.
Hope this helps.
Kishore
On Fri, Mar 4, 2022 at 12:12 PM Ron <ronljohnsonjr@gmail.com> wrote:
Can we "just" move the database LUNs (this is on a SAN, and the servers are
ESX VMs) from the old server to the new server, and then rebuild all indices
with text columns?
--
Angular momentum makes the world go 'round.