Is this a "Stupid Question" ?

On Sun, Jun 20, 2004 at 07:50:53PM -0700, Adam Smith wrote:

I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently
remnants of 7.3.x are scattered around on the disk from (a) previous
ports installation, causing mutex_lock/unlock, libpq.so and other
installation problems. I want to reconfigure and reinstall. How do I
know what, & where all these fragments are located or how do I uninstall
all of them or at least those that should be removed.

If they're not installed with any sort of package management setup
then one way to do this would be to compile it and install it into
its own tree and then search out the files installed with find and
remove them.

--
Red herrings strewn hither and yon.

Do you know how it was originally installed? RPM or compiled source?

Are you also transferring data from 7.3 to 7.4?

Mike

...and on Sun, Jun 20, 2004 at 07:50:53PM -0700, Adam Smith used the keyboard:

I have posted this and similar questions repeatedly and can't even raise
a single response. I am being led to believe that this then 'Must be a
stupid question' although people say that there is no stupid question.
Is that another for political correctness

I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently
remnants of 7.3.x are scattered around on the disk from (a) previous
ports installation, causing mutex_lock/unlock, libpq.so and other
installation problems. I want to reconfigure and reinstall. How do I
know what, & where all these fragments are located or how do I uninstall
all of them or at least those that should be removed.

Hi Adam,

I don't think it's a stupid question, but it may be, given the way
ports are being maintained, difficult to answer. Figuring out where
and what was being installed in 7.3.x would've been rather easy if
you had installed the official source distribution of PostgreSQL -
all it would've taken was a download from the archives and a reinstall
from some wrapper script that took notice of where and what was being
installed. It may have even been just as simple as running "configure"
with original settings, followed by "make uninstall".

Since you're using FBSD ports collection though, a lot of the
responsibility for what goes where and how the various other aspects
of the source distribution are being organized, has been delegated
implicitly by you to the FBSD ports maintainer of the PostgreSQL
package.

I suggest you investigate where the ports graveyard of the postgres
package is located in order to find out what happened to the version
of PostgreSQL your system still seems to be holding parts of, and
try downloading and reinstalling (or maybe even "uninstall"ing) it;
if nothing else, at least it should enable you to look into how it
was being organized across the disks by providing you with all the
Makefiles that were used to install it.

Bottom line is - any (or all) of the above may be next to impossible
to do if the person that installed 7.3.x on that machine used some
non-standard setup options and failed to document it somewhere. In
that case, all that's left for you to do is to try to get a complete
listing of the files that are being installed in 7.3.x (perhaps by
installing with a DESTDIR, or using a different --prefix) and make
heavy use of find(1), locate(1) and other UNIX system commands for
locating files on a system, in an effort to chase down and remove all
the fragments of that previous build. At least writing scripts to
automate this for you isn't all that difficult to do.

Hope this helped,
--
Grega Bremec
Senior Administrator
Noviforum Ltd., Software & Media
http://www.noviforum.si/

Thanks Grega your explanation will go a far way, Thanks again
-- Adam --

Grega Bremec wrote:

hmmm, not sure that this is the best way.

under linux runing "./configure --help" will show you the default instlation
paths. go to each one of them and delete.

On future instelation you can consider
using --prefix=/usr/local/priv_dir_pg_what_ever_ver

dont forget to update PATH and ld.conf

cheers
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------

----- Original Message -----
From: "Adam Smith" <adamsmith@econ.com>
To: <"pgsql-admin@postgresql.org.pgsql-general"@postgresql.org>
Sent: Monday, June 21, 2004 5:50 AM
Subject: [GENERAL] Is this a "Stupid Question" ?

Adam Smith wrote:

I have posted this and similar questions repeatedly and can't even raise
a single response. I am being led to believe that this then 'Must be a
stupid question' although people say that there is no stupid question.
Is that another for political correctness

I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently
remnants of 7.3.x are scattered around on the disk from (a) previous
ports installation, causing mutex_lock/unlock, libpq.so and other
installation problems. I want to reconfigure and reinstall. How do I
know what, & where all these fragments are located or how do I uninstall
all of them or at least those that should be removed.

Hi,

If you installed the 7.3.x server via ports a simple
cd /usr/ports/databases/postgresql73 && make deinstall
should do the trick.
If this doesn't help, have a look into
/usr/ports/databases/postgresql73/pkg_pl.ist

Also have a look at sysutils/portupgrade, it's a great tool!

Thanks

HTH
Sebastian

-- Adam --
PS I should probably use the name Eve instead!

Better empty your mailbox, letting private messages pass through ;)

perhaps this is why you've received no answer?????

Sorry, unable to deliver your message to admin@econ.com for
the following reason:

552 Quota violation for admin at econ dot com

A copy of the original message below this line:

Return-Path: <removed>
Received: from redwing.mail.pas.earthlink.net ([207.217.120.246])
by kingbird (EarthLink Mail Service) with ESMTP id
1bEVI220L3NZFml0
for <admin at econ dot com>; Mon, 28 Jun 2004 05:58:06 -0700
(PDT)
Received: from toucan-120.pocket ([10.4.120.212] helo=toucan)
by redwing.mail.pas.earthlink.net with smtp (Exim 3.36 #1)
id 1Bevi2-0008Px-00
for admin at econ dot com; Mon, 28 Jun 2004 05:58:06 -0700
X-MindSpring-Loop: postmaster@econ.com
Received: from relay3.mail.twtelecom.net ([216.136.95.10])
by toucan (EarthLink Mail Service) with ESMTP id
1bEVHX1eQ3NZFmk0
for <adamsmith at econ dot com>; Mon, 28 Jun 2004 05:58:01 -0700
(PDT)
Received: from removed )
by relay3.mail.twtelecom.net (Postfix) with SMTP id 1CF3D6B4B
for <adamsmith at econ dot com>; Mon, 28 Jun 2004 07:58:01 -0500
(CDT)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0
Subject: RE: [GENERAL] Is this a "Stupid Question" ?
Date: Mon, 28 Jun 2004 08:58:00 -0400
Message-ID:
<64AE3D5B518E3648ACC823FBCB0B737502767E37@sr002-2kexc.ateb.com>
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Thread-Topic: [GENERAL] Is this a "Stupid Question" ?
Thread-Index: AcRcef4JWQko20oQQ+GuDme6wR5unwAlT2FA
From: "Reid Thompson" <removed >
To: "Adam Smith" <adamsmith at econ dot com>

I'd suggest looking at the original installations manifast/package
listing and then verifying that all parts of said listing are removed.
I'm not familiar with BSD, but I believe it is likely to have some form
of package manager(apt??) that should enable you to get some sort of
list. IF not, then looking through an rpm package should provide a list
of all the files.

Adam Smith wrote:

I have posted this and similar questions repeatedly and can't even
raise a single response. I am being led to believe that this then
'Must be a stupid question' although people say that there is no
stupid question. Is that another for political correctness
=20
I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently
remnants of 7.3.x are scattered around on the disk from (a) previous
ports installation, causing mutex_lock/unlock, libpq.so and other
installation problems. I want to reconfigure and reinstall. How do I
know what, & where all these fragments are located or how do
I uninstall
all of them or at least those that should be removed.
=20
Thanks
=20
-- Adam --
PS I should probably use the name Eve instead!
=20
=20
---------------------------(end of
broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index
scan if your
joining column's datatypes do not match

reid

Steve wrote:

mike g wrote:

Do you know how it was originally installed? RPM or compiled source?

Are you also transferring data from 7.3 to 7.4?

Mike

Please don't top post.

?? Could not decipher "Please don't top post" ??