Can't create tables in PostgreSQL.

[mxwmnn]

Describe the issue

ERROR: permission denied for schema public
LINE 1: CREATE TABLE "test" ( 21:53:17 [SQL-Kommando]
[CREATE TABLE] "test" (
);

I can't create any table in the database homeassistant with adminer
If i wan't to do it in the terminal i get:

postgres@postgresql:~$ psql -U admin 
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  Peer authentication failed for user "admin"

I tried any GRANTS on SCHEMAS. If i create a new schema i can create tables... But i have permissions when i look with \dn+ or \l+.
Maybe i mention, that i did the exact same steps from the github installation guide

[mxwmnn]

This part seem's to cause this problem. From your script. My lxc container has the ip 10.0.0.103. and adminer is accessible through an nginx proxy manager on the internet. NPM is on 10.0.0.100. The weird thing is, i cant connect with root or postgres user with the command psql -U admin to the database. Everything seems broken here.

cat <<EOF >/etc/postgresql/15/main/pg_hba.conf
# PostgreSQL Client Authentication Configuration File
local   all             postgres                                peer
# TYPE  DATABASE        USER            ADDRESS                 METHOD
# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            scram-sha-256
host    all             all             0.0.0.0/24              md5
# IPv6 local connections:
host    all             all             ::1/128                 scram-sha-256
host    all             all             0.0.0.0/0               md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256
EOF

[mxwmnn]

Fixed it with creating a new schema. Don't know why and don't care anymore