PostgreSQL troubleshooting

The following commands may be helpful in troubleshooting issues with PostgreSQL:

• Get the PostgreSQL service status:

  sudo systemctl status postgresql-15.service

• Stop the PostgreSQL service:

  sudo systemctl stop postgresql-15.service

• Start the PostgreSQL service

  sudo systemctl start postgresql-15.service

• Get the PgBouncer service status:

  sudo systemctl status pgbouncer.service

• Stop the PgBouncer service:

  sudo systemctl stop pgbouncer.service

• Start the PgBouncer service:

  sudo systemctl start pgbouncer.service

Important! Always start or restart the PostgreSQL service before starting or restarting the PgBouncer service.