Environment Requirements

This section describes the environment requirements for migrating the PostgreSQL database from the x86 server (as the original primary database) to the Kunpeng server (as the new primary database), and changing the database on the x86 server to the secondary database.

Hardware and OS Requirements

Table 1 shows the hardware and OS requirements.

**Table 1** Hardware and OS requirements
Component	x86 Server (Original Primary Database)	Kunpeng Server (New Primary Database)
CPU	Intel® Xeon® Gold 5218R Processor at 2.10 GHz	Kunpeng 920 5220 at 3.0 GHz
Memory	24 x 32 GB x 2666 MT/s DDR4	8 x 32 GB x 2933 MT/s DDR4
Drive	System drive: 600 GB SAS HDD Data drive: 1 x 1.0 TB NVMe SSD	System drive: 600 GB SAS HDD Data drive: 1 x 570 GB NVMe SSD
NIC	1 x 10 Gbit/s	1 x 10 Gbit/s
OS	CentOS 8	openEuler 22.03 LTS SP2

Software Requirements

Table 2 shows the software requirements.

**Table 2** Software requirements
Software	Version	Download URL
PostgreSQL	13.x or 15.x. 13.2 is used in this document.	https://ftp.postgresql.org/pub/source/v13.2/postgresql-13.2.tar.gz
pg_basebackup pg_verify_checksum	Same as the version of PostgreSQL. They are verification tools built in the PostgreSQL installation package.

Planning Nodes for PostgreSQL Primary/Secondary Replication

Figure 1 and Table 3 show the node planning for PostgreSQL primary/secondary replication.

Figure 1 Switchover of primary/secondary databases

**Table 3** Node planning details
IP Address	Architecture	Database (Before Switchover)	Database (Kunpeng Node Added)	Database (After Switchover)
192.168.0.1	x86	Primary database	New secondary database 1	-
192.168.0.2	x86	Secondary database 1 (x86)	Secondary database 1 (x86)	Secondary database 1 (x86)
192.168.0.3	Arm	Secondary database 2 (Kunpeng)	New primary database (Kunpeng)	New primary database (Kunpeng)
192.168.0.4	Arm	-	-	New secondary database 2 (Kunpeng)

Parent topic: Best Practices of Migration