Postgres Tools and Installation

[Owen Hartnett]

At 2:12 PM -0500 11/24/08, Steve Sisak wrote:
>At 1:51 PM -0500 11/24/08, Owen Hartnett wrote:
>>At 12:40 PM -0500 11/24/08, Steve Sisak wrote:
>>>Hi Owen,
>>>
>>>While I'm thinking of it -- could you post a list of the PostgreSQL
>>>tools and installation procedure you recommend?
>>>
>>  >I'm having some issues with the binary distribution on 10.5.
>>
>>Skip the binary distribution.  Install from the source.  It's so much better.
>>
>>All you have to worry about is configure options that you want to add.
>
>So what configure options would I want to add? Assume I know a lot 
>about mac programming and not a lot about futzing with configure.


I used:

	 ./configure --with-openssl --with-bonjour --with-tcl

I really haven't used any of the options, so a straight configure 
with no options would work just as well for me.

>
>Also, from this you imply that the source includes the requisite 
>launchd magic to get PostgreSQU to load on demand? (You ma assume I 
>know a lot about launchd)

I don't think you want launch on demand but launch on boot.  When it 
runs, it forks off a new process for a new connection.

Attached is my Folder from my StartupItems folder in my server.  Just 
alter the entries to match your circumstances.  I think you have to 
be careful of permissions on these, but you probably know how these 
work.

>
>Is there a set of build instructions you use? Where do you install?


There is a INSTALL readme in the source distribution.  Most of the 
time, you just want to run
configure as above, then make, then make install as root (or sudo 
make install).

It usually installs to /usr/local/pgsql

If you need to updating from an older database to the newer one (not 
just the software, but the database too), you want to run pg_dumpall 
on the old one first,  install the new, then create a new database 
and restore the backup. (This also gives you the ability to go back 
to the old if you need to.)
>
>>Did that cover your issues or do you have more?
>
>You mentioned a few GUI tools for inspecting/managing database. What 
>do you use/recommend? (A few URLs?)

I think you get PGAdmin III for free in the distribution package.  If 
not, you can download it from the postgresql site:

<http://www.postgresql.org>

There's also a free version of the Navicat tool at - it's pretty good too:

<http://www.navicat.com>

-Owen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PSQLStartup.sitx
Type: application/octet-stream
Size: 2066 bytes
Desc: not available
Url : http://lists.mactechgroup.org/pipermail/mactechgroup-discuss/attachments/20081124/23dcb690/attachment.obj