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.

 

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.

One comment

  1. For better work with the PostgreSQL database, it’s good to use ado net postgresql.

Leave a Reply

Your email address will not be published. Required fields are marked *