Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Reply
 
Thread Tools Search this Thread Display Modes
Old Nov 20, 2007, 01:33 PM   #1
will
macrumors regular
 
Join Date: Aug 2002
Tutorial: Installing & Running Postgres on Mac OS X

I have created a quick tutorial on installing and running Postgres on Mac OS X:
http://flux.org.uk/howto/postgres/macosx

Comments and suggestions welcome.
will is offline   0 Reply With Quote
Old Nov 20, 2007, 02:34 PM   #2
iSee
macrumors 68040
 
iSee's Avatar
 
Join Date: Oct 2004
Nice!
I've been meaning to look into it, just out of curiosity.
I guess I've got a good excuse now.
I'll see if I can give it a try this week some time (on Leopard 10.5.1).
iSee is offline   0 Reply With Quote
Old Nov 20, 2007, 02:36 PM   #3
Nugget
macrumors Demi-God
 
Nugget's Avatar
 
Join Date: Nov 2002
Location: Houston Texas USA
PostgreSQL is such an excellent database. I honestly do not understand why any developer would choose to use MySQL. PostgreSQL is better and free-er.
__________________
I'm a geek. I have a bunch of Macs. I drank the Kool-Aid. I like cars, airplanes, music, and coding.
Nugget is offline   0 Reply With Quote
Old Nov 20, 2007, 05:57 PM   #4
SC68Cal
macrumors 68000
 
Join Date: Feb 2006
Why are you installing this in ~/Applications? Why don't we just follow the standard install procedure?

Last edited by SC68Cal; Nov 20, 2007 at 06:19 PM.
SC68Cal is offline   0 Reply With Quote
Old Nov 21, 2007, 02:44 AM   #5
ChrisA
macrumors G4
 
Join Date: Jan 2006
Location: Redondo Beach, California
Quote:
Originally Posted by Nugget View Post
PostgreSQL is such an excellent database. I honestly do not understand why any developer would choose to use MySQL. PostgreSQL is better and free-er.
I've used both. Once I really wanted to use PostgreSQL but we prototyped using each DBMS and fond for our simple application MySQL outperformed PstgreSQL by a factor of more then ten. Basically we were just using a DBMS table as a queue. One writer and mutliple readers. We had a real time application that needed to store snapshots of the current state and there were about 10 readers who woud periodically read out subsets of the data to drive their "real time-ish" displays. we had tens of millions of records per hour.

In our tests, MySQL did the job but as you added more users (readers) PostgreSQL would eventually catch up. It seems postgres was smarter about how it handles locks and multiple readers can share a lock while MySQL did very course grain locking forcing user to wait for locks. It was simpler so it was faster for a low number of users we had.
ChrisA is offline   0 Reply With Quote
Old Nov 21, 2007, 03:50 AM   #6
will
Thread Starter
macrumors regular
 
Join Date: Aug 2002
Quote:
Originally Posted by SC68Cal View Post
Why are you installing this in ~/Applications? Why don't we just follow the standard install procedure?
I chose to show how to install there so that all users, even those without root, could install it. I do plan to add info on an install under /usr.
will is offline   0 Reply With Quote
Old Nov 21, 2007, 02:51 PM   #7
SC68Cal
macrumors 68000
 
Join Date: Feb 2006
Quote:
Originally Posted by will View Post
I chose to show how to install there so that all users, even those without root, could install it. I do plan to add info on an install under /usr.
Doesn't it install there by default? I'd just toss it there since it's usually run as a daemon anyway. It's a good idea because then it'll also be protected by root ownership and permissions.

I just start to get antsy when someone installs a major system component like that in a non-traditional area because it can cause problems down the line as an administrator.
SC68Cal is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Build NAS for Mac Machines Using PC Components & Running FreeNAS SharkGirl Mac Peripherals 7 Jan 17, 2014 07:37 PM
iPhone: tutorial on installing winterboard themes downloaded from the internet s2smooth4u Jailbreaks and iOS Hacks 5 Mar 6, 2013 08:41 AM
Any interest in a tutorial for installing 10.6.x on a Mac Pro 2012? monkeybagel Mac Pro 10 Jan 3, 2013 08:15 AM
Tutorial & Roundup: Stretching videos so that they entirely fill the screen Menneisyys2 iPad Apps 0 Dec 18, 2012 05:22 PM
Installing Windows & Parallels on Mac SamTheWheel Windows, Linux & Others on the Mac 0 Jul 6, 2012 04:02 PM

Forum Jump

All times are GMT -5. The time now is 06:18 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC