ImmichI
Immich8mo ago
86 replies
raldone01

1.133.0 SQL `PostgresError: syntax error at or near "."` Database name is not escaped properly

2025-05-22 12:43:15.074 CEST [1] LOG:  starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-05-22 12:43:15.074 CEST [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-05-22 12:43:15.074 CEST [1] LOG:  listening on IPv6 address "::", port 5432
2025-05-22 12:43:15.082 CEST [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-05-22 12:43:15.098 CEST [29] LOG:  database system was shut down at 2025-05-22 12:30:32 CEST
[2025-05-22T10:43:15Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/801329".
[2025-05-22T10:43:15Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/953291".
[2025-05-22T10:43:15Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/801329/segments/84076b9f-16f3-4367-a4c8-9b8bce008069".
2025-05-22 12:43:15.113 CEST [1] LOG:  database system is ready to accept connections
[2025-05-22T10:43:15Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/953291/segments/14b0f86d-9e6d-4ae1-a519-9695c8c381fb".
2025-05-22 12:43:43.054 CEST [67] FATAL:  role "root" does not exist
2025-05-22 12:43:43.160 CEST [69] FATAL:  role "root" does not exist
2025-05-22 12:44:13.284 CEST [78] FATAL:  role "root" does not exist
2025-05-22 12:44:13.341 CEST [80] FATAL:  role "root" does not exist
2025-05-22 12:44:43.461 CEST [90] FATAL:  role "root" does not exist
2025-05-22 12:44:43.509 CEST [92] FATAL:  role "root" does not exist
2025-05-22 12:45:13.631 CEST [101] FATAL:  role "root" does not exist
2025-05-22 12:45:13.681 CEST [103] FATAL:  role "root" does not exist
2025-05-22 12:45:43.809 CEST [113] FATAL:  role "root" does not exist
2025-05-22 12:45:43.857 CEST [115] FATAL:  role "root" does not exist
2025-05-22 12:46:13.992 CEST [124] FATAL:  role "root" does not exist
2025-05-22 12:46:14.045 CEST [126] FATAL:  role "root" does not exist
2025-05-22 12:46:44.189 CEST [136] FATAL:  role "root" does not exist
2025-05-22 12:46:44.238 CEST [138] FATAL:  role "root" does not exist
2025-05-22 12:47:14.364 CEST [147] FATAL:  role "root" does not exist
2025-05-22 12:47:14.413 CEST [149] FATAL:  role "root" does not exist
2025-05-22 12:47:44.537 CEST [159] FATAL:  role "root" does not exist
2025-05-22 12:47:44.588 CEST [161] FATAL:  role "root" does not exist


How can I create the role in sql?
Was this page helpful?