Questions tagged [postgresql]
PostgreSQL is an open-source, relational database management system (RDBMS). Please mention your version of Postgres when asking questions. This tag is for questions concerning installing and running Postgres on OS X. Questions concerning administration or advanced features are best directed to https://dba.stackexchange.com/tags/postgresql or https://stackoverflow.com/tags/postgresql.
61 questions
0
votes
1
answer
87
views
Anybody still runs PostgreSQL server on OSX 10.11.6? And how do I get icu4c@76 to compile?
I used to have PostgreSQL@14 server running on my OSX 10.11.6 machine but just discovered lately that it is no longer working. When I tried to reinstall it, it always exit with error when installing ...
- 11
2
votes
1
answer
1k
views
brew says outdated when I upgrade to latest version [duplicate]
% brew search postgresql
==> Formulae
postgresql@10 postgresql@11 postgresql@12 postgresql@13 postgresql@14 postgresql@15 postgresql@16 qt-postgresql postgrest
% brew install postgresql@16
...
- 141
0
votes
1
answer
261
views
Unable to launch PostgreSQL on Macbook Air
I have downloaded the macOS version of PostgreSQL to my MacBook Air from postgresql.org, but I am unable to launch the downloaded program. Below is the error message I am getting:
- 101
1
vote
0
answers
1k
views
macOS Ventura has two copies of Postgres in Login Items
Just notice my Mac (running macOS Ventura 13.1) has two copies of postgres listed as Login Items in System Settings > General > Login Items. Clicking on the (i) button for EITHER one opens a ...
- 1,866
0
votes
0
answers
207
views
Disable Postgress App 2.5.12 Automatic Startup on Mac
I have installed postgress app 2.5.12 on my mac and it automatically starts with my system boot. I have checked System Settings > General > Login Items as well as /Library/LaunchDaemons and /...
- 11
4
votes
2
answers
13k
views
Brew postgresql@14 error on Mac M2
I have installed postgresql@14 via brew on my Mac M2.
Now, when I do brew services I get this output
postgresql@14 error 256 headmaster ~/Library/LaunchAgents/[email protected]
Can ...
- 143
3
votes
1
answer
3k
views
Remove PostgreSQL account from system
When I am accessing Fast User Switching, there is a PostgreSQL account:
I have uninstalled PostgreSQL account a while back, looked out libraries and no trace of folder PostgreSQL.
I am aware that I ...
- 87
0
votes
1
answer
481
views
Problems with PostgreSQL uninstallation
I decided to let go of postgreSQL today and ran the uninstaller as well as deleted rm /etc/postgres-reg.ini that the uninstaller says you have to remove manually. Now I cannot remember what the other ...
0
votes
1
answer
616
views
How can I delete the PostgreSQL user in my mac? because, there is no user in the preference [duplicate]
I forgot how I install postgresql before.
and now I have removed it by following this steps https://stackoverflow.com/a/9240197/12381565 .
But my postgresql user didn't gone from the taskbar,
...
- 1
1
vote
2
answers
1k
views
Error while installing PostgreSQL 12.9 on Apple Silicon (M1 Max) via asdf
I'm trying to install PostgreSQL via asdf-postgres plugin by running asdf install postgres 12.9 on 2021 MacBook Pro (with M1 Max, running Monterey 12.0.1) but getting the following error:
100 190 ...
- 111
1
vote
0
answers
2k
views
psql command will not work in cli MAC. ERR: connection to server on socket "/tmp/.s.PGSQL.5432" failed
I have installed home-brew v14 psql & psql app v14.
It will not allow me to use port 5432 (I spent a week getting this to work and it hasnt), so I have made a server on 4321 which will start.
when ...
- 391
27
votes
8
answers
77k
views
homebrew. Cant start service. get "Bootstrap failed: 5: Input/output error - Postgres - Mac
I am trying to re-install Postgres via home-brew on Mac.
I uninstalled Postgres, updated home-brew and ran the install command for brew install postgres
when I run brew services start postgresql
I get ...
- 391
0
votes
0
answers
2k
views
pgadmin 4 won't quit on Macbook Pro
I need to restart my Macbook Pro for a new OS update. Somehow the pgAdmin 4 won't quit even I try to quit it from its menu multiple times. Is another way to quit it?
- 101
1
vote
0
answers
639
views
Export Profile Manager database
Good morning,
I have an old Apple server with macOS 10.12 and Server.app version 5.3
Now I need export the information about devices with DeviceName, SerialNumber and ICCID (for iPad)
I found some ...
- 21
1
vote
0
answers
779
views
Command-line connection with VPN to remote PostgreSQL fails, other apps work
I am trying to connect to PostgreSQL database hosted on Azure programmatically.
I am able to do so using apps like PgAdmin or Postico. However, the connection does not work with psql or python. I have ...
- 121