(define-module (deployment services databases)
  #:use-module (gnu services)
  #:use-module (gnu services databases)
  #:use-module (guix gexp)
  #:use-module ((gnu packages databases)
                #:prefix gnu:packages:databases:)
  #:export (matrix-postgresql-service))

(define postgres-hba
  (mixed-text-file "pg_hba.conf"
                   "host    synapse synapse_user 127.0.0.1/32 trust\n"
                   "host    synapse synapse_user ::1/128   trust\n"
                   "local   all     all                    peer\n"
                   "host    all     all     127.0.0.1/32   md5\n"
                   "host    all     all     ::1/128        md5\n"))

(define config-file
  (postgresql-config-file
   (log-destination  "syslog")
   (hba-file         postgres-hba)
   (ident-file       (@@ (gnu services databases)
                         %default-postgres-ident))
   (socket-directory "/var/run/postgresql")
   (extra-config     (list))))

(define matrix-postgresql-service-configuration
  (postgresql-configuration
   (postgresql         gnu:packages:databases:postgresql-17)
   (port               5432)
   (locale             "pl_PL.utf8")
   (config-file        config-file)
   (log-directory      "/var/log/postgresql")
   (data-directory     "/var/lib/postgresql/data")
   (extension-packages (list))
   (create-account?    #t)
   (home-directory     "/var/lib/postgresql")
   (allow-login?       #t)
   (uid                501)
   (gid                501)))

(define matrix-postgresql-service
  (service postgresql-service-type
           matrix-postgresql-service-configuration))