now i get this error when i attempt to access it. anyone know how to set it back?
404: FetchError: request to http://lemmy:8536/api/v3/site
and the command docker compose -p lemmy-easy-deploy logs -f
yeilds a bunch of nonsense but this line stood out…
Error: LemmyError { message: Some("Cannot have both private instance and federation enabled."), inner: Cannot have both private instance and federation enabled., context: "SpanTrace" }
To connect to your database:
psql -h localhost -U PG_USER
Replace PG_USER with the username in your docker-compose file (under the entry for postgresql). It’ll ask you for a password which will be right next to your pg user in docker compose or lemmy.hjson
If you get an error about psql not being a valid command then you probably need to install the postgresql client tools. Depending on OS that varies, usually
sudo apt install postgresql
orsudo dnf install postgresql
will do it.If you get an error about being unable to connect, you also will need to expose access to your database from docker. For that modify your docker compose file, look for something like “externalproxy” in the network section to know the name of the network you need to add to the postgresql container. You’ll see an example of it under nginx container. Put a copy of that in the postgresql docker section. You’ll also need to add port mapping 5432:5432 to PG container - again see other container entries in there for an example of the port declaration looks like. After that do
docker compose up -d
to reload it and you should be able to connect with psql.Once you get in with psql, enter that query and hit enter. It should output
UPDATE 1
if it worked and then you can do \q to exit.