Questions tagged [mac-os-x]
An operating system published by Apple.
161
questions
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"?...
- 2,061
2
votes
1
answer
112
views
Purge mysql and it's configuration completely from MAC.
I, by mistake messed up with mysql's only user and the situation is I can't create new user or give more privileges to existing one. Access denied is the error. Only visible db is info Schema So I ...
user3693546
1
vote
1
answer
3k
views
mysqldump drop create use case sensitivity
Dumped sql from MySQL is showing inconsistencies in the name of the database.
Using the following bog standard method to dump a database:
mysqldump --add-drop-database -u someuser --databases Geo-...
- 113
0
votes
1
answer
324
views
installing mysql 5.1 alongside mysql 5.5
mysql 5.5 is installed. I need 5.1 to install an old website so it can be updated. The installer refuses to let me install onto the disk with 5.5. I don't have any other disks. I downloaded the ...
- 3
2
votes
2
answers
2k
views
Issue when connecting to open shift via mysql workbench on Mac
I am trying to connect to open shift with mysql workbench on an iMac. A colleague has shown me his setup on Windows which looks exactly as follows (other than the usernames / passwords changing)
...
- 121
0
votes
1
answer
135
views
Error when building documentation of Postgres [closed]
I am trying to build the documentation of Postgres on OSX
After getting the source, installing node and jade, I do:
cd /doc/src/sgml
make html
This results in the error:
fs.js:684
return ...
- 6,198
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 ...
- 175
0
votes
2
answers
4k
views
pgAdmin on a fresh OS X Server installation
I know for sure postgresql is running (checked with ps ax), but when I install pgAdmin and try to make a server connection to localhost I get this error:
Server doesn't listen
The server doesn't ...
- 143
27
votes
1
answer
9k
views
Is there a psql equivalent of bash's reverse-search-history?
I am very fond of bash's reverse-search-history (C-r) (command-line feature):
Search backward starting at the current line and moving ‘up’ through the history as necessary. This is an incremental ...
- 1,809
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.
user33664
6
votes
3
answers
13k
views
Postgresql Database on external HD
My laptop has a small hard drive. I want to load a big data set. I have moved the entire /usr/local/var/postgres to the external hd, and symlinked it back. Now I'm getting this error,
psql: could ...
- 69
2
votes
1
answer
213
views
What does 'Vacuum' do in Menial's Base 2 application?
I've had a look at the help documentation for Base 2, as well as Menial's product page, but haven't found an answer there. I've even clicked on the vacuum button and not noticed any change. What does ...
- 249
1
vote
1
answer
2k
views
Connecting to a MySQL database on Mac from a VMWare fusion Virtual Machine
I have MariaDB (5.5.34-MariaDB) installed on a Mac (OS 10.8.5) I can connect to the database fine locally (127.0.0.1) on port 3306. But when I try to connect to the database from windows 7 64bit ...
- 23
4
votes
1
answer
3k
views
What PL/pgSQL debugger can I use?
I'm building a lot of PL/pgSQL functions and a debugger would really come in handy because RAISE NOTICE is not enough.
I read about a pgAdmin plugin you can install but it was only on Windows and I'm ...
- 351
1
vote
0
answers
470
views
MySQL database problems all of a sudden-- users' programs can't connect, I saw error 2013, error 32
I am editing my problem, based on what I've researched and done:
Hi
This is mysql running on an osx server.
We suddenly have an issue where only one of anything can seem to connect to mysql at ...
- 11
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 -...
- 111
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 ...
- 231
0
votes
1
answer
2k
views
Connecting to remote oracle db
I am very new to system and db admin stuffs. Infact, I need to have my skills more improved in those areas. Anyways, I was trying to connect to a remote oracle database and use php oci8 library to ...
- 101
2
votes
1
answer
328
views
Why does PostgreSQL require its own user/group for installation?
When installing PostgreSQL via MacPorts (and I assume via other means too), a postgres:postgres user/group is created. Are there any reasons why this user/group is needed?
- 123
1
vote
1
answer
10k
views
"SQL1042C An unexpected system error" when creating a database
I installed DB2 Express-C 10.1 on OS X 10.8.4. I installed it in user mode, and it seems to have created an instance with my username (avernet). I checked the instance is indeed there by running ...
- 141
2
votes
0
answers
366
views
Remove Mac OSX Lion pre-installation of PostgreSQL
I'm running Lion 10.7.5, and I'm trying to install Postgresql 9.2.4 for use with Django. I have hit countless roadblocks and errors, so I would like to start with a totally clean slate.
I did a brew ...
- 121
5
votes
2
answers
3k
views
MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3 [closed]
I upgraded my installation of MySQL on my Mac OS X 10.8.3 using homebrew
brew install mysql
Everything seemed to go smoothly, but...not really, as it turns out.
I cannot add a new user (neither ...
- 171
0
votes
1
answer
88
views
Creating database/tables in SequelPro (or MySQL) from External FTP Server
I just started getting a backup file (*.7z) from the folks that run our database once a week. They're sending it to me through an FTP server (I use FileZilla) -- but the file is pretty huge: 5.8 ...
- 175
7
votes
2
answers
7k
views
Seeting up a PostgreSQL database on another hard drive than my system one on OS X?
I am on OS X 10.8.3, I've install PostgreSQL from macports, but I've realized that I have not enough space on my system drive for the DB I am about to populate with data.
Is there a way to create new ...
- 173
2
votes
2
answers
3k
views
PostgreSQL datasource URL?
My first attempt to use PostgreSQL:
I have the elephant icon on the top right: running on port 5432.
I want to use LibreOffice as an interface:
Connect to an existing database: PostgreSQL
...
- 589
2
votes
4
answers
5k
views
Why would SequelPro only import 23k rows out of 130k?
I use SequelPro for MySQL on a Mac OS X. I used the import function to upload a 130k .csv file to my database. Everything seems to work fine, then I get the message:
File Read Error: An error ...
- 175
1
vote
0
answers
2k
views
System Preferences quits unexpectedly due to MySQL plug-in
I've installed MySQL Preference Pane on my MacBook to start/stop MySQL from my System Preferences and it works ok, except that once in a while System Preferences just quits and shows this message:
...
- 171
3
votes
1
answer
4k
views
PostgreSQL CREATE EXTENSION file not found error on Mac OS
On PostgreSQL 9.2.3 when trying this:
CREATE EXTENSION btree_gist;
I get this error:
ERROR: could not open extension control file "/opt/local/share/postgresql92/extension/btree_gist.control": No ...
- 885
1
vote
2
answers
683
views
MySQL5.6 on Mac OS X 10.6.8 problems when granting permissions to root
I'm having serious problems with a MySQL 5.6 instance on a Mac Server.
We had to upgrade MySQL to a newer version, but it turned to be a bad idea, as we lost control to it. We had a backup of the /...
- 165
2
votes
0
answers
3k
views
"custom archiver out of memory" error when restoring large DB using pg_restore
I'm trying to a restore a local copy of a 30GB DB (with only one table) dumped using the Heroku wrappers (described here) using pg_restore. The Heroku DB is using 9.1.7 and I have had the same result ...
- 345
2
votes
1
answer
2k
views
Is it okay to have different lower_case_table_names value on master and slave?
I have a OSX MySQL master with lower_case_table_names set to 2. I have just setup a Linux MySQL slave with lower_case_table_names=1.
I haven't started replication on the slave, but everything looks ...
- 611
2
votes
1
answer
4k
views
Connecting to Oracle SQL Developer locally on Mac?
I'm trying to connect to Oracle SQL Developer locally on my Mac. How exactly is this done? I've looked all over the network, and can't find anything helpful.
The only thing I did is installing the ...
- 133
1
vote
1
answer
6k
views
MySQL General log not working on Mac OS X [duplicate]
I want to log all queries to the database running on my MacBook Pro (Mac OS X 10.8.1). I created a file /etc/my.cnf with the following content:
[mysqld]
general_log=1
general_log_file=/Users/wdb/...
- 235
0
votes
1
answer
2k
views
Permission Denied Copy [closed]
I am a beginner learning how to load data and I can't figure out why I can't load this data into postgres. I am using postgres 8.4 on MAC OS.
copy tname from '/Users/Shared/folder/file.cxv' ...
6
votes
1
answer
7k
views
Backup a database with a huge number of tables
Is there a way to backup a PostgreSQL database with a huge number of tables?
An attempt with pg_dump for a database of about 28000 tables resulted in the following error message:
pg_dump: WARNING: ...
- 361
1
vote
1
answer
173
views
MySQL 5 on Mac 10.5: "problem connecting to the database"
I have worked with MySQL for years but I am stuck on a seemingly trivial problem.
I installed MySQL 5.0.96 on Mac 10.5, created a database, created a user with privileges on everything, and problem:
...
- 319
1
vote
3
answers
8k
views
Is there a free software that can import excel into mysql on mac? [closed]
not csv format files, but .xls or .xlsx format excel files, is there any free software for mac, that can import data into mysql?
- 163
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
...
- 163
0
votes
1
answer
1k
views
What's included in the default OSX 10.8 install of Postgres?
I've seen several sites claim that Postgres is installed by default for OSX 10.7 and above and I see there's a psql command in /usr/bin/, but there doesn't seem to be a pg_ctl anywhere.
So is the ...
- 103
0
votes
1
answer
87
views
Move databases on same Mac
I have just updated my MacBook to Mountain Lion. Since then, my MAMP installation does not work properly so I decided to use the build httpd/php stuff. For this, I have additionally installed a new ...
- 185
5
votes
4
answers
15k
views
What GUI tools can be used for PostgreSQL in Mac OS X? [closed]
I have recently started using PostgreSQL with my rails app.
I was looking for a SQL GUI to the PostgreSQL database (for Mac).
Anything better than pgadmin3?
- 223
0
votes
1
answer
2k
views
How to create a new instance of PostgresSQL on OS-X 10.8 Server
After upgrading my MacMini home server from OS-X 10.7 (Lion) Server to OS-X 10.8 (ML) + Server.app, I saw PostgreSQL 9.1.4 was released.
Unfortunately, the setup process for PostgreSQL 9.1.4 has ...
- 103
34
votes
14
answers
158k
views
PostgreSQL is running locally but I cannot connect. Why?
Recently updated my machine from Mac OS X Lion (10.7.4) to Mountain Lion (10.8) and I think it borked my PostgreSQL installation. It was installed originally via Homebrew. I'm not a DBA, but hoping ...
- 777
1
vote
1
answer
3k
views
Install db2 express c on Mac OSX
I have posted the question yesterday, then I was able to figure it out by myself. As I haven't found any complete guide, I'm writing down the steps just in case.
So the question is: "How do I ...
- 141
1
vote
1
answer
326
views
db2 express c mac osx
I'm experiencing some troubles with the execution of DB2 express c on Mac OSX 10.6 Snow Leopard.
I have installed the db system, creating two users, db2 and db2-user. The latter is the instance ...
- 141
3
votes
1
answer
13k
views
How to properly stop MySQL server on Mac OS X?
I installed MySQL Community Server following instructions at
http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html
with the Startup Item and the MySQL Preference Pane.
I can stop the ...
- 3,457
4
votes
2
answers
3k
views
DB2 Express-C on Mac OS X
I have followed all the steps described on the Getting Started with DB2 Express v9.7 e-book and installed DB2 Express-C on my Mac. The installation succeeded without a problem.
I did setup OS X ...
- 2,323
2
votes
2
answers
1k
views
MySQL performance on Mac vs Linux
I know that MySQL is tested more on Linux (Oracle has it's own linux distribution and you canot have LAMP wit MySQL (meaning MySQL has always focused more on Linux)
My intuition says that MySQL has a ...
- 1,757
2
votes
1
answer
1k
views
SQL on Mac OS X
I'm looking for something like "Oracle database express" to be used on a mac.
I hope this question won't offend anyone though.
I'm absolute beginner on sql.
Your suggestions are most welcome.
- 121
3
votes
3
answers
18k
views
How to initiate MySQL on Mac OS X 10.6.8?
I followed this tutorial to install MySQL on Mac OS X 10.6.8. Now I get he following errors:
$ mysqladmin version
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can'...
- 3,457