PgAdmin4 failed to retrieve data from the server

[ProRM]

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,

[swingman]

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

[ProRM]

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,

[ProRM]

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

[swingman]

I'm a DataGrip user...

[vik.lamp.vl]

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

[ProRM]

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,

[vik.lamp.vl]

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