Questions tagged [mac-os-x]

An operating system published by Apple.

Filter by
Sorted by
Tagged with
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 ...
5 votes
5 answers
57k 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 ...
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 ...
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 ...
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 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 ...
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 ...
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....
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: ...
1 vote
1 answer
2k views

Can’t connect to local PostgresSQL server [closed]

I have the Postres app installed an running on my Mac. And it has worked beautifully. I don’t know what changed, but now I cannot connect to it from Rails, PG Commander, PG Admin or the command psql -...
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"?...
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-...
5 votes
3 answers
930 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 ...
0 votes
2 answers
1k 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 ...
1 vote
1 answer
5k views

How do I upload an .mdf file to Azure Data Studio for Mac?

How could I access multiple databases at once using Azure Data Studio and import an existing .mdf file as one of those database, with tables and data that had been stored in that .mdf file?
13 votes
4 answers
51k 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 ...
1 vote
1 answer
510 views

How can I monitor the import progress of a large CSV File in mysql?

I am trying to import an existing CSV file into my database and I want to see the progress. I usually use pipe viewer when I do my sql files but for csv files I cannot figure out how to do it. I use ...
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 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 ...
5 votes
3 answers
4k views

how to install mysql on mac?

My Mac runs Mac OS X, version 10.7.5., so it's a 64 bit system. First, I downloaded mysql-5.5.28-osx10.6-x86_64.dmg. Then I double clicked mysql-5.5.28-osx10.6-x86_64.dmg, it's mounted, and shows ...
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 … $ ...
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 ...
1 vote
1 answer
3k views

How to connect to a Postgres server in a Docker (1.12.0) container on a Mac?

The latest release of Docker doesn't use a virtual machine anymore, instead using a hypervisor to connect to the containers. This means I can no longer login to postgres with psql: ➜ postgres git:(...
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 ...
0 votes
1 answer
2k views

postgres: could not find the database system

If I try to run the postgres command, I get: 2020-12-29 00:14:53.213 GMT [34374] LOG: skipping missing configuration file "/usr/local/pgsql/data/postgresql.auto.conf" postgres: could not ...
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.
0 votes
2 answers
1k views

Oracle database for learning purposes

I would like to know if I can download Oracle Database on my Mac OS X and use it for learning purposes? I know that Oracle Database Express Edition 11g is free, but is it free for OS X?
2 votes
1 answer
3k views

How to start PostgreSQL 12.4 [OSX]

I am not from a PostgreSQL background and wanted to use it for a project I am currently working on as it was the recommended DB for what I am using. I use PgAdmin 4 to visualise the database, and my ...
1 vote
1 answer
444 views

Non-programmer using Sequel Ace, how to resolve "Out of sort memory, consider increasing server sort buffer size" error?

I don't know MySQL but I wanted to glance through some data in a table. I imported the database into Sequel Ace (MacOS) and had no trouble browsing through the tables, but when attempting to sort one ...
1 vote
2 answers
911 views

Alternative to SQL Server Management Studio and Azure Data Studio to initially change my password

Background I'm having to connect to a customer's Microsoft SQL Server. I generally don't need to do much in databases besides your average SQL, so using the database features in IntelliJ IDEA have so ...
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 ...
-1 votes
1 answer
3k views

Problems with remote ssh access to mysql with Workbench MacOS

I am having problems connecting Workbench with Siteground. All my connection settings are as instructed, however my question is do I have to open port 3306 on my Mac to connect to the Siteground ...
13 votes
3 answers
20k 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, ...
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 ...
0 votes
1 answer
8k views

How do I locate my Postgres data directory while the server is down?

I'm on Mac 10.13.6. I restarted my machine and Postgres, which normally starts upon restart, wasn't running. Sadly, I cannot remember how or where I installed it. I'm able to locate instances of "...
0 votes
1 answer
1k views

PostgreSQL crashes during count row query

Currently I have only two tables - small one that works fine and another presumably large one. When I try to find out row count in pgAdmin I get the following error: The application has lost the ...
2 votes
2 answers
6k views

Queries on large database kill connection to the server, works with LIMIT

I'm trying to run queries on a large-ish database without killing the connection to the server. I'm using Postgres 12.1 on a mac with 16gb of memory, and about 40gb of free disk. The database is ...
0 votes
1 answer
5k views

Open pgAdmin4 server on a Mac

I had pgAdmin4-3.6 installed on my Mac. Worked as it should. And there was created a shortcut at installation to open the pgAdmin server. Installing version pgAdmin4-4.6 there was no shortcut ...
-1 votes
1 answer
1k views

Problems running Postgres "createuser" command

I'm trying to run the createuser command on an MacOS 10.15 installation of Postgres 11.6. I have enabled root but there is no postgres user to su as - there's a _postgres user instead: dd@finglas:~ $ ...
10 votes
5 answers
27k 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 ...
-1 votes
1 answer
616 views

Cannot change collation on my MySQL database for all tables - please help

I have MAMP installed on my Macbook, I open up phpMyAdmin and go to Operations, I choose the Collation that I need to use for my WordPress site. I then click "GO", but when I run the following query ...
12 votes
3 answers
36k 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 ...
1 vote
5 answers
20k views

mongoimport error - Failed: error connecting to db server: no reachable servers

I am currently trying to learn MongoDB and I am having trouble finding a solution for this problem. When I run a mongoimport command it I get the following error: ~ mongoimport --host localhost --...
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 ...
0 votes
0 answers
503 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 ...
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-...
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/...
1 vote
1 answer
2k views

(macOS/Docker) "Cannot bulk load. The file path does not exist or you don't have file access rights."

I am running SQL Server from a Docker container on macOS. All queries except for the loading of the csv file is getting executed. The column names etc are correct. Any ideas? error: Cannot bulk ...
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 ...
6 votes
3 answers
26k views

MySQL on MACOS Sierra secure-file-priv setting

I cannot find where to set secure-file-priv. I get this message: 1290 - The MySQL server is running with the --secure-file-priv option so it cannot execute this statement when running this ...