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

[Sebastian Hilbert]

Am Mittwoch 30 Juni 2010, 11:28:09 schrieb Dave Cramer:
> On Wed, Jun 30, 2010 at 2:09 AM, Sebastian Hilbert
> 
> <address@hidden> wrote:
> > Am Dienstag 29 Juni 2010, 22:27:29 schrieb 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
> > 
> > I had the same situation and remove the complete folder.
> > 
> >> 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?
> > 
> > This is not out of the world. If you want to clean up completely do this
> > 
> > http://forums.enterprisedb.com/posts/list/1437.page
> > post by Sachin_S
> > 
> >> 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>
> > 
> > I have seen this before. This is a permission problem. In the shell
> > script it wants to get some info (cwd = current working directory) and
> > fails because of very strange sudo configuration on Apple. I had the
> > same problem with the bootstraper. Some create use of cli switches was
> > neccessary.
> 
> I think the real problem here is that the directory
> /Library/PostgreSQL8 was deleted in the step above.
>
You are right. Now I see it. It is trying to call the wrong PG instance.
I guess the notes to uninstall properly are valid then to have have it point 
to the correct instance after reinstalling.

Clean up the old and the new version including the directories, remove the 
postgresql user (it is all in the posting in the enterprisedb forum)

there is this app to remove PG (it is referenced in the posting as well)

I guess once everything has been removed it will just start to work.

Sebastian