Access local postgres with SequelPro

Question

I am using Sequel Pro and want to access my local Postgres DB.

When I get prompted in sequel pro to add connection details for my db I oblige:

And then when I click connect I get:

I am on a mac running Catalina 10.15.3.

The database I am running is a postgres installed with brew. When I run brew services list I get:

My application (a laravel application using laravel valet) can access the database.

What can be wrong? I have some thoughts...

If I enter my db and type: select inet_server_addr( ), inet_server_port( );

I get this output:

 inet_server_addr | inet_server_port
------------------+------------------
                  |
(1 row)

And I think that I should get 127.0.0.1 at least in the inet_server_addr column....

I don't know if this is a hint of where the error might be or not.

So, to summarize. My thoughts go in the direction that I am not running the postgres server 100% correctly... BUT i still think it is strange that my app can access the db but not Sequel Pro...

If I typ 127.0.0.1 in my browser I get a 404 - Not Found

How do I do to be able to access my local postgres with Sequel Pro?

Do not paste images of text. meta.stackoverflow.com/questions/303812/… — Jonathan Hall
– Jonathan Hall, Commented May 9, 2020 at 11:45

Brainmaniac · Accepted Answer · 2021-06-28 15:27:15Z

36

As a_horse_with_no_name pointed out in the comments, the website states that Sequel Pro is for MySQL databases, not Postgres:

"Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases."

edited Jun 28, 2021 at 15:27

answered Mar 31, 2020 at 9:13

Brainmaniac

2,6347 gold badges35 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kevinleary.net · Accepted Answer · 2024-06-11 19:29:06Z

1

There's a nice replica:

SQLPro for Postgres

It's not free like SequelPro though.

answered Jun 11, 2024 at 19:29

Kevinleary.net

9,8384 gold badges59 silver badges49 bronze badges

Collectives™ on Stack Overflow

Access local postgres with SequelPro

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related