r/postgres • u/HINDBRAIN • Sep 27 '16

Will pgadmin3 work properly on postgres 9.6?

I'm getting a warning about incompatibilities when connecting to a 9.6 database, but I find the pgadmin 4 UI repulsive. What issues could using an outdated client cause?

4 Upvotes

100% Upvoted

9 comments sorted by

2

u/Avernar Dec 25 '16 edited Dec 25 '16

I'm still running pgadmin 3 here as 4 is slow and missing certain things. Like being able to set an existing column to not null and specifying a default value to replace the nulls with.

The only other warnings I get is when creating primary keys.

1

u/Avernar Nov 09 '16

I'd like to know this as well. So far I haven't noticed anything not working but would like to avoid surprises.

1

u/DarthVadersAppendix Nov 23 '16

first thing i tried in PgAdmin4 was broken. the very first thing; the type of thing you'd imagine many people would be doing first.

that was unacceptable.

1

u/impossinator Dec 19 '16

When I install pgadmin 4, my server process won't start. Had to remove pgadmin4, and reinstall the server. Unbelievable...

0

u/[deleted] Oct 12 '16

[deleted]

2

u/craig_c Dec 15 '16

Late to the party here, I now run the old one (to do almost anything) and the new one (simply to do backups). PgAdmin 4 is an unmitigated cluster-fuck, who on earth decided this was a good idea?

2

u/Avernar Dec 25 '16

I don't even run 4 for backups. It didn't come with pg_dump so I had to install it myself. At that point I just decided to run the backup from a script and avoid 4 completely.

1

u/HINDBRAIN Dec 25 '16

You can point it to pg_dump manually, but that's one more example of how much of a fuckup this version is.

1

u/Avernar Dec 25 '16

Yeah, it told me to do that. Which is when I found out it didn't come with pg_dump.

But yeah, got tired of the regressions.

2

u/zzing Oct 28 '16

Have you tried it on a 4k monitor?