I have a Postgres 11 server (Single server) that does not show up in portal, but is still billed

Question

I have a Postgres 11 server (Single server) that does not show up in portal, but is still billed

Geir Sagberg 0

I have a postgres server gaver11.postgres.database.azure.com that should probably have been migrated from Single to Flexible server earlier, but the web app still works and can connect to the server.

However, I can no longer see the server in the portal or via the CLI, so therefore I can no longer migrate it to a Flexible server.

I am still billed for it.

How can I migrate the server?

Geir Sagberg 0 Reputation points

2025-12-12T17:55:24.81+00:00

I am also still being billed for the server, but can find no way to access it
Pilladi Padma Sai Manisha 590 Reputation points Microsoft External Staff Moderator

2025-12-12T18:30:03.5433333+00:00
Hi Geir Sagberg,
Thankyou for Reaching Microsoft Q&A!
Azure retired PostgreSQL Single Server in March 2025. If the resource wasn’t migrated, it can become “orphaned” still running and billed but invisible in Portal/CLI due to tenant or RBAC changes.

What to do:

Find the resource:

In Portal: Switch Directory to the tenant linked to your billing profile.

CLI:

az account list --output table az account set --subscription <subscription-id>

Use Resource Graph:

az graph query -q "resources | where name contains 'gaver11'"

Restore access:

Add yourself back as Owner/Contributor at subscription level if RBAC was removed.

Migrate to Flexible Server:

-Create a new Flexible Server

az postgres flexible-server create --resource-group <rg> --name <flex-name> --location <region>

-Start migration

az postgres flexible-server migration create --resource-group <rg> --migration-name <id> --properties @migration.json

If migration isn’t possible:

-Dump data

pg_dump -h gaver11.postgres.database.azure.com -U <user> -d <db> -f db.dump pg_dumpall --roles-only > roles.sql

-Restore to Flexible Server

pg_restore -h <flex-name>.postgres.database.azure.com -U <user> -d <db> db.dump psql -h <flex-name>.postgres.database.azure.com -U <user> -f roles.sql

Stop billing:

Delete the old Single Server after migration or dispute charges via Cost Management.

Hope this helpful! if you have any further queries please let us know

2 answers

Your answer

Geir Sagberg 0 Reputation points

2025-12-12T17:55:24.81+00:00

I am also still being billed for the server, but can find no way to access it
Pilladi Padma Sai Manisha 590 Reputation points Microsoft External Staff Moderator

2025-12-12T18:30:03.5433333+00:00

Hi Geir Sagberg,
Thankyou for Reaching Microsoft Q&A!
Azure retired PostgreSQL Single Server in March 2025. If the resource wasn’t migrated, it can become “orphaned” still running and billed but invisible in Portal/CLI due to tenant or RBAC changes.

What to do:

Find the resource:

In Portal: Switch Directory to the tenant linked to your billing profile.

CLI:

az account list --output table az account set --subscription <subscription-id>

Use Resource Graph:

az graph query -q "resources | where name contains 'gaver11'"

Restore access:

Add yourself back as Owner/Contributor at subscription level if RBAC was removed.

Migrate to Flexible Server:

-Create a new Flexible Server

az postgres flexible-server create --resource-group <rg> --name <flex-name> --location <region>

-Start migration

az postgres flexible-server migration create --resource-group <rg> --migration-name <id> --properties @migration.json

If migration isn’t possible:

-Dump data

pg_dump -h gaver11.postgres.database.azure.com -U <user> -d <db> -f db.dump pg_dumpall --roles-only > roles.sql

-Restore to Flexible Server

pg_restore -h <flex-name>.postgres.database.azure.com -U <user> -d <db> db.dump psql -h <flex-name>.postgres.database.azure.com -U <user> -f roles.sql

Stop billing:

Delete the old Single Server after migration or dispute charges via Cost Management.

Hope this helpful! if you have any further queries please let us know

Answer 1

Geir Sagberg 0

I set the subscription, but could not find any resources:

geir@Azure:~$ az graph query -q "resources | where name contains 'gaver11'"

{

"count": 0,

"data": [],

"skip_token": null,

"total_records": 0

}

However, the pg_dump worked and I was able to restore to a new flexible database.

I still am not able to delete the old database, however. I will try to create a support ticket to have it deleted.

Geir Sagberg 0 Reputation points

2025-12-12T23:47:43.31+00:00

I am still Owner of the subscription. ChatGPT suggests:
Why CLI and Portal don’t show it

All of these rely on the Azure Resource Manager (ARM) + resource provider:

Portal UI

az postgres server list

az graph query

If the RP is retired or the resource is in a deprecated state, ARM simply does not enumerate it anymore.

Is there anything you can do on the backend to delete the old database gaver11?

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

I have a Postgres 11 server (Single server) that does not show up in portal, but is still billed

2 answers

Your answer