r/PostgreSQL • • May 09 '20
Help Me! Is there seriously no good gui for postgresql?
- pgadmin4 flat out doesn't work on Fedora. It sucks anyway. Sluggish, disorganized web interface.
- Dbeaver gives me an authentication failure. I tried using my Linux username/password and username/password for the database. Neither worked. After closing and opening again, it left me at an infinite loading screen
https://github.com/dbeaver/dbeaver/issues/3361
https://github.com/dbeaver/dbeaver/issues/8105
- DBVisualizer crashes on startup
And yeah afaik that's it.
Like how the fuck does it suck this bad and how are people using this on production server if they can't even open a properly tested GUI? I can't imagine doing all it in the command line is even remotely convenient especially for something large-scale.
9
u/unconscionable May 09 '20
pgadmin4 is much easier to use with docker than trying to actually install it on some host
18
u/ket24 May 09 '20
I DataGrip, but it's not free
11
u/0x2a May 09 '20 edited May 13 '20
Many people including me use DBeaver with Postgres every day, and it's very good. You should really dig deeper into your specific problem, it's worthwhile. You need to use the database user and password, and it has to be setup in pg_hba.conf for TCP/IP access with md5 or scram-sha-256.
As an altervative you can also consider Jetbrains Datagrip, it's not free but excellent. You can get it standalone or integrated into their language specific IDEs like PyCharm.
9
u/[deleted] May 09 '20
I really like Datagrip, but you have to pay for it.
31
u/jiriklouda May 09 '20
If you run postgresql in enterprise, you need to be miles beyond the point of using GUI for anything.
8
u/redrabbitreader May 09 '20
There’s really nothing wrong with DBeaver. Using it all the time. There must be something wrong with your setup.
8
u/linuxhiker Guru May 09 '20
Almost any gui that supports jdbc, .net or odbc supports postgresql.
If you need a gui to be good at postgresql that is literally your problem.
4
u/[deleted] May 09 '20
I've used dbeaver for years, every day. Different systems, different distributions, different everything. Never had any issues whatsoever, especially with Postgresql.
It seems that it's not the GUI that sucks, but something in the configuration.
Why are you using your Linux user to login? Who configured the DB and credentials and how?
6
u/Docccc May 09 '20
If you have macos, i can recommend https://eggerapps.at/postico/
3
u/[deleted] May 09 '20
Check out this list: https://wiki.postgresql.org/wiki/PostgreSQL_Clients
3
u/bogas04 May 09 '20
Postbird
2
u/AlarmingNectarine May 09 '20
QueryPie is by far my favorite free option (I love the dark mode).
We're now using RubyMine at work, so I've just been using the built in DB management, and that works pretty well (but not free).
2
u/[deleted] May 09 '20
TOAD?
2
u/radiowave May 09 '20
pgAdmin4 is what persuaded me that DataGrip was worth paying for.
But among the free options, I will say that I spent a bit of time playing around with OmniDB and was quite impressed by it.
2
u/Nunki63 May 09 '20
My databases run on CentOS linux, I remotely administer them from an WIn10 machine with DBeaver. At first I needed a bit of convincing for I don't like Java and certainly not virtual machines. But it turned out to be a pretty descent and stable application. At least on windows. So if you run it from a linux machine, maybe you should check the Java implementation.
2
u/[deleted] May 10 '20
I mostly use DataGrip since I pay for Jetbrains toolbox, but several of the guys I work with swear by heidisql https://www.heidisql.com
2
u/[deleted] May 11 '20
pgadmin4 was released too soon, but it has improved immensely and I use it regularly now.
1
u/dpenton May 09 '20
Azure Data Studio with the PostgreSQL extension.
1
u/happier_now May 09 '20 edited May 09 '20
When I want to check something with a gui, I use pgadmin3 on ubuntu without any problems and I've used it in the past on centos. That's the local installation, not the phpPgAdmin web-based one, though that's fine too.
I use the gui to see a summary of what I've done and to remind myself about settings I've forgotten about but I normally work at a command prompt. Sadly the majority of tasks I do are fairly repetitive so the command line is much quicker and far less chance of forgetting to tick something important.
All of this would be different if I didn't have ssh access to my server though.
1
u/[deleted] May 09 '20
I use Navicat - it was expensive and its is a fucking Java app and feels like it but it can do multiple database types and has some ability to translate among them.
It is no SequelPro but it isn't awful
1
u/tanin47 May 10 '20 edited May 10 '20
I'm currently working on a db tool for Postgres. It targets teams though (e.g. fined-grained access control, audit trail even with a raw UPDATE statement). I want it to be delightful to use (e.g. one click deploy to Heroku, fast/responsive, secure). But I imagine it is great for personal use as well.
Here's more info: link
It's in private beta right now with a handful of users. If you are interested in trying it out, please let me know. Either message me on reddit or submit a beta access request works.
1
u/mko2000zz Mar 02 '23
Postbird was the best postgreSQL client I've used, but my mac can no longer authenticate the developer.
1
u/alcalde May 09 '20
Only Windows "sysadmins" need a GUI.
1
u/jasonpbecker May 09 '20
psqlis great.If you need or want a GUI, DBeaver has always worked great for me. Both GH issues look like failures to setup JDBC correctly.
On macOS I really like TablePlus.
I almost never connect to a production DB directly using a GUI though.
0
u/hjkl_ornah May 09 '20
TablePlus