Can't get Postgresql to run properly on Big Sur

There is something very strange about running Postgresql on my iMac with Big Sur.


One of the things I did was to install something called DBngin, which allows me to start and stop postgres processes. I don't know if DBngin installed postgres or if Postgres comes with Big Sur by default, but when I start postgres with DBngin, a whole bunch of postgres processes are created.

Somehow I also have a psql client on my system which, on each invocation, starts and attaches to a postgres sever. So far so good, in that psql behaves exactly as expected. I can use it to create databases and issue SQL statements.


One thing I need which is not on my system is pg_restore. So I went to https://postgresapp.com/ and installed postgres from there. What I got was PgAdmin 4, which also worked, but did not attach to, nor create, a postgres server. As a matter of fact I could kill all of the running postgres servers and still have a working PgAdmin. Moreover, the databases I created with PgAdmin worked as expected but were entirely distinct from the database I created with psql, even if they had the same names.


So I have 3 questions:

1) how to I get psql and PgAdmin to work on the same databases?

2) how do I get all the other binaries that come with postgres?

3) why doesn't PgAdmin connect to a postgres process?



iMac Pro, macOS 11.3

Posted on Dec 7, 2021 10:26 PM

Reply
1 reply

Dec 7, 2021 10:42 PM in response to rkg1945

rkg1945 wrote:

I don't know if DBngin installed postgres or if Postgres comes with Big Sur by default...

No, it does not. It is not an Apple product, but is an open-source database system co-developed by PostgreSQL & Global Development Group. As such, your question may be best answered by directing them to these developers.


Ref:

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Can't get Postgresql to run properly on Big Sur

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.