Hello,

What is the best way to install PostgreSQL on Mac OS X 10.5.1?
Or, perhaps I should ask is there a preferred way to PostgreSQL on Mac OS X?

Is a disk image installer fine? Or, is it better to compile all the components?

Is this installation perfectly fine?
http://www.kyngchaos.com/wiki/softwareostgres
PostGIS recommends Kyngesburye: http://www.postgis.org/download/
They also refer to Fink.

Pat Maddox's blog recommends this approach:
<http://evang.eli.st/blog/2007/10/28/installing-postgres-8-2-on-leopard-includes-system-account>

Apple recommends Fink:
http://developer.apple.com/internet/.../postgres.html

The 'Robby on Rails' blog recommends MacPorts:
<http://www.robbyonrails.com/articles/2007/06/19/installing-ruby-on-rails-and-postgresql-on-os-x-second-edition>

Here's another installation (this is out-of-date):
http://www.psyex.com/techdocs/pgonx.html

Is there a clear "answer" for installation? Is the answer, "it
depends?" Does all of this also apply to a Mac OS X 10.4.x machine?

Should I just use the single click DMG from Kyngesburye and
optionally install PostGIS? That looks like the easiest approach. Or,
Should I use MacPorts or Fink?

Thanks and happy holidays,
Chuck

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On 22 dec 2007, at 06.56, Chuck wrote:
> What is the best way to install PostgreSQL on Mac OS X 10.5.1?
> Or, perhaps I should ask is there a preferred way to PostgreSQL on
> Mac OS X?
>
> Is a disk image installer fine? Or, is it better to compile all the
> components?

I've always installed from source and I've never been sorry. Haven't
tried it on Leopard yet though. There's no reason to believe that the
various binary installers should be worse than a source install, but
since I've never tried them I really can't tell.

Compiling from source is a good way to get to know both your OS and
Postgres better.


Sincerely,

Niklas Johansson





---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Chuck wrote:
> Hello,
>
> What is the best way to install PostgreSQL on Mac OS X 10.5.1?
> Or, perhaps I should ask is there a preferred way to PostgreSQL on Mac
> OS X?

Well I can't say this (or any other) is a 'preferred' way, but you might
want to try the EnterpriseDB Postgres installer if you're will to run
8.3 beta until the full release:

http://postgres.enterprisedb.com/download.do

It works pretty well even if (as the author) I do say so myself :-)

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

At 11:03 AM +0000 12/22/07, Dave Page wrote:
>Chuck wrote:
>>Hello,
>>
>>What is the best way to install PostgreSQL on Mac OS X 10.5.1?
>>Or, perhaps I should ask is there a preferred way to PostgreSQL on Mac OS X?
>
>Well I can't say this (or any other) is a 'preferred' way, but you
>might want to try the EnterpriseDB Postgres installer if you're will
>to run 8.3 beta until the full release:
>
>http://postgres.enterprisedb.com/download.do
>
>It works pretty well even if (as the author) I do say so myself :-)
>
>Regards, Dave

Dave,

Thanks. If I take this approach will it be straightforward to upgrade
from one beta to the next (assuming that there will be more betas)
then to upgrade to the release version? Will I be able to use the
EnterpriseDB Postgres installer for the release version?

I'm initially using Postgres for Mingle (with less than 5 users).
http://studios.thoughtworks.com/
Later, I expect to make use of PostGIS.

Chuck

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly