Postgres Pro
Downloads
Home   >   mailing lists

Thread: a recommendation on admin tool

a recommendation on admin tool

From
john fabiani
Date:
Hi Everyone,

Off Topic:

I primarily use Linux as my development platform (current using OpenSuse 15.x).  I have used PgAdmin for years to administrate the database.  But PgAdmin4 is now the replacement to version 3 and I think it sucks!

So I'm looking for a replacement.  I would like the tool to be cross platform and I am willing to pay a reasonable amount for the tool.

Hoping someone can point me to a good replacement.

Johnf

Re: a recommendation on admin tool

From
William Ivanski
Date:
Hi,

Please check out OmniDB: https://omnidb.org/en/

It is open source and there are several features for PostgreSQL databases: Monitoring Dashboard, Query Plan Visualization, Console Tab, PL/pgSQL Debugger, and many others.

On Fri, Feb 1, 2019 at 5:16 PM Martin Stöcker <martin.stoecker@stb-datenservice.de> wrote:
Hi,

some days ago Sebastian Insausti blogged this

https://postgr.es/p/4kI

Martin

Am 01.02.2019 um 20:11 schrieb john fabiani:
Hi Everyone,

Off Topic:

I primarily use Linux as my development platform (current using OpenSuse 15.x).  I have used PgAdmin for years to administrate the database.  But PgAdmin4 is now the replacement to version 3 and I think it sucks!

So I'm looking for a replacement.  I would like the tool to be cross platform and I am willing to pay a reasonable amount for the tool.

Hoping someone can point me to a good replacement.

Johnf



--
William Ivanski - 2ndQuadrant
PostgreSQL Development, 24x7 Support & Remote DBA, Training & Services

Re: a recommendation on admin tool

From
Martin Stöcker
Date:
Hi,

some days ago Sebastian Insausti blogged this

https://postgr.es/p/4kI

Martin

Am 01.02.2019 um 20:11 schrieb john fabiani:
Hi Everyone,

Off Topic:

I primarily use Linux as my development platform (current using OpenSuse 15.x).  I have used PgAdmin for years to administrate the database.  But PgAdmin4 is now the replacement to version 3 and I think it sucks!

So I'm looking for a replacement.  I would like the tool to be cross platform and I am willing to pay a reasonable amount for the tool.

Hoping someone can point me to a good replacement.

Johnf

Re: a recommendation on admin tool

From
basti
Date:
phadmin3 is still alive.

In the apt repo of postgresql.org there is a version pgadmin3_1.22.2-4
(also in debian buster) which support Postgres10 but I can't find is for
suse at the moment.

BigSQL has also release a pgadmin3 LTS
(https://groups.google.com/a/bigsql.org/forum/#!topic/feedback/9ltRFsP8m_g)
I don't know if it work on suse. I have never try it.

Perhaps you can build one of them from source?

Best Regards,

On 01.02.19 20:11, john fabiani wrote:
> Hi Everyone,
> 
> Off Topic:
> 
> I primarily use Linux as my development platform (current using OpenSuse
> 15.x).  I have used PgAdmin for years to administrate the database.  But
> PgAdmin4 is now the replacement to version 3 and I think it sucks!
> 
> So I'm looking for a replacement.  I would like the tool to be cross
> platform and I am willing to pay a reasonable amount for the tool.
> 
> Hoping someone can point me to a good replacement.
> 
> Johnf

Re: a recommendation on admin tool

From
"Jonathan S. Katz"
Date:

On Feb 1, 2019, at 2:11 PM, john fabiani <johnf@jfcomputer.com> wrote:

Hi Everyone,

Off Topic:

I primarily use Linux as my development platform (current using OpenSuse 15.x).  I have used PgAdmin for years to administrate the database.  But PgAdmin4 is now the replacement to version 3 and I think it sucks!

I’m sure the people who work on pgAdmin4 would like to hear about your
experience to better understand why you think “it sucks” and perhaps
provide some pointers or use the feedback to continue to improve pgAdmin4.

Information about getting in touch with the pgAdmin team can be found here:


Thanks,

Jonathan

Attachment

Re: a recommendation on admin tool

From
john fabiani
Date:
Yes I'm sure that's true.  That said, I believe they just going the wrong way with their development.  It's  my understanding I'm not the only  one complaining.  I am also sure there are many who like the direction they are going - I'm just not one of them.  I guess this is one of those situations were you like it a lot or you hate it.

Johnf 

On 02/01/2019 03:41 PM, Jonathan S. Katz wrote:

On Feb 1, 2019, at 2:11 PM, john fabiani <johnf@jfcomputer.com> wrote:

Hi Everyone,

Off Topic:

I primarily use Linux as my development platform (current using OpenSuse 15.x).  I have used PgAdmin for years to administrate the database.  But PgAdmin4 is now the replacement to version 3 and I think it sucks!

I’m sure the people who work on pgAdmin4 would like to hear about your
experience to better understand why you think “it sucks” and perhaps
provide some pointers or use the feedback to continue to improve pgAdmin4.

Information about getting in touch with the pgAdmin team can be found here:


Thanks,

Jonathan


Re: a recommendation on admin tool

From
john fabiani
Date:
This list appears to be a new list - I'm checking it out as I type.   That said, I really wonder what everone is using for the latest version of Postgres 11.

Thanks,

Johnf

On 02/01/2019 11:19 AM, Martin Stöcker wrote:
Hi,

some days ago Sebastian Insausti blogged this

https://postgr.es/p/4kI

Martin

Am 01.02.2019 um 20:11 schrieb john fabiani:
Hi Everyone,

Off Topic:

I primarily use Linux as my development platform (current using OpenSuse 15.x).  I have used PgAdmin for years to administrate the database.  But PgAdmin4 is now the replacement to version 3 and I think it sucks!

So I'm looking for a replacement.  I would like the tool to be cross platform and I am willing to pay a reasonable amount for the tool.

Hoping someone can point me to a good replacement.

Johnf


Sv: Re: a recommendation on admin tool

From
Andreas Joseph Krogh
Date:
På lørdag 02. februar 2019 kl. 02:25:13, skrev john fabiani <johnf@jfcomputer.com>:
This list appears to be a new list - I'm checking it out as I type.   That said, I really wonder what everone is using for the latest version of Postgres 11.

Thanks,

Johnf
 
 
I've used PostgreSQL for > 20 years now, and have always used the command-line tools which comes with it.
That said, doing most of my work programming in Scala and using IntelliJ IDEA, I use IDEA as a query-tool as it has excellent PG-support, syntax-highlighting, autocomplete and such.
 
BTW; This list isn't new, I started using it in 2002: https://www.postgresql.org/message-id/3C5FBB0C.9060304@xythos.com
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

Re: Sv: Re: a recommendation on admin tool

From
john fabiani
Date:
It may not be a new list (actually I mis-spoke I should have said the links work).  But I'm glad Martin posted the link (https://severalnines.com/blog/top-gui-tools-postgresql) which provided a link to DBeaver.   So far DBeaver is working and I'm able to increase the font size (default is way to small) and few other tweaks I needed. 

Thanks,

Johnf

On 02/02/2019 03:14 AM, Andreas Joseph Krogh wrote:
På lørdag 02. februar 2019 kl. 02:25:13, skrev john fabiani <johnf@jfcomputer.com>:
This list appears to be a new list - I'm checking it out as I type.   That said, I really wonder what everone is using for the latest version of Postgres 11.

Thanks,

Johnf
 
 
I've used PostgreSQL for > 20 years now, and have always used the command-line tools which comes with it.
That said, doing most of my work programming in Scala and using IntelliJ IDEA, I use IDEA as a query-tool as it has excellent PG-support, syntax-highlighting, autocomplete and such.
 
BTW; This list isn't new, I started using it in 2002: https://www.postgresql.org/message-id/3C5FBB0C.9060304@xythos.com
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 

Attachment