So I created a dump file and running this command in regular Window CMD pg_restore --dbname=EXTERNAL-CONNECTION-STRING --clean --create --no-acl --no-owner -U user -h localhost -p 5432 -d C:\path\to\demo.dump and the db on Render still does not have any of the table in the dump file. Is this something on my end or Render’s end?
Hey,
Are you able to connect to your Render-hosted database to verify if there is any data in it? Also, are you seeing any error messages?
Jérémy.
Render Support, UTC+3
Yeah I can connect to it and when i run a simple “SELECT * from table” it says that the relation does not exist. and I am not seeing any error message.
Hey,
You can contact us through the ‘Contact Support’ form on the dashboard for a more private investigation, but I don’t see how our managed PostgreSQL instance could interfere with the pg_restore process if you’re not encountering any errors. We’ll likely need to look into the .dump file.
Jérémy.
Render Support, UTC+3
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.