Re: Postgresql Install Problems and Mac OS X

Tonight I got my first pgsql server up and running on a G5. Because I
encountered similar "problems" I think this might be of help
(hopefully):

I installed the db from scratch and installed it into /usr/local/pgsql
(the binaries as well). As far as I can tell, Marc Lyanage's install
differs slightly from that because it uses /usr/local/bin for the pgsql
binaries. If I were you I'd open the Startup item in any texteditor
like so:

sudo pico /Library/StartupItems/PostgreSQL/PostgreSQL and check the
line that looks like this:

su - postgres -c '/usr/local/pgsql/bin/pg_ctl start -D
/usr/local/pgsql/data -l /usr/local/pgsql/logfile -o -i'

Make sure all paths are correct and - in case your postgres user
doesn't have a home directory, try to leave out the "-" right after
sudo so that it reads:

su postgres -c '/usr/local/pgsql/bin/pg_ctl start -D
/usr/local/pgsql/data -l /usr/local/pgsql/logfile -o -i'

This solved my problems that I had. Plus, I changed the location of the
logfile (because my postgres user could write to that /ur/local/ppgsq
dir but I like to keep the log together in the data dir) so that my
line reads:

su postgres -c '/usr/local/pgsql/bin/pg_ctl start -D
/usr/local/pgsql/data -l /usr/local/pgsql/data/logfile -o -i'

>> I'm using the Liyange package from http://www.entropy.ch, if this
>> helps.
Only the Startup Item or all of Lyanage's Postgres stuff?

Hope this helped...
Anyway, I found that a system reboot often solved a problem or two (but
don't do it in a production environment, you'll get killed ;-))

Stephan