To find out how many versions you have installed search your directories
for copies of 'postgres'.
locate postgres
find / -name postgres
I can't speak to the particulars of FreeBSD, but compiling from source
tends to include 'pgsql' or 'postgres' as a directory in the path.
The source, once configured, includes a 'gmake uninstall' capability
although I've not tried that.
To find out which version(s) you have installed, look for a file named
PG_VERSION which contains the minor version number (i.e., 7.3 for 7.3.2).
This will also help you locate where the data files are stored.
You probably do NOT want the "most recent" version unless you are
interested in debugging postgres - you want the "most recent STABLE"
version. That would (at this point) be 7.3.2.
On Sun, 23 Mar 2003, Tamir Halperin wrote:
> I've just been abandoned by my FreeBSD/PostgreSQL administrator just as we were setting things up for our test
server.I hope if I provide as much of the specs as I can get my hands on, someone on the list will be able to help me
withmy problem.
>
> Although pgsql seems to be installed, I do not know why pgsql isn't running or starting at the time the system comes
up.It doesn't show up in the TOP list.
>
> I'm running FreeBSD 4.6-RELEASE. I'm not exactly sure which version of PostgreSQL I'm running and I also suspect that
asecond version has been installed on top of the first one. I do not know either version. I suspect that to minimize
allthe variables, it would probably benefit me to simply deinstall all version of pgsql and then simply start off with
themost current one available, 7.3.2. From the changes I've read about it, I can very much appreciate the advancements
madein this version.
>
> 1. How can I take an inventory of the various installations of pgsql on my FreeBSD computer?
>
> 2. How can I remove them?
>
> 3. I assume I can ensure I have the most recent installation support by doing a cvsup but I really only want to get
myhands on the most recent pgsql for FreeBSD. How is this possible?
>
> 4. We did minimal work on the previous version and I don't need to save any of the data or configuration information
asit may exist in various configuration files throughout my FreeBSD system. How can I ensure that I've removed all of
thesebefore I do my new installation?
>
> At a time like this I can not describe how grateful I would be for someone's detailed and very patient assistance. I
amtruly a novice. If this request belongs in a different group, then please do instruct me as to which one.
>
> Thanks and thanks again,
>
> Tamir
