Separate database server?
Hello.
Trying to get pleroma installed on a droplet at DigitalOcean. Ubuntu 18.04 (LTS). I'm also using a DigitalOcean Postgres cluster over a private network and I'm running into an issue:
This is the relevant entry in my prod.secret.exs
file:
config :pleroma, Pleroma.Repo,
adapter: Ecto.Adapters.Postgres,
username: "REDACTED",
password: "REDACTED",
database: "REDACTED", # MY DATABASE USER IS NOT 'postgres'!!!!
hostname: "private-db-postgresql-REDACTED-REDACTED-do-user-REDACTED-0.db.ondigitalocean.com:25060",
pool_size: 10
Note, I added the :25060
part to the hostname string. But when I run sudo -Hu postgres psql -f config/setup_db.psql
, this is what I see:
root@REDACTED:/opt/pleroma# sudo -Hu postgres psql -f config/setup_db.psql
psql:config/setup_db.psql:1: ERROR: role "REDACTED" already exists
psql:config/setup_db.psql:2: ERROR: database "REDACTED" already exists
You are now connected to database "REDACTED" as user "postgres". # THIS IS NOT MY DATABASE USER!!!!
psql:config/setup_db.psql:5: NOTICE: extension "citext" already exists, skipping
CREATE EXTENSION
psql:config/setup_db.psql:6: NOTICE: extension "pg_trgm" already exists, skipping
CREATE EXTENSION
psql:config/setup_db.psql:7: NOTICE: extension "uuid-ossp" already exists, skipping
CREATE EXTENSION
psql:config/setup_db.psql:8: ERROR: could not open extension control file "/usr/share/postgresql/10/extension/rum.control": No such file or directory
root@REDACTED:/opt/pleroma#
Suffice it to say because the config/setup_db.pl is trying to do something with postgres
I think this may be part of my problem. My database user is not postgres
and the database server isn't on localhost.
Any ideas?
Edited by Ghost User