I am following the docs for restoring a postgres database from a backup here.
I have tried running the specified command from a psql window in pgadmin as well as using the restore option through the pgadmin UI. Neither option is working currently.
When I use the command from a psql window I receive no output but I am unable to query the database as I would expect afterwards. When I attempt to “restore” through the pgadmin UI, using the unzipped sql.gz file I downloaded from the render recovery page, I get an error saying pg_restore: error: input file appears to be a text format dump. Please use psql.
Do you have the correct Access Control settings for the database that you’re trying to load data into? Could you try allowing access form 0.0.0.0/0 temporarily to see if that helps.
It might help if you could show the full command (just obfuscate the password) you’re using and the resulting output when you follow the instructions from our docs.
Feel free to open a support ticket from the dashboard if you’d be more comfortable sharing that information there as opposed to a public forum.