Aissam EN-NAHEL aissam-en

The benchmark :

$ time psql -h localhost -U laravel_user -d test_db -c "select 1;"
Password for user laravel_user:
 ?column?
----------
        1
(1 row)

real 0m0.962s

1. Install Python 3.10 using Deadsnakes PPA

Ubuntu 24.04 comes with a newer Python version. But Rasa 3.6 only works with Python 3.8 to 3.10 Rasa Docs.

So we’ll install Python 3.10 from a trusted source called Deadsnakes :

# Update the system
sudo apt update && sudo apt upgrade -y

# Install software that allows adding repositories

install postgreSQL

sudo apt install postgresql

set password :

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

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

	-- 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 (