1) The connection string format:
2) Why when I changed the connection string Web App service backup is using the previous connection string:
3) In the connection string, the database name is sensitive case:
4) I have found that when the version of Azure Database for PostgreSQL is 11, you are going to have the following error message: "PostgreSQL backup exited with code 1 for db:postgres. Exception:pg_dump: aborting because of server version mismatch."
My suggestion in this type of situation is to use the inbuilt backup service that Azure Database for PostgreSQL because besides that is compatible with all versions, is performing transactional backups every 5-10 minutes and it is possible to restore a instance at any point in time within the retention period.
Enjoy!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.