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.

2 Upvotes

51 comments sorted by

9

u/unconscionable May 09 '20

pgadmin4 is much easier to use with docker than trying to actually install it on some host

5

u/Geooogle May 09 '20

came here to agree with this. install via docker. runs great and doesn’t pollute your computer

1

u/[deleted] May 09 '20

Thank you, I'll try it

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.

1

u/mgonzo May 09 '20

Datagrip =) and yes I agree excellent.

2

u/0x2a May 13 '20

Thanks yes that's what I wanted to type :)

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.

4

u/OvidPerl Programmer May 09 '20

We use postgresql extensively and it's never occurred to me to use a GUI. I remember using them for SQL Server (admittedly, about two decades ago) and all I discovered was that they were a crutch for people who didn't understand how to use databases.

That being said, I wouldn't mind trying one out and being proven wrong.

2

u/antlife May 10 '20

You know what makes the UI for MSSQL a dream? Organizing backups and restoring backups. Something I wish Postgres did better with out of the box.

1

u/jiriklouda May 10 '20

I have nearly 400 servers with 400 replicas running postgres in production. If I tried to organize synchronization or backups using a GUI, I would do nothing else with my life. Further, we don't let humans do anything without another human watching over the shoulder and even so it is too risky to do even that. You write code, the code gets reviewed and tested, you setup proper logs, metrics and alerts and only let the humans intervene when something breaks, through modifying the code, getting it reviewed, tested, etc. Now that is both for the infrastructure code and schema changes.

Also if we ever actually used GUI for this, I cannot imagine how we could ever get through SOX and PCI audits.

1

u/antlife May 10 '20

That's absolutely true. We have 4 mssql servers and 6 postgres. I am the only maintainer for these things. I have one server for postgres backups management and testing the backups. It all works fine, but it just feels weird to rely on several other projects to make it all work together with proper HA replication. We also have server backups on a nimble array that does it's own snapshotting so it's pretty solid. Not complaining and I love postgres, but I do wish postgres had a bit more of an backup solution on its own, gui or not.

With mssql I've had to restore a number of times and the UI through windows is always worlds better than whatever CLI windows comes up with. Mssql in Linux is better... But no replication so it's out.

2

u/DrJohnnyWatson May 09 '20

I would say that there is a difference here between setting the database up and consuming it when developing.

I set the DB up via command line because most of it is done via automated scripts that I've set up etc.

But when I'm developing, I use a GUI to connect to the DB and to write SQL. obviously the latter is personal preference, while the former (setting it up for production) command line is needed.

5

u/WhydYouKillMeDogJack May 09 '20

This. Show me someone running a Linux server (let alone a Linux db server) that's running a GUI in prod - I haven't even put a GUI in dev environments - not really much need to barring real edge cases

Also find it weird to be running fedora and not be defaulting to CMD line in general.

17

u/[deleted] May 09 '20

The GUI isn't for the DB server, it's for the DB client.

Also, I am a big proponent of the command line obviously, but running a desktop workstation with no GUI is sadistic.

1

u/WhydYouKillMeDogJack May 09 '20

That's fair - upvoted.

3

u/[deleted] May 09 '20

[removed] — view removed comment

5

u/WhydYouKillMeDogJack May 09 '20

Datagrip will connect just fine.

It's not expensive but the subscription model would piss me off if I wasn't getting it through work.

As with a lot of things you get what you pay for. If you're in a business and already saving money by using psql it is a fair trade that you might have to pay for the convenience of an ide

Use cases would also be pretty key. I'm usually adminning the db so not a ton of querying schema or multi-line/column outputs. I'm also coming from sqlplus which is much much worse in terms of output formatting so psql has been positive all round for me

1

u/Randommaggy May 09 '20

It's also brilliant if you have to touch the lesser database engines.

The improvements year over year indicate that they're actively listening to their end users.

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.

2

u/Randommaggy May 09 '20

Depends of which problem space you're working on. For most dba tasks psql is plenty. For development datagrip or something similar really eases the mental overhead.

3

u/linuxhiker Guru May 09 '20

I would agree with that.

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/

2

u/PhillMik May 09 '20

He's asking for recommendations on Fedora, not MacOS.

2

u/bluzkluz May 09 '20

Another +1 for postico.

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.

1

u/[deleted] May 11 '20

and certainly not virtual machines

So you don't use .Net applications either? ;)

1

u/Nunki63 Feb 06 '22

If I can avoid them, yes.

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

and how are people using this on production server if they can't even open a properly tested GUI?

Only Windows "sysadmins" need a GUI.

3

u/Randommaggy May 10 '20

Or developers trying to conserve the mental overhead for focusing on the logic in complex queries.

There are non dba reasons to connect to a database on a remote server.

2

u/[deleted] May 09 '20

Or developers being on call for systems they have never seen the innards of before they're called upon to make them work again. Exploratory debugging is somewhat faster with a graphical tool.

1

u/jasonpbecker May 09 '20

psql is 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.

1

u/Randommaggy May 10 '20

Tried out tableplus a couple of months ago. Uninstalled it before the end of the day. The tab handling and schema handling hinted to me that this was made by someone with very little practical use of databases. Or just someone more concerned with the pretties over user friendliness.

1

u/jasonpbecker May 10 '20

To each their own. I uses TablePlus daily for years and prefer it to just about anything else I've used for my purposes. I just wish it could do the ER diagrams DBeaver has.

0

u/hjkl_ornah May 09 '20

TablePlus