I have a question of how we can restore a local database backup in Azure PostgreSQL server?
Asked
Active
Viewed 250 times
1 Answers
1
Make sure you can access your database from the computer you are restoring the DB dump
pg_restore --dbname=postgresql://user:password@host:port/database_name ./path/to/your/dump.tar.gz
tom10271
- 4,222
- 5
- 33
- 62
-
Can't we use direct restore by accessing the Azure postgres Sql server from pgAdmin ? – Gudwlk Aug 09 '22 at 06:49
-
You can give it a try. I have not used pgAdmin before. – tom10271 Aug 09 '22 at 06:54