How to check database status?

To check the status of a PostgreSQL database, you can use the following methods:

Using psql Command:
You can connect to the database and run the following command:
```
SELECT pg_isready();
```
This will return the connection status.
Using System Service Command:
If you're on a Linux system, you can check the status of the PostgreSQL service with:
```
sudo systemctl status postgresql
```
This will show whether the PostgreSQL service is active (running) or inactive (stopped).
Using pg_isready Command:
You can use the pg_isready command directly in the terminal to check if the server is accepting connections:
```
pg_isready
```
This will return a message indicating whether the server is ready to accept connections.
Check Database Connections:
You can also check active connections to the database by running:
```
SELECT * FROM pg_stat_activity;
```
This will show you the current connections and their statuses.

Choose the method that best fits your needs! If you have any further questions, let me know!