On Nov 28, 2005, at 6:14 PM, Michael Glaesemann wrote:
> [Reordering top-posted reply]
>
> Conflicts with the ARD-installed server has been an issue for me on
> and off in the past, though I haven't been able to connect to the
> server using psql without specifying the ard database, user, and
> password. Also, I believe only the ARD server has the embedded
> PostgreSQL server (and an old one at that). Do you actually have
> the ARD server software installed on the Xserve? (My guess is you
> may be using the client software that is installed with the OS.)
>
> Also, could you check who owns those processes? The ARD-installed
> server will probably be owned by someone (such as daemon, though I
> don't recall off the top of my head) other than your normal
> postgres server.
>
> If you find it *is* a problem with ARD (which I am inclined to
> doubt), you can alter the port used by the ARD-installed PostgreSQL
> server by changing the port it uses in
>
> /var/db/RemoteManagement/RMDB/rmdb.data/postgresql.conf
>
> Hope this helps.
>
> Michael Glaesemann
> grzm myrealbox com
>
>
Thanks for the reply Michael. As I just wrote in response to Jim's
post, I don't think it is an ARD problem. The postmaster instance
running on the machine is our instance, not the ARD instance, and is
pointed at our data directory. We are able to connect to our
database using psql and JDBC; it is just that pg_ctl seems to be
lying to us! I have been suspect of ARD in the past (though at the
moment I can't remember why), but in this case I don't think it is
the source of the problem.
We are going to try updating the machine to PostgreSQL 8.1 tonight; I
will let you all know if that corrects the issue, but I'd really like
to understand what is going on, so if anyone has any ideas, please
let me know!
Thanks,
Tim