PgAdmin4 failed to retrieve data from the server

Hi,

I hope some PostgreSQL guru can help me with this: I use PgAdmin Desktop under Windows to administer PostgreSQL Databases.

Last weed I first received an error trying to connecto to a remote Linux server with a problem on the port and since that moment I can not connect to that Server. It says: Failed to retrieve data from the server, string indices must be integers.
It works fine with localhost.

Any idea?

Regards,

Hi, it looks like there is some issue specific to your browser and PGAdmin4. PgAdmin Desktop may be some kind of Electron-based app. Try changing browser or use another database tool.
Have looked at this?

https://dba.stackexchange.com/questions … e-integers

Hi Christian,

Yes, I saw that, but as I mentioned I use PgAdmin4 Desktop on Windows, I do not use the web interfase.

I tried upgrading from v9.2.24 to v13 but I had problems so I stay with v9.

Regards,

I am now using HeidiSQL to access but I prefer to use PgAdmin

I’m a DataGrip user…

Hi Juan,

i´ve experienced the same problem with the newest versions of pgAdmin.
My database is hosted on a server. Sometimes when i run a query or just browse data, i get the “string must be XX” error and no data is shown.
(Same db on localhost i never get these kind of errors.)

But in my case its not persistens, i just run the query again or refresh the browse and after a few tries it works again.

Greetings
Vik

Hi Vik,

Do you use the web based PgAdmin? I use the desktop version on Windows. What do you need to install to run the web based PgAdmin?

Regards,

Hi Juan,

currently we use the electron (we think its electron or some kind of) client of pgAdmin, so its the desktop version.
The version we use is: 7.8.

I had some more connection errors to my server yesterday, but just like every time. I just refresh/F5 and after a few tries it works again.

Greetings,
Vik