Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [macos]

30 questions
7
votes
2 answers

Is there a way to use standard CLR functions on Azure SQL Edge for Ubuntu Docker on an M1 Mac?

I have a MacBook with an M1 chip, so (about) the only option for me to run SQL Server is to run it as a Docker container. This works fine for standard SQL, but our application uses some CLR features like COMPRESS; when I try to use that, it tells…
Glorfindel
  • 2,205
  • 5
  • 19
  • 26
4
votes
1 answer

Brew Upgrade Mysql: sdi_delete failed: Record Doesn't exist: tablespace_id: 1 Key: 1 4049

I ran the following commands from the cli in MacOS Monterey V 12.4: brew update brew upgrade Upon doing so, MySQL was upgraded from 8.0.30 to 8.0.31. MySQL was running in the background during the upgrade. MySql would not restart, so I rebooted…
Derrick
  • 141
  • 2
3
votes
0 answers

Unable to Install PostGIS Extension for PostgreSQL 15 on Mac Book with M1 Chip and macOS Ventura 13.3.1

Issue: Unable to install PostGIS extension for PostgreSQL 15 on Mac Book with M1 chip and macOS Ventura 13.3.1. Steps I have taken: Installed PostgreSQL 15 using the terminal. Installed PostGIS using the command brew install postgis. Tried…
Ravers UA
  • 31
  • 1
3
votes
0 answers

How to open pgAdmin 4 v6.0 in browser instead of running as a desktop app

It looks like PgAdmin 4 v5.4+ (I have v6) works as a standalone desktop app and the option to open in a browser window is not there by default. I am using macOS Big Sur. How can I open PgAdmin UI in browser?
Eranga Heshan
  • 133
  • 2
  • 9
3
votes
1 answer

Server quit without updating PID file when trying to start MySQL server?

So I created my .bash_profile, opened it in a text editor and added: export PATH=$PATH:/usr/local/mysql/bin and then I saved it. Next, I tried running sudo /usr/local/mysql/support-files/mysql.server start was told to enter my password (so I did),…
nickcoding
  • 83
  • 1
  • 1
  • 7
2
votes
2 answers

Disable auto-start of postgres server on boot (Mac)

Running a Mac. I installed Postgresql 9 many years ago and configured it to auto-start. Now I have upgraded to version 12 using brew, but on system restart version 9 server is still starting automatically. I don't know how to determine what is…
David
  • 165
  • 1
  • 5
2
votes
0 answers

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/bin/pg_ctl -D /usr/local/var/postgres start I…
Harshit Trivedi
  • 121
  • 3
2
votes
1 answer

Postgres server is not starting

I have installed postgres 11 earlier on my MacBook Pro. Suddenly it stopped working. Usually I start my postgres server by following command pg_ctl -D /usr/local/var/postgres start and it returning the following error dyld: Library not loaded:…
Devil's Dream
  • 123
  • 2
  • 6
1
vote
1 answer

Collation difference in PostgreSQL on AWS RDS and local machine

I have an issue with collation in PostgreSQL when sorting a result set. We use AWS RDS PostgreSQL, and we want to sort query results in a specific way. Locally, everything works perfectly on my laptop (macOS), and all tests are passing. However,…
Taras
  • 119
  • 2
1
vote
2 answers

Migrating MySQL databases to a new server with phpMyAdmin

Looking for the best way to migrate a dozen or so MySQL databases from an old Mac mini to a new one. I've tried the source machine's phpMyAdmin (v. 4) EXPORT command, using what looked like reasonable options, and with all my existing databases…
Rob Lewis
  • 111
  • 3
1
vote
0 answers

Postgres reopens closed processes on Mac. How to solve?

I tried to terminate Postgres on Mac in various ways. I used commands in the terminal: pg_ctl -D /usr/local/var/postgres stop , brew services stop postgresql , systemctl stop postgres . Did not work. The kill -9 command I didn't try, because I read…
Senhor Filipe
  • 11
  • 3
1
vote
1 answer

MySQL Plugin "mysql_old_password" not loaded

In an attempt to fix another issue I had, I ran the commands below (as per https://dev.mysql.com/doc/refman/5.6/en/old-client.html) mysql> UPDATE mysql.user SET plugin = 'mysql_old_password' mysql> WHERE User = 'root' AND Host = 'localhost'; mysql>…
The Royal Guardian
  • 31
  • 5
1
vote
1 answer

Postgres CREATE DATABASE Not Working

I'm on a Mac using Monterey. It's a Mac M1 which had a bit of an issue using homebrew to install postgres when I first started working on this machine. I moved to the GUI postgres.app which just seemed like a front for the underlying postgres, so…
Rich_F
  • 131
  • 1
  • 10
1
vote
1 answer

Postresql Client and Version Mismatch

Given: $which psql /Library/PostgreSQL/12/bin/psql $which createdb /Library/PostgreSQL/12/bin/createdb Recently I created a database: $createdb -U postgres postgres Password: However, I don't understand why the server version varies from the…
Kevin Meredith
  • 559
  • 1
  • 7
  • 14
0
votes
0 answers

Error creating PolarDB standby node on macOS

I am trying to set up a standby disaster recovery node for PolarDB on a macOS host using Docker. However, I am encountering an issue during the polar_basebackup process where it fails to create necessary directories. The error suggests that the…
nan bai
  • 1
1
2