Re: FW: [NOVICE] From a real novice - Mailing list pgsql-general

in /var/db/pkg I have:

postgresql-7.2.2
postgresql-7.3.1

/usr/local/pgsql/data/PG_VERSION contains 7.2
There are a few other copies of the file in the base subdirs and they also contain 7.2

libpq-fe.h is in /usr/local/include

there's actually a directory called /usr/local/include/libpq and it contains a file called libpq-fs.h
should I be worried about that as well?

there's also a /usr/local/include/posgresql/ as well as a /usr/local/include/postgres_ext.h

there's a /usr/local/lib/libpq.a and the lib directory contains many other similarly named files (libpq.so, etc as well
aslibpgeasy.a and others) 

/usr/local/bin contains psql as well as postgres* and postmaster@ -> postgres

I also have /var/db/pkg/postgresql-7.2.2/ as well as /var/db/pkg/postgresql-7.3.1/ directories

From what you see above, do you feel that a simple make deinstall will help me out and if so which directory should I
dothat in and in which order? 

> -----Original Message-----
> From: Marc G. Fournier [mailto:scrappy@hub.org]
> Sent: Sunday, March 23, 2003 11:12 PM
> To: Tamir Halperin
> Cc: pgsql-general@postgresql.org
> Subject: RE: [GENERAL] FW: [NOVICE] From a real novice
>
>
>
> Well, the first question is did he/she install from ports?  Those
> installations would be listed in /var/db/pkg, and a simple
> 'pkg_deinstall'
> will clean out the headers, libraries and binaries ...
>
> Doing a 'locate PG_VERSION' should find any data directories
> that may have
> been created, but I tend to have locate disabled on most of my FreeBSD
> boxes, so if that fails, also try 'find / -name PG_VERSION -print' ...
>
> If he/she didn't install from ports, yes, the experience
> could become a
> nightmare ... but, for the most part, you should be able to find most
> files using:
>
> include files:
>     find / -name libpq-fe.h -print
> lib files:
>     find / -name libpq.a -print
> binaries:
>     find / -name psql -print
>
> that will give you the directories they were installed in ... for the
> include files, if you do a 'grep PostgreSQL *' in the directory found
> above, you should find all the appropriate header file sas well ...
>
> no guarantees taht you'll find everything (or even anything),
> but should
> give you a good staritng point ...
>
>
>
>  On Sun, 23 Mar 2003, Tamir Halperin wrote:
>
> > Yes, Marc, there's lots of other services running on the
> box that I've also invested much time in configuring. Good
> point, though. My request does seem daunting enough to
> consider such drastic measures.
> >
> > > -----Original Message-----
> > > From: Marc G. Fournier [mailto:scrappy@hub.org]
> > > Sent: Sunday, March 23, 2003 10:59 PM
> > > To: Tamir Halperin
> > > Cc: pgsql-general@postgresql.org
> > > Subject: Re: [GENERAL] FW: [NOVICE] From a real novice
> > >
> > >
> > >
> > > Hi Tamir ...
> > >
> > >   From what you are describing, unless I'm missing something
> > > here, can't
> > > you just reinstall the OS from scratch (and go with a more recent
> > > version)?  OR is there somethign on the FreeBSD side that
> you need to
> > > save?
> > >
> > >
> > >
> > > On Sun, 23 Mar 2003, Tamir Halperin wrote:
> > >
> > > > I thought I'd throw this out to the kind folks in
> > > pgsql-general as well.
> > > >
> > > > -----Original Message-----
> > > > From: Tamir Halperin
> > > > Sent: Sunday, March 23, 2003 8:38 PM
> > > > To: pgsql-novice@postgresql.org
> > > > Subject: [NOVICE] From a real novice
> > > >
> > > >
> > > > 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 with
> > > my 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 a
> > > second version has been installed on top of the first one. I
> > > do not know either version. I suspect that to minimize all
> > > the variables, it would probably benefit me to simply
> > > deinstall all version of pgsql and then simply start off with
> > > the most current one available, 7.3.2. From the changes I've
> > > read about it, I can very much appreciate the advancements
> > > made in 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 my hands 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 as
> > > it may exist in various configuration files throughout my
> > > FreeBSD system. How can I ensure that I've removed all of
> > > these before 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 am
> > > truly a novice. If this request belongs in a different group,
> > > then please do instruct me as to which one.
> > > >
> > > > Thanks and thanks again,
> > > >
> > > > Tamir
> > > >
> > > >
> > > > ---------------------------(end of
> > > broadcast)---------------------------
> > > > TIP 6: Have you searched our list archives?
> > > >
> > > > http://archives.postgresql.org
> > > >
> > > >
> > > > ---------------------------(end of
> > > broadcast)---------------------------
> > > > TIP 2: you can get off all lists at once with the
> unregister command
> > > >     (send "unregister YourEmailAddressHere" to
> > > majordomo@postgresql.org)
> > > >
> > >
> >
>