How can I solve 'ServerManager' object has no attribute 'user_info' error in postgresql pqAdmin

Question

I'm trying to create a server for an existing database using postgresql but i'm getting this error 'ServerManager' object has no attribute 'user_info' can someone please assist me to overcome this error. Thanks in advance

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community, Oct 07 '21 at 09:17
I updated PG Admin to v6.16 and it worked for me. https://www.postgresql.org/ftp/pgadmin/pgadmin4/v6.16/macos/ — aaronmbmorse, Nov 19 '22 at 20:13

score 34 · Answer 1 · answered Oct 27 '22 at 15:41

34

I was getting the same error. Just use pgadmin4 version 6.15 or newer. It solved my problem.

answered Oct 27 '22 at 15:41

Alparslan Karagüney

341
3
4

pgadmin4 version 6.11 worked for me – Michal Diviš Apr 26 '23 at 06:41
Remove and install new version fixed my issue. – yas Jul 17 '23 at 11:23
7.5 works for me! – Capella Aug 23 '23 at 19:13

score 19 · Answer 2 · answered Oct 26 '22 at 18:41

19

I was getting this error because in Postgres version 15 and letter column "datlastsysoid" from the table "pg_database" has been removed. You can visit this link

So in this case you can use Postgres version 14 or earlier versions.

answered Oct 26 '22 at 18:41

Barun Bhattacharjee

242
3
9

27

For Postgres 15 you have to use pgadmin4 version 6.15 or newer. – Nils Oct 27 '22 at 11:00
@Nils this is the right answer – cubesnyc Mar 29 '23 at 15:18

score 7 · Accepted Answer · answered Jul 12 '22 at 14:45

7

I had the same error while connecting to an old instance of PostgreSQL from pgAdmin-4. Remember that

pgAdmin III may not function as expected. Supported server versions (of pgAdmin III) are 8.4 to 9.4.

so pgAdmin-4 range starts from PostgreSQL 9.5

answered Jul 12 '22 at 14:45

alboforlizo

170
1
6

Downgraded to pgAdmin lll, then I managed to access the old database Thank you. – Allie Moosa Nov 01 '22 at 09:33

score 1 · Answer 4 · answered Oct 27 '22 at 21:16

1

I've used just an older pg db version, and it worked!

answered Oct 27 '22 at 21:16

Jakov Gl.

361
3
11

You are saying thanks for existing answers but do not contribute anything new, right? In that case please delete this post and use your voting privilege to express your gratitude. Otherwise please [edit] to make your new insight more obvious please. – Yunnosch Nov 20 '22 at 08:07

score 0 · Answer 5 · answered May 27 '22 at 05:58

0

When I got this error it seemed to be because I had installed pgAdmin (a newer version) separately from the full PostgreSQL install which included pgAdmin. I uninstalled the separate installation of pgAdmin this error went away.

answered May 27 '22 at 05:58

R. J.

437
5
15

score 0 · Answer 6 · answered Jul 20 '23 at 10:29

In my own case, I had postgreSQL 14 and 15 installed. I removed the newer version I installed separately from the full PostgreSQL install which included pgAdmin, uninstalled postgreSQL 14 and removed the file (c:\Program Files\PostgreSQL\14\data) and it worked.

score -4 · Answer 7 · edited Mar 21 '22 at 09:18

-4

Just try to remove the pgAdmin folder from the C:\Users\myusername\AppData\Roaming\pgAdmin and restarted the pgAdmin and it should work.

edited Mar 21 '22 at 09:18

Dharman

30,962
25
85
135

answered Mar 21 '22 at 09:12

Mayur

4,345
3
26
40

How can I solve 'ServerManager' object has no attribute 'user_info' error in postgresql pqAdmin

7 Answers7