- 23 Jan, 2025
- 0 Comments
- 1 Min Read
Managing PostgreSQL 15 Services
Start and Stop PostgreSQL
is a powerful and flexible database management system widely used for various applications. Properly managing its services ensures smooth database operations. This guide explains how to start, stop, and configure PostgreSQL services effectively.
Using pg_ctl
PostgreSQL services can be managed using pg_ctl or systemctl commands. Follow the instructions below to perform these operations:
- Start PostgreSQL:
pg_ctl -D /home/postgres/data start
- Stop PostgreSQL:
pg_ctl -D /home/postgres/data stop
Using systemctl (if PostgreSQL is configured as a service)
- Start PostgreSQL:
sudo systemctl start postgresql-15
- Stop PostgreSQL:
sudo systemctl stop postgresql-15 sudo systemctl start postgresql-15
Verify PostgreSQL Status
It’s essential to verify the status of the PostgreSQL service after starting or stopping it. Use the following commands:
- Using pg_ctl:
pg_ctl -D /home/postgres/data status - Using systemctl:
sudo systemctl status postgresql-15
Auto-Start Configuration
Configuring PostgreSQL to start automatically on system boot ensures high availability. Here’s how to manage auto-start settings:
- Check Auto-Start Status
sudo systemctl is-enabled postgresql-15
- Enable Auto-Start
sudo systemctl enable postgresql-15 - Disable Auto-Start
sudo systemctl disable postgresql-15
Conclusion
Managing PostgreSQL 15 is simple when using these basic commands. You can control the start and stop of the service, check its status, and configure auto-start settings based on your needs.