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.
For better work with the PostgreSQL database, it’s good to use ado net postgresql.