Tutorial: Installing & Running Postgres on Mac OS X

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

  1. macrumors regular

    Joined:
    Aug 29, 2002
    Messages:
    179
    #1
  2. macrumors 68040

    iSee

    Joined:
    Oct 25, 2004
    Messages:
    3,325
    #2
    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).
     
  3. macrumors demi-god

    Nugget

    Joined:
    Nov 24, 2002
    Messages:
    1,369
    Location:
    Houston Texas USA
    #3
    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. macrumors 68000

    Joined:
    Feb 23, 2006
    Messages:
    1,642
    #4
    Why are you installing this in ~/Applications? Why don't we just follow the standard install procedure?
     
  5. macrumors G4

    Joined:
    Jan 5, 2006
    Messages:
    11,012
    Location:
    Redondo Beach, California
    #5
    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. macrumors regular

    Joined:
    Aug 29, 2002
    Messages:
    179
    #6
    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. macrumors 68000

    Joined:
    Feb 23, 2006
    Messages:
    1,642
    #7
    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