Tutorial: Installing & Running Postgres on Mac OS X

Discussion in 'Mac Programming' started by will, Nov 20, 2007.

  1. will macrumors regular

    Aug 29, 2002
  2. iSee macrumors 68040


    Oct 25, 2004
    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).
  3. Nugget macrumors 65816


    Nov 24, 2002
    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.
  4. SC68Cal macrumors 68000

    Feb 23, 2006
    Why are you installing this in ~/Applications? Why don't we just follow the standard install procedure?
  5. ChrisA macrumors G4

    Jan 5, 2006
    Redondo Beach, California
    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.
  6. will thread starter macrumors regular

    Aug 29, 2002
    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.
  7. SC68Cal macrumors 68000

    Feb 23, 2006
    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.

Share This Page