I've found DBeaver [1] to be a good replacement after giving up with pgAdmin3 (I did love pgAdmin2, however).

Datagrip is also fine if you're a Jetbrains user.

I also found DBeaver to be a huge improvement over tools I used earlier.

Recently I discovered Jailer which makes it very easy to navigate complex relational structures: https://github.com/Wisser/Jailer