How to check database status?

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

1. Using psql Command: You can connect to the database and run the following command:

   SELECT pg_isready();
   

   This will return the connection status.

2. 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).

3. 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.

4. 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!