Questions tagged [mac-os-x]
An operating system published by Apple.
162 questions
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
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
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
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
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
29
votes
1
answer
26k
views
Cannot locally import UTF-8 encoded SQL database on Mac
I was importing a confirmed UTF-8 encoded SQL database into Sequel Pro on Mac and got thrown this error halfway through:
An error occurred when reading the file, as it could not be read in
the ...
28
votes
1
answer
10k
views
Is there a psql equivalent of bash's reverse-search-history?
I am very fond of bash's reverse-search-history (C-r) (command-line feature):
Search backward starting at the current line and moving ‘up’ through the history as necessary. This is an incremental ...
- 1,979
16
votes
4
answers
70k
views
SQL Server on Mac
Can SQL Server engine express edition be installed on OS X? I use a MacBook at home and would like to use it as a testing/learning platform for SQL Server.
user33664
14
votes
5
answers
48k
views
MySQL server has gone away obstructing import of large dumps
I am trying to import a large sql dump (2GB) to my local mysql on my mac. I have been able to do this in the past (I was using MAMP), but now I get a
ERROR 2006 (HY000) at line 7758: MySQL server ...
- 241
13
votes
4
answers
53k
views
Can't remote access MySQL server running on Mac OS X
I have a MySQL server running on my work computer, which runs Mac OS X Maverick. I want to access it from home computer, which also has Mac OS Maverick.
From terminal, if in 1 tab, I ssh into my ...
- 231
13
votes
3
answers
22k
views
mysqld keeps automatically restarting
I am running mysqld on Mac OSX Al Capitan. After boot up, I ran mysql.server start to start mysqld server.
But when I ran mysql.server stop, or sudo mysql.server stop, it just stopped for a while, ...
- 245
12
votes
3
answers
40k
views
Homebrew installed PostgreSQL could not connect, database files are incompatible with server
Here's the error message I'm getting today when I attempt to log in to my localhost PosgreSQL databases using psql:
psql: could not connect to server: No such file or directory
Is the server ...
- 173
10
votes
5
answers
29k
views
Is there a Portable MySQL [closed]
For teaching and testing purposes I would like to run MySQL without actually having to install it.
I have found portable PostgreSQL for both Macintosh and Windows, which is good, but have been unable ...
- 3,239
9
votes
1
answer
6k
views
How to properly align columns in SQLite?
I recently began learning with SQLite, and I am trying to output the data of a table into the Terminal (macOS). However, the result after I've set .mode column or .mode tab is not properly aligned ...
- 193