Questions tagged [mac-os-x]
An operating system published by Apple.
162 questions
0
votes
0
answers
277
views
Unable to connect to server connection failed: connection to server at 127.0,0,1 post 5432 failed could not receive data from server
I installed PgAdmin 4 to my MacBook Pro Sonoma version 14.4.x and once it opened I attempted to create a server or register a server and I have host name/address as localhost, port 5432, maintenance ...
- 281
0
votes
1
answer
88
views
PostgreSQL setup issue on macOS Monterey: initdb error encoding mismatch
I'm having issue while installing PostgreSQL 16 on macOS Monterey via MacPorts.
So far, these looked OK:
$ sudo port install postgresql16-server
---> Computing dependencies for postgresql16-server
...
- 103
0
votes
0
answers
160
views
Upgrading database instance for MongoDB 4.2 to 4.4 requires legacy MongoDB on Macosx
I'm running MongoDB within a ten year old node app, and in the process of upgrading node had to upgrade MongoDB. For some time, I have been using MongoDB community 4.4 to run the database, but in the ...
- 101
5
votes
3
answers
2k
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 ...
- 151
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
2
votes
0
answers
334
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
1
vote
0
answers
1k
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 …
$ ...
- 753
0
votes
0
answers
1k
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
1
vote
1
answer
7k
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
0
votes
1
answer
3k
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 ...
- 111
2
votes
1
answer
4k
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 ...
- 131
1
vote
1
answer
650
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 ...
- 13
1
vote
2
answers
1k
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 ...
1
vote
1
answer
656
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 ...
- 11
-1
votes
1
answer
4k
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 ...
