From: | Stephan Hochhaus <stephan(at)yauh(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org, Lola Lee <lola(at)his(dot)com> |
Subject: | Re: Postgresql Install Problems and Mac OS X |
Date: | 2004-03-06 22:27:49 |
Message-ID: | 7FE2BD27-6FBD-11D8-B837-003065EFA8F0@yauh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | stm23 | 2004-03-07 00:14:00 | postgresql already installed? version? |
Previous Message | M. Bastin | 2004-03-06 22:10:37 | Re: Postgresql Install Problems and Mac OS X |