Questions tagged [mac-os-x]
An operating system published by Apple.
29
questions with no upvoted or accepted answers
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....
- 151
3
votes
1
answer
390
views
Installing Postgresql parray_gin extension on mac, include not found
I am trying to install parray_gin in PostgreSQL 10 on macOS, but I can't get it to build.
I'm running pgxn install parray_gin. This first gave me a missing stdio.h error, so I installed the xcode ...
- 131
3
votes
0
answers
44
views
Upgrade PostgreSQL 9.3 without moving the DB and messing PostGIS on OSX OpenGeo Suite original installation
I looked for the answer, but could not find a specifically fitting one, so would appreciate an answer or a pointer to one...
Q: How do I upgrade PostgreSQL 9.3 to the current (now 9.6 ?) without ...
- 763
2
votes
0
answers
227
views
Slow create/truncate tables
I have a problem with the performance of my MariaDB server in osx arm64 (M1):
I installed MySQL server via Homebrew, after a while I reinstalled it on MariaDB 10.7.3 via Homebrew.
after that, the ...
- 21
2
votes
0
answers
1k
views
Postgres Service Not start using via HomeBrew
I have to install homebrew in my macOS then after I tried to install Postgres on my mac using the homebrew. but when I checked my Postgres status is it not running.
/usr/local/Cellar/postgresql/11.4/...
- 121
2
votes
0
answers
3k
views
Postgres default databases
I went through a re-installation of postgresql on a mac using brew and I'm not sure about some default vs user created databases.
After the installation I see 2 users:
postgres
dan (being my osx ...
- 121
2
votes
1
answer
2k
views
error connecting to master '[email protected]:3306' mac-ubuntu
Server info:
Master server (Vmware): Ubuntu 18.04 IP: 192.168.57.10
Slave server1 (Vmware): Ubuntu 18.04 IP: 192.168.57.11
Slave server2 (mac): macOS High Sierra IP: 192.168.0.3
MySQL Server ...
- 41
2
votes
0
answers
1k
views
How to unlock / repair mysql.sock
My issues have spawned from file permission changes leading to the popular ERROR! MySQL server PID file could not be found! error. However, I believe I've repaired them, but still cannot restart MySQL....
- 121
2
votes
0
answers
226
views
connecting to a database via tsql on mac 10.10.4
I'm trying to connect to a database via tsql.
I use the following command:
TDSVER=8.0 tsql -S <server IP> -p 1433 -U <my username> -P <my password>
Now, I know the server IP is ...
- 121
2
votes
0
answers
366
views
Remove Mac OSX Lion pre-installation of PostgreSQL
I'm running Lion 10.7.5, and I'm trying to install Postgresql 9.2.4 for use with Django. I have hit countless roadblocks and errors, so I would like to start with a totally clean slate.
I did a brew ...
- 121
2
votes
0
answers
3k
views
"custom archiver out of memory" error when restoring large DB using pg_restore
I'm trying to a restore a local copy of a 30GB DB (with only one table) dumped using the Heroku wrappers (described here) using pg_restore. The Heroku DB is using 9.1.7 and I have had the same result ...
- 345
1
vote
0
answers
989
views
Is it possible to update Mac mysqldump version to same version as what's available for Ubuntu?
I run the following command on Mac Big Sur
mysqldump --column-statistics=0 -v -h my host -u myuser -P 3306 -pmypass mydb my_table > /tmp/dump.sql
Which uses the following version of mysqldump …
$ ...
- 643
1
vote
1
answer
3k
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
1
vote
0
answers
2k
views
Show Collections in MongoDB throwing
I am connecting to MongoDB hosted on EC2 instance of AWS. I am connecting through ssh command.
Upon entering the command "show collections", I am getting uncaught exceptions. Please see the sequence ...
- 107
1
vote
0
answers
2k
views
Incorrect syntax near 'BULK' for bulk INSERT in Azure Data Studio
I am trying to bulk insert a large CSV file delimited by tabs. I am on a Mac, and executing queries on Azure Data Studio (formerly SQL Operations Studio), since SSMS is not available for Macs. Here is ...
- 111
1
vote
0
answers
923
views
Upgrading PostgreSQL from 9.6.6 to 10.1
I'm attempting to upgrade my local instance of postgres to 10.1 (from 9.6.6) on macOS. Using this gist as a guide, I've encountered a problem when running pg_upgrade. Here are the steps taken:
$ mv ...
- 111
1
vote
0
answers
4k
views
Getting "pg_ctl: No such file or directory" when trying to start Postgres server on Mac
I'm using Postgres 9.5 on Mac Sierra. My postgres db suddenly died, and so I need to restart it, but I'm getting some errors when I try and run
/usr/local/var/postgres start
below tells the saga .....
- 643
1
vote
0
answers
543
views
FATAL: role "MYUSERNAME" does not exist
I am new to psql and am trying to set it up using the Postgres.app site on my Mac. After installation and opening psql, this is the message I get:
Last login: Sat May 21 07:10:21 on ttys000
'/...
- 11
1
vote
0
answers
470
views
MySQL database problems all of a sudden-- users' programs can't connect, I saw error 2013, error 32
I am editing my problem, based on what I've researched and done:
Hi
This is mysql running on an osx server.
We suddenly have an issue where only one of anything can seem to connect to mysql at ...
- 11
1
vote
0
answers
2k
views
System Preferences quits unexpectedly due to MySQL plug-in
I've installed MySQL Preference Pane on my MacBook to start/stop MySQL from my System Preferences and it works ok, except that once in a while System Preferences just quits and shows this message:
...
- 171
1
vote
1
answer
18k
views
How to fix "Access denied for user 'root'@'localhost'" error for MySQL using Mac OS X?
After reading a few of the similar problems to mine and none of them working, I thought I'd attempt to be more specific to see if my root problem needed to be fixed differently than the others.
I've ...
- 175
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
0
votes
0
answers
709
views
Installing older versions of timescaledb for postgresql on macos
I'm running postgresql 14.1 on MacOs Monterey, this was installed as a requirement of timescaledb which is at version 2.5.1.
I had issues while installing timescaledb with another version of ...
- 11
0
votes
0
answers
502
views
How to get MySQL database to stop repeatedly turning itself off and on?
I am running a local MySQL database on my Macbook, and when it works it works. But every once in awhile, it will have turned itself off. Then when I start it again, it will repeatedly stop and start ...
- 101
0
votes
0
answers
833
views
MariaDB failing steps to reset lost root password
I'm running a local copy of MariaDB on OS X from Homebrew. It's working fine, but I've forgotten my root password (yeah, I know) and the usual reset is failing like this:
$ mysqld_safe ‐‐skip-grant-...
- 151
0
votes
1
answer
345
views
Installed mysql 8 on Mac then mysql 5.7 now now they wont work
I have a brand new Macbook pro with Mojave. I installed mysql 8 using the dmg file but realized that Sequel Pro is not playing nice with it and after researching I decided to install mysql 5.7. This ...
- 1
0
votes
1
answer
1k
views
Starting MySql Failed: check log for more info
I just recently started using MAMP, PHPmyAdmin, and wordpress. When I try to restart the server in MAMP PRO by pressing the server icon in top right corner (mamp pro), I get a pop up that reads the ...
- 1
0
votes
0
answers
421
views
How to restore database from a Mac OS X disk image?
So I did take the ship with brave Capitan, and the ship ran aground... My Mac OS 10.11 tried to upgrade to 10.11.1 and freeze my Macbook! There was no backup, Time Machine stop working, so I did a dmg ...
- 101
0
votes
1
answer
5k
views
pg_hba.conf and postgresql.conf in old installation directory
I have installed the PostgreSQL 9.4 on my MacBook via MacPorts, and I am trying to edit pg_hba.conf, but I don't see it in my current installation. Furthermore, psql is reporting that config_file is ...
- 1