Re: [Gnumed-devel] Postgres 8.4.4-1 (Enterprise db) problems -- system hosed?

[Dave Cramer]

On Tue, Jun 29, 2010 at 4:27 PM, Jim Busser <address@hidden> wrote:
> On 2010-06-29, at 2:39 AM, Dave Cramer wrote:
>
>> OS X it uses a completely different mechanism.
>> The best way to install pg on a mac is using the source and building
>> it. The start script should be in /Library/StartupItems
>
> Thanks, I have gotten rid of
>        /Library/PostgreSQL8/data/pg_hba.conf
> and kept
>        /Library/PostgreSQL/8.4/data/pg_hba.conf
>
> but as to /Library/StartupItems I have no such directory, and in 
> /System/Library/StartupItems there is only
>         \vpnagentd
>
> and there is nothing for me to choose in Apple > System Preferences > 
> Accounts > Login items, and the command "psql" gives "command not found", so 
> I wonder whether the enterprisedb failed to install needed scripts? Despite 
> no StartupItems, the command
>
>        sudo SystemStarter start PostgreSQL
>
> gave me the following
>
>
> <verbatim>
> sudo: cannot get working directory
> shell-init: error retrieving current directory: getcwd: cannot access parent 
> directories: No such file or directory
> Starting PostgreSQL database server
> job-working-directory: error retrieving current directory: getcwd: cannot 
> access parent directories: No such file or directory
> shell-init: error retrieving current directory: getcwd: cannot access parent 
> directories: No such file or directory
> sh: /Library/PostgreSQL8/bin/pg_ctl: No such file or directory
> MacBook:log djb$
> </verbatim>

Looks like it was looking for the old version that you deleted.

Ok, so there must be another directory with the startup item  PostgreSQL

in a shell as root do

locate PostgreSQL

You should be able to find it, when you do you can edit the startup
item to change the directory that it is using.

On the other hand if edb's install doesn't work, this is a waste of
time for future installs.

Dave

>
>
> so I am not sure whether to
>
>        try to fix manually
>
>        retry Enterprisedb installation
>
>        assume E...db is defective and instead install (MacPorts)
>                postgresql84-server
>        which is not yet installed
>
>
>
> References:
>
>        http://archives.postgresql.org/pgsql-general/2007-07/msg01167.php
>        http://archives.postgresql.org/pgsql-committers/2004-03/msg00089.php
>        http://serverfault.com/questions/138676/how-to-restart-postgres-on-os-x
>
>        
> http://devoh.com/posts/2008/10/installing-postgresql-on-mac-os-x-10.5-leopard
>
>        http://www.thexlab.com/faqs/startupitems.html
>        http://guide.macports.org/chunked/reference.startupitems.html
>
>        from 2006:
>        http://www.courseforum.com/howto_startupitem.html
>
>        also
>        
> http://developer.apple.com/mac/library/documentation/MacOSX/Conceptual/BPSystemStartup/Articles/StartupItems.html
>        http://osxfaq.com/Tutorials/LearningCenter/HowTo/Startup/index.ws
>
> -- Jim
>
>