Docker PGMASTER PostgreSQL Version Update

Hello, I will explain pgmaster postgresql version update on docker

1-similar file is uploaded to /tmp directory of the related server with scp and ftp

postgresql-12.x.xx.image.tar.gz

2-Bash shell login on the server. The following command is executed

gunzip -c /tmp/postgresql-12.x.xx.image.tar.gz |docker load

3-Which pg will be updated, if the version has changed in the relevant pg.conf file, it may be necessary to update it.

4-The following command is executed in the relevant pg directory.

make stop
make start
make logs        #pgmaster container logs are checked for any errors
make pglog     #postgresql core logs are checked for any errors
make pg-view  #With the #commands, it is ensured that the server is running correctly.
make pg-activity

pgagent notes
The pg.conf file must have the line ENABLE_PGAGENT=yes. (change to this information requires restart)
The running status of the pgagent service is checked with the pg-pgagent-isRunning command in the container.

 

 2,922 views last month,  6 views today

About tayfun inam

Computer Engineer -PostgreSql-Oracle Database Administrator I am about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 8+years experience.I have OCA,PostgreSql senior Certificates I have worked 50+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.

Leave a Reply