Location to install PostgreSQL database

Hi All

I would like to know the various places developers install a PostgreSQL database, if it is separatly installed, i. e. not the default install location of the Servoy Developer installation process. And, of course, I would like to know the reason for the choosen install location for the database :-)

The question is for the Mac OS X Server operating system.

Thanks and regards,

Hi Robert,

As you might know I use the EnterpriseDB installer for PostgreSQL. And this installer installs PostgreSQL according to the Apple guidelines namely in /Library/PostgreSQL/x.y/ where x.y is the version number.
There are/were also installers who use more a UNIX guideline and install in /usr/local or in /opt.

Does this answer your question ?

ROCLASI:
Hi Robert,

As you might know I use the EnterpriseDB installer for PostgreSQL. And this installer installs PostgreSQL according to the Apple guidelines namely in /Library/PostgreSQL/x.y/ where x.y is the version number.

Very Interesting - I know the Human Interface Guidelines, even since they first came out in printed form, a long time ago, huchhh 8) But do something like Install Apple Guidelines exist? Or what Apple guidelines are you refering to?

ROCLASI:
There are/were also installers who use more a UNIX guideline and install in /usr/local or in /opt.

Yeah, as an old Unix guy I installed it at /usr/local/blablabla - but that’s also not a very clever reason :evil:

ROCLASI:
Does this answer your question ?

It does really answer my question - except you forgot to mention why at these various locations - or why not - that’s what I am after :twisted:

Thanks, Robert

Hi Robert,

Robert Huber:
It does really answer my question - except you forgot to mention why at these various locations - or why not - that’s what I am after :twisted:

It’s just a convention that Apple dictates. Applications for all system users go into /Applications, applications for a single user goes into /Users//Applications/ and any system level stuff and services (like PostgreSQL) go into /Library or (for Apple) /System/Library.

Hope this helps.

Thanks Robert, I can’t find the document any more where all these information is written. If you can point me to it, it would be a great help.

Regards, Robert

ROCLASI:
Hi Robert,

Robert Huber:
It does really answer my question - except you forgot to mention why at these various locations - or why not - that’s what I am after :twisted:

It’s just a convention that Apple dictates. Applications for all system users go into /Applications, applications for a single user goes into /Users//Applications/ and any system level stuff and services (like PostgreSQL) go into /Library or (for Apple) /System/Library.

Hope this helps.

http://developer.apple.com/library/mac/ … 000185-SW1