Skip to main content

Questions tagged [mac-os-x]

An operating system published by Apple.

Filter by
Sorted by
Tagged with
14 votes
5 answers

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 ...
naxoc's user avatar
  • 241
203 votes
17 answers

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. ...
randomguy's user avatar
  • 2,171
6 votes
3 answers

Postgresql Database on external HD

My laptop has a small hard drive. I want to load a big data set. I have moved the entire /usr/local/var/postgres to the external hd, and symlinked it back. Now I'm getting this error, psql: could ...
m_br's user avatar
  • 69
4 votes
2 answers

DB2 Express-C on Mac OS X

I have followed all the steps described on the Getting Started with DB2 Express v9.7 e-book and installed DB2 Express-C on my Mac. The installation succeeded without a problem. I did setup OS X ...
ivanmp's user avatar
  • 2,323
3 votes
1 answer

How to properly stop MySQL server on Mac OS X?

I installed MySQL Community Server following instructions at with the Startup Item and the MySQL Preference Pane. I can stop the ...
qazwsx's user avatar
  • 3,457
35 votes
14 answers

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 ...
Meltemi's user avatar
  • 787
8 votes
2 answers

Uninstall Postgres 10 on macOS – EnterpriseDB installer

Title says it all… How to completely remove a Postgres cluster from a macOS computer? I used the installer app provided by EnterpriseDB as a courtesy to the community. This uninstallation question ...
Basil Bourque's user avatar
2 votes
2 answers

Start, stop, configure PostgreSQL through Mac terminal

I am having basic problems using PostgreSQL on my Mac OSX Yosemite, through the terminal. I tried google-ing but this is becoming increasingly difficult and info very scattered so I keep running into ...
Alexander Starbuck's user avatar
2 votes
1 answer

Is it okay to have different lower_case_table_names value on master and slave?

I have a OSX MySQL master with lower_case_table_names set to 2. I have just setup a Linux MySQL slave with lower_case_table_names=1. I haven't started replication on the slave, but everything looks ...
Boolean's user avatar
  • 611
143 votes
15 answers

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"?...
Michael P.'s user avatar
  • 2,101
116 votes
11 answers

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: ...
Jonas's user avatar
  • 33.3k
40 votes
3 answers

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 app icon, which ...
Basil Bourque's user avatar
6 votes
1 answer

Backup a database with a huge number of tables

Is there a way to backup a PostgreSQL database with a huge number of tables? An attempt with pg_dump for a database of about 28000 tables resulted in the following error message: pg_dump: WARNING: ...
krlmlr's user avatar
  • 371
4 votes
1 answer

How to control psql displaying rows with (END)?

After my computer upgraded from Mac Sierra to High Sierra, my psql started exhibiting an annoying behaviour. Sometimes when it lists rows, it prints (END) instead of the prompt, and I have to press ...
thomjah's user avatar
  • 115
3 votes
1 answer

PostgreSQL CREATE EXTENSION file not found error on Mac OS

On PostgreSQL 9.2.3 when trying this: CREATE EXTENSION btree_gist; I get this error: ERROR: could not open extension control file "/opt/local/share/postgresql92/extension/btree_gist.control": No ...
Ian Timothy's user avatar
0 votes
1 answer

Postgres to_tsvector is case sensitive on mac os

On PostgreSQL 10.4 on Ubuntu 10.4-2.pgdg16.04+1 select to_tsvector('simple', 'БОЛЬШИЕ БУКВЫ'); returns 'большие':1 'буквы':2 But on postgres 10.3 (installed by brew) on Mac Os High Sierra version ...
Sviatoslav's user avatar