All Questions
162 questions
0 votes
0 answers
244 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
61 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
130 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
316 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
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 ...
- 131
1 vote
1 answer
628 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
631 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 ...
