cat /etc/system-release
export PGDATAKEYWRAPCMD='openssl enc -e -aes-128-cbc -pass pass:ok -out %p'
export PGDATAKEYUNWRAPCMD='openssl enc -d -aes-128-cbc -pass pass:ok -in %p'
[Yesterday 2:19 PM] Mohit Gupta
/postgrebin/edb_15_installation/EDB15RHEL8/usr/edb/as15/bin
[Yesterday 2:44 PM] Mohit Gupta
rpm2cpio boost169-atomic-1.69.0-4.el8.x86_64.rpm | cpio -idmv
rpm2cpio boost169-chrono-1.69.0-4.el8.x86_64.rpm | cpio -idmv
rpm2cpio boost169-date-time-1.69.0-4.el8.x86_64.rpm | cpio -idmv
rpm2cpio boost169-filesystem-1.69.0-4.el8.x86_64.rpm | cpio -idmv
rpm2cpio boost169-program-options-1.69.0-4.el8.x86_64.rpm | cpio -idmv
rpm2cpio boost169-regex-1.69.0-4.el8.x86_64.rpm | cpio -idmv
rpm2cpio boost169-system-1.69.0-4.el8.x86_64.rpm | cpio -idmv
rpm2cpio boost169-thread-1.69.0-4.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-advanced-storage-pack1-1.0.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-advanced-storage-pack-1.1.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-pgagent-4.2.2-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-pg-cron1-1.5.2-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-pg-failover-slots1-1.0.1-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-pglogical2-2.4.2-3.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-pgpool44-extensions-4.4.2-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-pgrouting3-3.5.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-postgis33-3.3.4-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-postgis33-core-3.3.4-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-postgis33-docs-3.3.4-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-postgis33-gui-3.3.4-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-postgis33-utils-3.3.4-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-postgres-tuner1-1.1.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-query-advisor-1.0-3.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-client-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-cloneschema-1.19-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-contrib-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-core-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-devel-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-docs-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-edb_wait_states-1.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-indexadvisor-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-libs-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-llvmjit-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-parallel-clone-2.0-2.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-pldebugger-1.1-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-plperl-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-plpython3-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-pltcl-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-sqlprofiler-4.1-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-sqlprotect-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-sslutils-1.3-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-as15-server-test-15.4.0-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio edb-libicu-66.1-1.rhel8.x86_64.rpm | cpio -idmv
rpm2cpio edb-libicu66-66.1-1.rhel8.x86_64.rpm | cpio -idmv
rpm2cpio edb-livecompare-2.5.0-1.el8.noarch.rpm | cpio -idmv
rpm2cpio edb-llvm-9.0.1-5.rhel8.x86_64.rpm | cpio -idmv
rpm2cpio edb-llvm-devel-9.0.1-5.rhel8.x86_64.rpm | cpio -idmv
rpm2cpio edb-llvm-doc-9.0.1-5.rhel8.noarch.rpm | cpio -idmv
rpm2cpio edb-llvm-googletest-9.0.1-5.rhel8.x86_64.rpm | cpio -idmv
rpm2cpio edb-llvm-libs-9.0.1-5.rhel8.x86_64.rpm | cpio -idmv
rpm2cpio edb-llvm-static-9.0.1-5.rhel8.x86_64.rpm | cpio -idmv
rpm2cpio edb-llvm-test-9.0.1-5.rhel8.x86_64.rpm | cpio -idmv
rpm2cpio edb-repo-latest.noarch.rpm | cpio -idmv
rpm2cpio libpq5-15.2-42.1PGDG.rhel8.x86_64.rpm | cpio -idmv
rpm2cpio llvm14-14.0.6-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio llvm14-devel-14.0.6-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio llvm14-doc-14.0.6-1.el8.noarch.rpm | cpio -idmv
rpm2cpio llvm14-libs-14.0.6-1.el8.x86_64.rpm | cpio -idmv
rpm2cpio llvm14-static-14.0.6-1.el8.x86_64.rpm | cpio -idmv
[Yesterday 2:45 PM] Mohit Gupta
export LD_LIBRARY_PATH=/postgrebin/edb_15_installation/EDB15RHEL8/usr/edb/as15/lib/:/postgrebin/edb_15_installation/EDB15RHEL8/usr/lib64/llvm5.0/lib/:/postgrebin/edb_15_installation/EDB15RHEL8/usr/libexec/edb-icu66/lib/:/postgrebin/edb_15_installation/EDB15RHEL8/usr/edb/as15/lib64:/postgrebin/edb_15_installation/EDB15RHEL8/usr/lib64:$LD_LIBRARY_PATH
export PGBIN=/postgrebin/edb_15_installation/EDB15RHEL8/usr/edb/as15/bin
export PGDATAKEYWRAPCMD='openssl enc -e -aes-128-cbc -pbkdf2 -pass pass:ok -out %p'
export PGDATAKEYUNWRAPCMD='openssl enc -d -aes-128-cbc -pbkdf2 -pass pass:ok -in %p'
export PGDATAKEYUNWRAPCMD='openssl enc -d -aes-128-cbc -pass pass:ok -in %p -md md5'
./pg_upgrade --copy-by-block -b /postgrebin/edb_12_installation/usr/edb/as12/bin/ -B /postgrebin/edb_15_installation/EDB15RHEL8/usr/edb/as15/bin/ -d /postgresdata/PostgresPlus_12/12AS/data -D /postgresdata/PostgresPlus_15/15AS/data -p 5444 -P 5445 -U enterprisedb -v –check
./pg_upgrade --copy-by-block -d /postgresdata/PostgresPlus_12/12AS/data -D /postgresdata/PostgresPlus_15/15AS/data -b /postgrebin/edb_12_installation/usr/edb/as12/bin/ -B /postgrebin/edb_15_installation/EDB15RHEL8/usr/edb/as15/bin/ -p 5444 -P 5445 -U enterprisedb -v --check
/postgrebin/edb_12_installation/usr/edb/as12/bin/pg_basebackup -D /postgresdata_upgrade/PostgresPlus_12/12AS/data -T /postgresdata/PostgresPlus_12/tablespaces/new_table_space=(new)/data/PostgresPlus_12/12AS/tablespaces/new_table_space -T /postgresdata/PostgresPlus_12/tablespaces/primedb_tbs=/data/PostgresPlus_12/12AS/tablespaces/primedb_tbs -T /postgresdata/PostgresPlus_12/tablespaces/primedb_tbs_new=/data/PostgresPlus_12/12AS/tablespaces/primedb_tbs_new -T /postgresdata/PostgresPlus_12/tablespaces/primesmk_tbs=/data/PostgresPlus_12/12AS/tablespaces/primesmk_tbs -T /postgresdata/PostgresPlus_12/tablespaces/primestg_tbs=/data/PostgresPlus_12/12AS/tablespaces/primestg_tbs -T /postgresdata/PostgresPlus_12/tablespaces/prime4_tbs=/data/PostgresPlus_12/12AS/tablespaces/prime4_tbs -c fast -N -P -v -p 5444
Without TDE: -
/postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/bin ---->bin
/postgresdata/PostgresPlus/15AS/data --->data
export PGBIN=/postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/bin
export PGDATA=/postgresdata/PostgresPlus/15AS/data
export LD_LIBRARY_PATH=/postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/lib/:/postgrebin/EDB15/EDB15RHEL8/usr/lib64/llvm5.0/lib/:/postgrebin/EDB15/EDB15RHEL8/usr/libexec/edb-icu66/lib/:/postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/lib64:/postgrebin/EDB15/EDB15RHEL8/usr/lib64:$LD_LIBRARY_PATH
4. ./initdb --locale=en_US.utf8 -E UTF8 -D $PGDATA --->check US or IN in edb 12 before running
./pg_ctl -D /postgresdata/PostgresPlus/15AS/data -l logfile start
/postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/bin/edb-postgres -D /postgresdata/PostgresPlus/15AS/data
en_US.UTF-8
./pg_upgrade -d /postgresdata/PostgresPlus/12AS/data -D /postgresdata/PostgresPlus/15AS/data -b /postgrebin/edb_12_installation/usr/edb/as12/bin/ -B /postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/bin/ -p 5444 -P 5445 -U enterprisedb -v --check
./pg_upgrade -d /postgresdata/PostgresPlus/12AS/data -D /postgresdata/PostgresPlus/15AS/data -b /postgrebin/edb_12_installation/usr/edb/as12/bin/ -B /postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/bin/ -p 5444 -P 5445 -U enterprisedb -v
/postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/bin/vacuumdb -U enterprisedb --all --analyze-in-stages
#Seting LD_LIBRARY_PATH
Environment=LD_LIBRARY_PATH=/postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/lib/:/postgrebin/EDB15/EDB15RHEL8/usr/lib64/llvm5.0/lib/:/postgrebin/EDB15/EDB15RHEL8/usr/libexec/edb-icu66/lib/:/postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/lib64:/postgrebin/EDB15/EDB15RHEL8/usr/lib64:$LD_LIBRARY_PATH
Environment=PGDATA=/postgresdata/PostgresPlus/15AS/data
PIDFile=/postgresdata/PostgresPlus/15AS/data/postmaster.pid
ExecStartPre=/postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/bin/edb-as-15-check-db-dir ${PGDATA}
ExecStart=/postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/bin/edb-postmaster -D ${PGDATA}
mkdir -p /usr/libexec/edb-as15-icu66.1/lib/
cp /postgrebin/EDB15/EDB15RHEL8/usr/libexec/edb-icu66/lib/* /usr/libexec/edb-as15-icu66.1/lib/
chcon -R -t bin_t /postgrebin/EDB15/EDB15RHEL8/usr/edb/as15/bin/
systemctl enable edb-as-15.service
systemctl start edb-as-15.service
chmod 777 edb-as-15.service
With TDE :
/postgrebin/edb_12_installation/usr/edb/as12/bin/edb-postmaster -D /postgresdata/PostgresPlus_12/12AS/data
/postgrebin/EDB15/usr/edb/as15/bin/edb-postgres -D /postgresdata/PostgresPlus_15/15AS/data
/postgrebin/EDB15/usr/edb/as15/bin -->bin
/postgresdata/PostgresPlus_15/15AS/data --->data
export PGBIN=/postgrebin/EDB15/usr/edb/as15/bin
export PGDATA=/postgresdata/PostgresPlus_15/15AS/data
export LD_LIBRARY_PATH=/postgrebin/EDB15/usr/edb/as15/lib/:/postgrebin/EDB15/usr/lib64/llvm5.0/lib/:/postgrebin/EDB15/usr/libexec/edb-icu66/lib/:/postgrebin/EDB15/usr/edb/as15/lib64:/postgrebin/EDB15/usr/lib64:$LD_LIBRARY_PATH
export PGDATAKEYWRAPCMD='openssl enc -e -aes-128-cbc -pbkdf2 -pass pass:ok -out %p'
export PGDATAKEYUNWRAPCMD='openssl enc -d -aes-128-cbc -pbkdf2 -pass pass:ok -in %p'
./initdb -y --locale=en_US.utf8 -E UTF8 -D $PGDATA
./pg_ctl -D /postgresdata/PostgresPlus_15/15AS/data -l logfile start
./pg_upgrade --copy-by-block -d /postgresdata/PostgresPlus_12/12AS/data -D /postgresdata/PostgresPlus_15/15AS/data -b /postgrebin/edb_12_installation/usr/edb/as12/bin/ -B /postgrebin/EDB15/usr/edb/as15/bin/ -p 5444 -P 5445 -U enterprisedb -v --check
nohup ./pg_upgrade --copy-by-block -d /postgresdata/PostgresPlus_12/12AS/data -D /postgresdata/PostgresPlus_15/15AS/data -b /postgrebin/edb_12_installation/usr/edb/as12/bin/ -B /postgrebin/EDB15/usr/edb/as15/bin/ -p 5444 -P 5445 -U enterprisedb -v &
data_encryption_key_unwrap_command = 'openssl enc -d -aes-128-cbc -pass pass:ok -in %p'