I upgraded my local Postgresql test server to PostgreSQL15 today morning. Opening pgAdmin gave me a warning that some of the features may not work correctly because I have a server with version 9 added to pgAdmin.
Steps done:
- Upgraded Postgresql v14 to v15.
- PgAdmin shows warnings and couldn't see the tables list.
- Uninstalled v15 and installed v14. Again the same issue.
- Uninstalled v14 and get v12 of Postgresql.
- Clean uninstall was done by removing the Postgresql folder from the "ProgamFiles" folder and "AppData/Roaming"
Current situation:
Still, pgAdmin is not showing the list of tables for the older server version (v9). I cannot upgrade this server, but have to use it in PgAdmin as before. But I can run the all queries without any problem.
When adding the V9 server, pgAdmin shows a warning like this
It is listing up all schemas, views, and sequences. But when clicking the Tables, it keeps loading and never gives the list of tables.
By the way, I am using Windows 10 64bit OS.
After five days, I degraded my Postgresql to V12 and now getting an error like this:
ERROR: column "wait_event_type" does not exist LINE 10: wait_event_type || ': ' || wait_event AS wait_event, ^
enter code here
Have anybody gone through such an issue? Need some help. Thanks in advance.