Thread: Servers tab keeps on loading on Mac
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.
Rajiv.
Attachment
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-downloadsAnd 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 soonBest,
Rajiv.
Hi Akshay,
pgAdmin 4 version is 6.19, attaching a screenshot for your reference.
Also Attaching the logs from PgAdmin 4.
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 RajivWhich 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-downloadsAnd 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 soonBest,
Rajiv.
Attachment
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 RajivWhich 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-downloadsAnd 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 soonBest,
Rajiv.
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,
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 RajivIt 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 announcementOn 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 RajivWhich 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-downloadsAnd 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 soonBest,
Rajiv.