search

hackoregon / linux-laptop-setup

2 stars 0 forks source link

Update to pgadmin 4 #8

Closed znmeb closed 7 years ago

znmeb commented 7 years ago

PgAdmin3 is no longer maintained and the EnterpriseDB PostgreSQL 9.6 stack ships PgAdmin4

znmeb commented 7 years ago

PgAdmin4 is definitely not beginner-friendly. There's no Ubuntu package for it yet; it's a Python web app.

znmeb commented 7 years ago

Note to self: see how the EnterpriseDB stack works on Linux.

znmeb commented 7 years ago

PgAdmin4 doesn't seem to know how to connect to PostgreSQL using the default Unix socket mechanism. This isn't a show-stopper; you should password the localhost connection anyhow. But it's another non-beginner-friendly stop point.

znmeb commented 7 years ago

And ... pgadmin3 whines about only supporting PostgreSQL up to 9.5. It does connect, though. Rocks, hard places, bullets to bite, etc. ;-)

znmeb commented 7 years ago

Good news ... the EnterpriseDB stack install works on Linux essentially the same way it works on Windows, including PgAdmin4. It's probably the same on Macs - need to test that.

So the database developers can use an EnterpriseDB stack on their workstations / laptops - 9.5 or 9.6 depending on which we deploy.

znmeb commented 7 years ago

Issue on hold pending decision of PostgreSQL 9.5 vs 9.6

znmeb commented 7 years ago

Closing ... for now we're going with PostgreSQL 9.5, pgadmin3 and PostGIS 2.2. Reopen if there's consensus for an upgrade.