✅ 1단계: PostgreSQL 17 클라이언트 설치sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-$(rpm -E %{rhel})-x86_64/pgdg-redhat-repo-latest.noarch.rpmsudo dnf -qy module disable postgresqlsudo dnf install -y postgresql17✅ 2단계: 백업 (pg_dump 사용) - 17버전export PGPASSWORD='password'/usr/pgsql-17/bin/pg_dump \ -h 192.168.3.72 \ -p 5432 \ -U DB-User \ -d NineMemos_Dev_BC_01 \ -Fc \ ..

환경MariaDB ➡️ pgloader ➡️ postgreSQLpgloader 서버의 Migration 세부파일 내용# migration_add.loadLOAD DATABASE FROM mysql:// INTO postgresql://WITH create tables, create indexes, reset sequences, batch rows = 1000, workers = 2, concurrency = 1, multiple readers per thread, prefetch rows = 5000, foreign keysEXCLUDING TABLE NAMES MATCHING # 제외 테이블 ~/TB_/, ~/TB_/, ~/..