hi all,
we have Foreman 3.6.1 and Postgres 10(service started) and 12(service stopped)!
I dont understand why we have two versions of Postgresql ?
Now the version 10 is started like below:
# systemctl status postgresql@10-main.service
● postgresql@10-main.service - PostgreSQL Cluster 10-main
Loaded: loaded (/lib/systemd/system/postgresql@.service; enabled-runtime; vendor preset: enabled)
Active: active (running) since Wed 2023-04-05 14:54:35 CEST; 18h ago
Process: 1989496 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 10-main start (code=exited, status=0/SUCCESS)
Main PID: 1989515 (postgres)
Tasks: 67 (limit: 28734)
Memory: 1.3G
CGroup: /system.slice/system-postgresql.slice/postgresql@10-main.service
├─1989515 /usr/lib/postgresql/10/bin/postgres -D /var/lib/postgresql/10/main -c config_file=/etc/postgresql/10/main/postgresql.conf
├─1989526 postgres: 10/main: checkpointer process
├─1989527 postgres: 10/main: writer process
├─1989528 postgres: 10/main: wal writer process
├─1989529 postgres: 10/main: autovacuum launcher process
├─1989530 postgres: 10/main: stats collector process
├─1989531 postgres: 10/main: bgworker: logical replication laun
and version 12 is stopped,
# systemctl status postgresql@12-main.service
● postgresql@12-main.service - PostgreSQL Cluster 12-main
Loaded: loaded (/lib/systemd/system/postgresql@.service; enabled-runtime; vendor preset: enabled)
Active: failed (Result: protocol) since Wed 2023-04-05 14:54:27 CEST; 18h ago
Process: 1989497 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 12-main start (code=exited, status=1/FAILURE)
Apr 05 14:54:27 test-server postgresql@12-main[1989497]: 2023-04-05 14:54:27 CEST LOG: could not bind IPv4 address "127.0.0.1": Address already in use
Apr 05 14:54:27 test-server postgresql@12-main[1989497]: 2023-04-05 14:54:27 CEST HINT: Is another postmaster already running on port 5432? If not, wait a few >
Apr 05 14:54:27 test-server postgresql@12-main[1989497]: 2023-04-05 14:54:27 CEST WARNING: could not create listen socket for "localhost"
Apr 05 14:54:27 test-server postgresql@12-main[1989497]: 2023-04-05 14:54:27 CEST FATAL: could not create any TCP/IP sockets
Apr 05 14:54:27 test-server postgresql@12-main[1989497]: 2023-04-05 14:54:27 CEST LOG: database system is shut down
Apr 05 14:54:27 test-server postgresql@12-main[1989497]: pg_ctl: could not start server
Apr 05 14:54:27 test-server postgresql@12-main[1989497]: Examine the log output.
Apr 05 14:54:27 test-server systemd[1]: postgresql@12-main.service: Can't open PID file /run/postgresql/12-main.pid (yet?) after start: Operation not permitted
Apr 05 14:54:27 test-server systemd[1]: postgresql@12-main.service: Failed with result 'protocol'.
Apr 05 14:54:27 test-server systemd[1]: Failed to start PostgreSQL Cluster 12-main.
Is that the normal behavior of Foreman?
When I reboot the Server the version 12 is started and 10 is stopped is normal, but my whole data are in version 10, so I have then manually stop version 12 and start version 10.
Thats why Im very confused.
thank you all
Foreman and Proxy versions: foreman 3.6.1 , foreman-proxy 3.6.1
Distribution and version: Ubuntu 20.04.4 LTS