Dump and Restore: data missing with errors

[PMarco03]

Hello everyone.
I'm developing an webapp and i need to daily backup my DB.
In order to do that, i'm using a raspberry that everydays runs this script:

DB_HOST="aws-0-eu-central-1.pooler.supabase.com"
DB_PORT="6543"
DB_USER="postgres.XXXXXX"
DB_PASSWORD="XXXXXXX"
export PGPASSWORD=$DB_PASSWORD

DATE=$(date +"%Y-%m-%d")
mkdir -p /mnt/hdd/dumps/uncashed/$DATE
OUTPUT_FILE_DATA="/mnt/hdd/dumps/uncashed/$DATE/data"
OUTPUT_FILE_SCHEMA="/mnt/hdd/dumps/uncashed/$DATE/schema"

pg_dump -h $DB_HOST -U $DB_USER -d postgres -p $DB_PORT --schema-only -Fp --no-owner > $OUTPUT_FILE_SCHEMA.sql
pg_dump -h $DB_HOST -U $DB_USER -d postgres -p $DB_PORT --data-only -Fp --no-owner > $OUTPUT_FILE_DATA.sql

unset PGPASSWORD

The main problem is that when i try to restore from files, i get errors on primary keys. The schema gets restored without any problems. but data is missing.

I need to restore everything in the db: table, funcions, accounts, settins ecc.
I tried different scripts found on github, tack overflow, chat GPT, Copilot but i couldn't find any of them working.

At the moment i have a project for production and a project for testing and i can't transfer data from one to another.
Could anyone help me in this?
Thanks