yunntan
HOBBYOP
a year ago
I have been following the tutorial to have my database backed-up; and now I would like to restore an old back up: https://blog.railway.app/p/automated-postgresql-backups#restoring-data-from-the-backup
Although I keep getting the error FATAL: database "r ailway" does not exist.
I dropped the db, re-created a new one with createdb -h roundhouse.proxy.rlwy.net -p 48895 -U railway -W railway all good and if trying to createdb again it says it already exist. Although for some reason pg_restore keeps telling me it does not exist…
I am not super knowledgeable with PostGres, any help would be much appreciated.