Hi,
I would like to use postgres as the backend database for gitea, but I can’t seem to find a place to add the options for postgres, what should I do ?
db url tested elsewhere that worked:
DATABASE_URL=postgres://username:password@server-address/gitea?sslmode=require&options=project%3Dproject_name
Like the project_name above what should I do to get gitea to use this options to connect to postgres?
You want to use the individual configuration settings (see Config Cheat Sheet), your connection URI roughly translates to:
[database]
DB_TYPE=postgres
HOST=server-address
NAME=gitea
USER=username
PASSWD=password
SSL_MODE=require
I am not familiar with Postgres, so not sure what the options=project%3Dproject_name does. If it is necessary for a connection to complete, I think you will need to file an enhancement issue on GitHub to add support for the options parameter.