Keywords: PostgreSQL - Microsoft Azure - How to - Other
I am trying to restore my database from a VM to another VM on Azure.
The data needs to stay on the Azure Cloud, as the DB is too big to bring over to my local machine.
Using the backup tool from pgAdmin I can only select a local backup file.
When I run the command pg_dump -C -h localhost -U localuser db_name | psql remotehost -U remoteuser db_name using Putty, I keep getting the request for a password.
But I do not know for which pasword.
I login on the bitnami VM using putty.
I specify the command above updated with the server ip address, user and database name.
There is a prompt for a password. But for which password I do not know.
Should I use putty or should I use another tool?
Should I put both VMs in the same virtual network for this to work? I now used the external IP address
Or should I run a similar command in psql?
Thank you for your support.