Azure – Postgres – Restore to Azure Postgres Flexible Server

Have not tested this extensively but I have managed to take a pg_dump file from a version 16 Postgres Local Server and restore it to a Postgres version 16.3 Flexible Server on the Azure platform. I have also briefly tested taking a dump file from azure.

Requirements

  • The computer from which you will restore the database has been IP white listed.
  • Check that you have a higher version of restore than the version of Azure Postgres Database / Overview see version no.
  • Remember to create the database into which you will be placing the dump file
  • host will be endpoint and will be something like myserver.postgres.database.azure.com
  • username will be admin login defined at creation (probably not postgres)
  • Port default is usually 5432
  • These details can be found by going to Settings / Connect –

    • /

    Interestingly the connect screen contains a code generator similar to the one that I created that will assist users in creating their pg_dump and pg_restor commands.