Backup Restore PostgreSQL using Pgbasebackup in windows server 2019 скачать в хорошем качестве

Backup Restore PostgreSQL using Pgbasebackup in windows server 2019

WELCOME TO MY CHANNEL: IT SILENT Restore Database Postgresql 14 using new_port (other than port 5432) in Windows Server 2019 Open Command Prompt (cmd): A. Backup pgbasebackup: ----------------------- cd C:\postgres14\bin\ pg_basebackup.exe -h localhost -p 5432 -U postgres -D "C:\backup\bck_20240419" -Fp -Xs -P --checkpoint=fast B. Restore: (using new_port) ----------------------------------------- 1. Make New Folder example in drive C: create folder: postgres5433 2. stop service database port 5432 cd C:\postgres14\bin pg_ctl.exe stop -D C:\postgres14\data 3. copy contents folder postgres14 to postgres5433 and delete contents in folder postgres5433\data replice with content backup ( Point A) 4. start service database port 5432 cd C:\postgres14\bin pg_ctl.exe start -D C:\postgres14\data 5. Grant postgres5433 (create using command prompt) icacls "C:\postgres5433" /grant Users:(OI)(CI)F /T 6. Edit port in file /postgres5433/data/postgresql.conf change port 5432 to port 5433 7. start database port 5433 cd C:\postgres5433\bin pg_ctl.exe start -D C:\postgres5433\data pg_ctl.exe status -D C:\postgres5433\data 8. Test connect using pg_admin Success Done!!! THANKS FOR WATCHING !!! BYE