Questions tagged [mac-os-x]
An operating system published by Apple.
16
questions
14
votes
5
answers
47k
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
197
votes
17
answers
319k
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,111
6
votes
3
answers
13k
views
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 ...
- 69
4
votes
2
answers
3k
views
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 ...
- 2,323
3
votes
1
answer
13k
views
How to properly stop MySQL server on Mac OS X?
I installed MySQL Community Server following instructions at
http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html
with the Startup Item and the MySQL Preference Pane.
I can stop the ...
- 3,457
34
votes
14
answers
158k
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
7
votes
2
answers
11k
views
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 ...
- 10.6k
2
votes
2
answers
16k
views
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 ...
2
votes
1
answer
2k
views
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 ...
- 611
139
votes
15
answers
345k
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,061
113
votes
11
answers
349k
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:
...
- 32.6k
40
votes
3
answers
48k
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 ...
- 10.6k
6
votes
1
answer
7k
views
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: ...
- 361
4
votes
1
answer
5k
views
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 ...
- 115
3
votes
1
answer
4k
views
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 ...
- 885
0
votes
1
answer
1k
views
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 ...
- 103