Questions tagged [mac-os-x]
An operating system published by Apple.
162 questions
144
votes
15
answers
376k
views
PostgreSQL not running on Mac
The error in its entirety reads:
psql: could not connect to server: No such file or directory. Is the
server running locally and accepting connections on Unix domain socket
"/tmp/.s.PGSQL.5432"?
...
- 2,111
210
votes
17
answers
366k
views
How do I find PostgreSQL's data directory?
I forgot how I started PostgreSQL the last time (it was months ago) and I don't remember where the data directory is located. The postgres command seems to require the location of the data directory.
...
- 2,241
119
votes
11
answers
392k
views
How to run psql on Mac OS X?
I installed PostgreSQL on a computer with Mac OS X using the One click installer. Then I try to access PostgreSQL using the psql command, but it doesn't seem to be available.
I get this message:
...
- 34.1k
0
votes
0
answers
277
views
Unable to connect to server connection failed: connection to server at 127.0,0,1 post 5432 failed could not receive data from server
I installed PgAdmin 4 to my MacBook Pro Sonoma version 14.4.x and once it opened I attempted to create a server or register a server and I have host name/address as localhost, port 5432, maintenance ...
- 281
0
votes
0
answers
160
views
Upgrading database instance for MongoDB 4.2 to 4.4 requires legacy MongoDB on Macosx
I'm running MongoDB within a ten year old node app, and in the process of upgrading node had to upgrade MongoDB. For some time, I have been using MongoDB community 4.4 to run the database, but in the ...
- 101
0
votes
1
answer
88
views
PostgreSQL setup issue on macOS Monterey: initdb error encoding mismatch
I'm having issue while installing PostgreSQL 16 on macOS Monterey via MacPorts.
So far, these looked OK:
$ sudo port install postgresql16-server
---> Computing dependencies for postgresql16-server
...
- 103
45
votes
4
answers
40k
views
Is it possible to install just the mongo Shell?
I have Docker installed and am running a MongoDB container for my local development on my Mac. The problem is that I can't connect to said DB easily from CLI. I have Robo 3T installed, but I would ...
- 553
40
votes
3
answers
49k
views
pgAdmin 4 version 3 fails to open a second time
I just installed pgAdmin 4 version 3.0.0 for macOS Sierra, replacing the pgAdmin that came bundled with Postgres 10.3 running locally on the same Mac.
I opened the pgAdmin 4.app app icon, which ...
- 11.3k
5
votes
3
answers
2k
views
Differences in PostgreSQL 14 collation behavior on Linux and Mac
I have PostgreSQL installed on my Mac and Ubuntu Server as shown below:
atsweb=# select version();
version ...
- 151
1
vote
1
answer
7k
views
PostgreSQL: managing the postmaster PID
I am running PostgreSQL on my localhost on MacOS. Every once in a while (~ every 5 times I reboot the computer), I face the following error when I try to connect to my local database instance:
could ...
- 219
0
votes
0
answers
2k
views
Can not start MongoDB community edition on Mac
Following Install MongoDB Community Edition on macOS:
Started like this: brew services start [email protected]
no error was raised, but when I do: brew services list
kukodajanos@Kukodas-MacBook-...
- 101
34
votes
14
answers
163k
views
PostgreSQL is running locally but I cannot connect. Why?
Recently updated my machine from Mac OS X Lion (10.7.4) to Mountain Lion (10.8) and I think it borked my PostgreSQL installation. It was installed originally via Homebrew. I'm not a DBA, but hoping ...
- 777
0
votes
3
answers
2k
views
mysql starts and stops servers automatically non stop
I am working on macOS High Sierra.
Basically, the problem is that for some reason the mysql server is starting and stopping automatically, and constantly. It does not stop. If I run:
# ps -ax | grep ...
- 9
3
votes
2
answers
1k
views
macOS Catalina - postgreSQL - sysctl.conf still relevant?
I had the following settings in /etc/sysctl.conf before Catalina:
# PostgreSQL Config for the MAC
kern.sysv.shmmax=2147483648
kern.sysv.shmall=524288
kern.sysv.shmmin=1
kern.sysv.shmmni=32
kern.sysv....
- 161
6
votes
6
answers
75k
views
After fresh install getting `psql: command not found`
I downloaded and installed PostgreSQL and PostGIS from KyngChaos for my OS X 10.10 install. When I run psql I get,
bash: psql: command not found
According to the site How to run psql on Mac OS X? it ...
- 187