Thread: Servers tab keeps on loading on Mac

Servers tab keeps on loading on Mac

From
Rajiv Prathapan
Date:
Hi,

I tried installing postgreSQL version 15.2 from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

And When I start my pgadmin4 , the servers list on the left pane keeps on loading.
I have tried uninstalling and reinstalling but the issue remains the same. I have attached the screenshot for your reference.

Please let me know how to resolve this.

Hoping to hear from you soon

Best,
Rajiv.
Attachment

Re: Servers tab keeps on loading on Mac

From
Akshay Joshi
Date:
Hi Rajiv

Which version of pgAdmin 4 is installed? Can you please provide the logs pgAdmin4->Runtime->View log.

On Thu, Feb 16, 2023 at 5:43 PM Rajiv Prathapan <prathaprajiv@gmail.com> wrote:
Hi,

I tried installing postgreSQL version 15.2 from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

And When I start my pgadmin4 , the servers list on the left pane keeps on loading.
I have tried uninstalling and reinstalling but the issue remains the same. I have attached the screenshot for your reference.

Please let me know how to resolve this.

Hoping to hear from you soon

Best,
Rajiv.

Re: Servers tab keeps on loading on Mac

From
Rajiv Prathapan
Date:
Hi Akshay,

pgAdmin 4 version is 6.19, attaching a screenshot for your reference.
Also Attaching the logs from PgAdmin 4.

Regards,
Rajiv Prathapan.


On Sat, Feb 18, 2023 at 4:21 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi Rajiv

Which version of pgAdmin 4 is installed? Can you please provide the logs pgAdmin4->Runtime->View log.

On Thu, Feb 16, 2023 at 5:43 PM Rajiv Prathapan <prathaprajiv@gmail.com> wrote:
Hi,

I tried installing postgreSQL version 15.2 from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

And When I start my pgadmin4 , the servers list on the left pane keeps on loading.
I have tried uninstalling and reinstalling but the issue remains the same. I have attached the screenshot for your reference.

Please let me know how to resolve this.

Hoping to hear from you soon

Best,
Rajiv.
Attachment

Re: Servers tab keeps on loading on Mac

From
Akshay Joshi
Date:
Hi Rajiv

It appears that you have installed v6.20 as well. In version 6.20, the "pgadmin4.db" file has a new structure for the server and sharedserver tables. I have analyzed the log and it throws an error "sqlite3.OperationalError: no such column: server.hostaddr" which is expected if you installed the v6.20 and then run v6.19 again.

See https://www.pgadmin.org/news/ for the release announcement

On Sat, Feb 18, 2023 at 7:08 PM Rajiv Prathapan <prathaprajiv@gmail.com> wrote:
Hi Akshay,

pgAdmin 4 version is 6.19, attaching a screenshot for your reference.
Also Attaching the logs from PgAdmin 4.

Regards,
Rajiv Prathapan.


On Sat, Feb 18, 2023 at 4:21 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi Rajiv

Which version of pgAdmin 4 is installed? Can you please provide the logs pgAdmin4->Runtime->View log.

On Thu, Feb 16, 2023 at 5:43 PM Rajiv Prathapan <prathaprajiv@gmail.com> wrote:
Hi,

I tried installing postgreSQL version 15.2 from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

And When I start my pgadmin4 , the servers list on the left pane keeps on loading.
I have tried uninstalling and reinstalling but the issue remains the same. I have attached the screenshot for your reference.

Please let me know how to resolve this.

Hoping to hear from you soon

Best,
Rajiv.

Re: Servers tab keeps on loading on Mac

From
Rajiv Prathapan
Date:
Thank you so much Akshay.

Uninstalling v6.19 and installing v6.20 resolved the issue. I am able to see the servers tab now.

Thank you again,
Regards,
Rajiv Prathapan.


On Mon, Feb 20, 2023 at 11:16 AM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi Rajiv

It appears that you have installed v6.20 as well. In version 6.20, the "pgadmin4.db" file has a new structure for the server and sharedserver tables. I have analyzed the log and it throws an error "sqlite3.OperationalError: no such column: server.hostaddr" which is expected if you installed the v6.20 and then run v6.19 again.

See https://www.pgadmin.org/news/ for the release announcement

On Sat, Feb 18, 2023 at 7:08 PM Rajiv Prathapan <prathaprajiv@gmail.com> wrote:
Hi Akshay,

pgAdmin 4 version is 6.19, attaching a screenshot for your reference.
Also Attaching the logs from PgAdmin 4.

Regards,
Rajiv Prathapan.


On Sat, Feb 18, 2023 at 4:21 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi Rajiv

Which version of pgAdmin 4 is installed? Can you please provide the logs pgAdmin4->Runtime->View log.

On Thu, Feb 16, 2023 at 5:43 PM Rajiv Prathapan <prathaprajiv@gmail.com> wrote:
Hi,

I tried installing postgreSQL version 15.2 from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

And When I start my pgadmin4 , the servers list on the left pane keeps on loading.
I have tried uninstalling and reinstalling but the issue remains the same. I have attached the screenshot for your reference.

Please let me know how to resolve this.

Hoping to hear from you soon

Best,
Rajiv.