Postgreslq service active but stopped

 

Postgreslq service active but stopped


Use sudo systemctl status 'postgresql*' to see the status of all PostgreSQL services.



root@server:~# sudo systemctl status 'postgresql*'
● postgresql@15-main.service - PostgreSQL Cluster 15-main
     Loaded: loaded (/lib/systemd/system/postgresql@.service; enabled-runtime; vendor preset: enabled)
     Active: failed (Result: exit-code) since Sat 2022-12-03 09:05:57 CET; 1h 32min ago
    Process: 564654 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 15-main start (code=exited, status=0/SUC>    Process: 574148 ExecStop=/usr/bin/pg_ctlcluster --skip-systemctl-redirect -m fast 15-main stop (code=exited, status>   Main PID: 564678 (code=exited, status=0/SUCCESS)

Dec 03 09:05:57 server.cloudhostingus.com crontab[574088]: (postgres) LIST (postgres)
Dec 03 09:05:57 server.cloudhostingus.com crontab[574091]: (postgres) LIST (postgres)
Dec 03 09:05:57 server.cloudhostingus.com crontab[574094]: (postgres) LIST (postgres)
Dec 03 09:05:57 server.cloudhostingus.com crontab[574097]: (postgres) LIST (postgres)
Dec 03 09:05:57 server.cloudhostingus.com crontab[574100]: (postgres) LIST (postgres)
Dec 03 09:05:57 server.cloudhostingus.com crontab[574129]: (postgres) REPLACE (postgres)
Dec 03 09:05:57 server.cloudhostingus.com crontab[574135]: (postgres) REPLACE (postgres)
Dec 03 09:05:57 server.cloudhostingus.com postgresql@15-main[574148]: Cluster is not running.
Dec 03 09:05:57 server.cloudhostingus.com systemd[1]: postgresql@15-main.service: Control process exited, code=exited, >Dec 03 09:05:57 server.cloudhostingus.com systemd[1]: postgresql@15-main.service: Failed with result 'exit-code'.

● 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 Sat 2022-12-03 08:16:56 CET; 2h 21min ago
    Process: 564653 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 12-main start (code=exited, status=1/FAI>
Dec 03 08:16:56 server.cloudhostingus.com postgresql@12-main[564653]: 2022-12-03 08:16:56.325 CET [564677] LOG:  could >Dec 03 08:16:56 server.cloudhostingus.com postgresql@12-main[564653]: 2022-12-03 08:16:56.325 CET [564677] HINT:  Is an>Dec 03 08:16:56 server.cloudhostingus.com postgresql@12-main[564653]: 2022-12-03 08:16:56.325 CET [564677] WARNING:  co>Dec 03 08:16:56 server.cloudhostingus.com postgresql@12-main[564653]: 2022-12-03 08:16:56.325 CET [564677] FATAL:  coul>Dec 03 08:16:56 server.cloudhostingus.com postgresql@12-main[564653]: 2022-12-03 08:16:56.325 CET [564677] LOG:  databa>Dec 03 08:16:56 server.cloudhostingus.com postgresql@12-main[564653]: pg_ctl: could not start server
lines 1-29...skipping...
● postgresql@15-main.service - PostgreSQL Cluster 15-main
     Loaded: loaded (/lib/systemd/system/postgresql@.service; enabled-runtime; vendor preset: enabled)
     Active: failed (Result: exit-code) since Sat 2022-12-03 09:05:57 CET; 1h 32min ago
    Process: 564654 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 15-main start (code=exited, status=0/SUCCESS)
    Process: 574148 ExecStop=/usr/bin/pg_ctlcluster --skip-systemctl-redirect -m fast 15-main stop (code=exited, status=2)
   Main PID: 564678 (code=exited, status=0/SUCCESS)





root@server:~# systemctl stop postgresql@12-main.service


root@server:~# systemctl status postgresql@15-main.service



root@server:~# systemctl status postgresql@15-main.service


● postgresql@15-main.service - PostgreSQL Cluster 15-main



     Loaded: loaded (/lib/systemd/system/postgresql@.service; enabled-runtime; vendor preset: enabled)
     Active: active (running) since Sat 2022-12-03 10:45:07 CET; 1s ago
    Process: 591031 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 15-main start (code=exited, status=0/SUCCESS)
   Main PID: 591045 (postgres)
      Tasks: 6 (limit: 9479)
     Memory: 34.0M
     CGroup: /system.slice/system-postgresql.slice/postgresql@15-main.service
             ├─591045 /usr/lib/postgresql/15/bin/postgres -D /var/lib/postgresql/15/main -c config_file=/etc/postgresql/15/main/postgresql.conf
             ├─591046 postgres: 15/main: checkpointer
             ├─591047 postgres: 15/main: background writer
             ├─591049 postgres: 15/main: walwriter
             ├─591050 postgres: 15/main: autovacuum launcher
             └─591051 postgres: 15/main: logical replication launcher

Dec 03 10:45:05 server.cloudhostingus.com systemd[1]: Starting PostgreSQL Cluster 15-main...
Dec 03 10:45:07 server.cloudhostingus.com systemd[1]: Started PostgreSQL Cluster 15-main.



I was having both 12 and 15 so i stoped 12 and enabled 15 only

root@server:~# systemctl disable postgresql@12-main.service


root@server:~# systemctl enable postgresql@15-main.service


Created symlink /etc/systemd/system/multi-user.target.wants/postgresql@15-main.service → /lib/systemd/system/postgresql@.service.

Comments

Post a Comment

Popular posts from this blog

cpanel exam CPSP Answers

 Which of the following options best describes the role of Shared Hosting on a web server? Providing hosting for a single website owned by different people on multiple servers. Providing hosting for a single website owned by one person on one server. Providing hosting for multiple websites owned by different people on one server. Providing hosting for multiple websites owned by one person on one server. 3 Which of the following capabilities can a cPanel account user perform easily from within the cPanel account interface without the aid of a system administrator? File and configuration management. Relocating the physical server. Upgrading server hardware and equipment. Installing new database software. 1 File and configuration management. Which of the following options best describes a core benefit to using cPanel & WHM, as a web hosting provider operating on a cPanel & WHM environment? cPanel users are able to create new virtualization resources to help host their web appl...
Read more

How to install zimbra collaboration suite 8.8.11 on CentOS 7

Check system requirements  https://wiki.zimbra.com/wiki/Zimbra_Releases/8.7.0/Single_Server_Installation#System_Requirements prerequisites Before we get started, here are a few things that are required before we proceed with the installation. A clean installation of Centos 7 A Fully Qualified Domain (FQDN) for your server(Example mail.geekybum.com) An external DNS server with both A and MX records for your server to point to your Zimbra mail server IP Address A static IP Address assigned to network interface. Step 1: Root login to server through SSH Step 2: Install required packages for zimbra coloboration suite installation yum -y install unzip net-tools sysstat openssh-clients perl-core libaio nmap-ncat libstdc++.so Initial server setup To get started we need to configure a hostname for our server and a static IP address. vi /etc/hosts 135.125.30.56 mail.geekybum.com mail Replace the system hostname and FQDN values accordingly in order to match your ow...
Read more

awstats installation

Set Up AWStats for Nginx on Ubuntu sudo apt-get install awstats add access log file to generate stats using this server { # ... all your other config ... access_log /var/log/nginx/yourdomain.com.access.log ; # ... all your other config ... } /etc/nginx/sites-available vi awstats.parleproducts.com.conf cd /etc/awstats/ vi awstats.parleproducts.com.conf #path to your nginx log file LogFile="/var/log/nginx/parleproducts.com.access.log" # Domain of your vhost SiteDomain="parleproducts.com" # Directory where to store the awstats data DirData="/var/lib/awstats/" # Other domains/subdomain you want included from your logs, for example the www subdomain HostAliases="www.parleproducts.com" # If you customized your log format above add this line: LogFormat = ""%host %other %logname %time1 %methodurl %code %bytesd %refererquot %uaquot"" # If you did not, uncomment and use this line: #...
Read more