2022 Developer Survey is open! Take survey.

Questions tagged [mac-os-x]

An operating system published by Apple.

Filter by
Sorted by
Tagged with
2 votes
0 answers
16 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 ...
user avatar
  • 21
0 votes
0 answers
92 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 … $ ...
user avatar
  • 585
0 votes
0 answers
128 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 ...
user avatar
  • 11
0 votes
0 answers
21 views

Nothing happens after backup job is created

I'm running postgreSQL 9.6/Pgadmin4 on a macOS and I'm trying to backup a database in pgadmin4 by : Right click on the DB Backup Once the backup job is created nothing happens afterwards and the ...
user avatar
0 votes
1 answer
351 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 ...
user avatar
0 votes
1 answer
538 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 ...
user avatar
  • 111
2 votes
1 answer
1k 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 ...
user avatar
  • 121
1 vote
1 answer
203 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 ...
user avatar
  • 13
1 vote
2 answers
597 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 ...
user avatar
0 votes
1 answer
256 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 ...
user avatar
-1 votes
1 answer
2k 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 ...
user avatar
0 votes
1 answer
3k 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 "...
user avatar
  • 585
0 votes
1 answer
715 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 ...
user avatar
0 votes
0 answers
2k views

postgreSQL: FATAL: password authentication failed for user

Trying to connect to postgresql on MAC OS (psql -U postgres) , I receive: FATAL: password authentication failed for user "postgres" And I cant change password. In pg_hba.conf: local all ...
user avatar
  • 101
1 vote
2 answers
2k 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 ...
user avatar
-1 votes
1 answer
169 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:~ $ ...
user avatar
  • 101
2 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....
user avatar
1 vote
1 answer
759 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 ...
user avatar
  • 11
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 ...
user avatar
  • 109
0 votes
0 answers
308 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 ...
user avatar
0 votes
0 answers
665 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-...
user avatar
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/...
user avatar
0 votes
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 ...
user avatar
  • 131
0 votes
1 answer
201 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 ...
user avatar
  • 1
0 votes
1 answer
4k 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 ...
user avatar
  • 156
0 votes
2 answers
995 views

Load big file in MySQL table

I've read some posts related to issues similar to this, but without success, so I'm trying to post my specific problem. I have to load a big CSV file (25Gb) into a MySQL table. I'm doing this with ...
user avatar
  • 113
2 votes
0 answers
1k 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 ...
user avatar
  • 121
-1 votes
1 answer
181 views

Error when getting in to MYSQL from terminal [closed]

I get this error message: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) when i try to enter mysql from terminal (Macos).
user avatar
  • 1
1 vote
1 answer
4k 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?
user avatar
  • 113
4 votes
2 answers
15k views

Homebrew MariaDB Server Start Error with 'mysql.server start'

When starting MariaDB 10.3.8 on MacOS 10.13.6 the following strange behavior occurs: mac:~user$ mysql.server start Starting MariaDB .180813 17:50:11 mysqld_safe Logging to '/usr/local/var/mysql/mbp....
user avatar
  • 145
4 votes
1 answer
46k views

Getting Failed (exit code: 1). when running restore DB from a .tar file in pgAdmin4 postgresql 10.5 [closed]

I'm taking an intro to SQL course and I can't get my very first database loaded. I have a file dvdrental.tar, I create a new database dvdrental > right click > Restore > Select File > Pick "Data" ...
user avatar
  • 161
2 votes
1 answer
919 views

error connecting to master 'replica@192.168.57.10: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 ...
user avatar
  • 41
0 votes
1 answer
628 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 ...
user avatar
1 vote
1 answer
12k views

MySQL 8.0, MacOS, create database issue?

when I use: CREATE DATABASE test; ERROR 3680 (HY000): Failed to create schema directory 'test' (errno: 2 - No such file or directory)
user avatar
3 votes
1 answer
3k 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 ...
user avatar
  • 105
38 votes
3 answers
44k 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 ...
user avatar
1 vote
1 answer
427 views

Quitting PostgreSQL from mac terminal

When I use terminal, enter my database and then quit by using \q I can not get to the following line in order for example to enter my other database (see below). The cursor is stuck without having the ...
user avatar
  • 11
2 votes
1 answer
340 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 ...
user avatar
45 votes
4 answers
37k 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 ...
user avatar
  • 553
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 ...
user avatar
  • 111
4 votes
1 answer
21k views

no pg_hba.conf entry for host "[local]", user "pgadmin", database "postgres", SSL off on OSX

local all postgres trust host all all 0.0.0.0/0 trust hostnossl all all 0.0.0.0/0 trust I would think either the second or the third would match these criteria. I've ...
user avatar
1 vote
0 answers
846 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 ...
user avatar
  • 111
12 votes
3 answers
28k 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 ...
user avatar
  • 173
0 votes
1 answer
5k views

pgAdmin 4 - Can't Create Script on a database [closed]

When I try to CREATE Script on a database I want to use, there is no CREATE Script item in the context menu. But CREATE Script looks fine on another database. I can select it and it works fine. ...
user avatar
7 votes
2 answers
10k 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 ...
user avatar
3 votes
1 answer
11k views

Can't open the mysql.plugin table error when installing MySQL on Mac OS Sierra

I am attempting to install MySQL on macOS Sierra 10.12.5. I had a previous (non-functioning) install of MySQL so I followed the steps here to install a clean copy with Homebrew. I had to create a var/...
user avatar
  • 145
1 vote
1 answer
2k views

Share the database between vmware guest and host

I wanna Access the MySQL Database founded in Windows 10 from VMware Workstation MAC OS X guest and give the guest ( MAC in VMware ) only permissions to just one database from the host (Windows 10), I ...
user avatar
1 vote
0 answers
3k 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 .....
user avatar
  • 585
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 ...
user avatar
0 votes
1 answer
386 views

What's causing my postgresql database to freeze? [duplicate]

This is my current setup on my home laptop: OSX El Capitan. Installed postgresql 9.6 via postgres.app. Symlinked the database files to an external HD (connected via USB). Inserting data via the ...
user avatar
  • 111