aissam-en

-- SQL query to list all PostgreSQL sequences, their current last_value, and whether they are behind the maximum id in their corresponding tables.
-- Useful for debugging duplicate key errors caused by manual inserts or broken auto-increment.

SELECT
    n.nspname AS schema,
    c.relname AS sequence_name,
    t.relname AS table_name,
    a.attname AS column_name,
    s.last_value,
    (SELECT MAX(x) FROM (

aissam-en

• install postgreSQL

sudo apt install postgresql

• set password :

     sudo -u postgres psql template1
     ALTER USER postgres with encrypted password 'my_passwordy';
     \q

aissam-en

Create service file :

sudo nano /etc/systemd/system/my_app.service

The content of my_app.service file:

[Unit]
Description=Springboot app for BLABLA (test-env)
After=syslog.target network.target