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

[Jim Busser]

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>


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