Re: 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(at)hub(dot)org]
> > Sent: Sunday, March 23, 2003 10:59 PM
> > To: Tamir Halperin
> > Cc: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)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(at)postgresql(dot)org)
> > >
> >
>