pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Is this a "Stupid Question" ?
8+ messages / 6 participants
[nested] [flat]

* Is this a "Stupid Question" ?
@ 2004-06-21 02:50 Adam Smith <adamsmith@econ.com>
  2004-06-21 04:39 ` Re: Is this a "Stupid Question" ? CaT <cat@zip.com.au>
  2004-06-21 04:47 ` Re: Is this a "Stupid Question" ? mike g <mike@thegodshalls.com>
  2004-06-21 04:53 ` Re: Is this a "Stupid Question" ? Grega Bremec <grega.bremec@noviforum.si>
  2004-06-27 20:00 ` Re: Is this a "Stupid Question" ? Ben-Nes Michael <miki@canaan.co.il>
  2004-06-28 05:50 ` Re: Is this a "Stupid Question" ? Sebastian Böck <sebastianboeck@freenet.de>
  0 siblings, 5 replies; 8+ messages in thread

From: Adam Smith @ 2004-06-21 02:50 UTC (permalink / raw)
  To: " <pgsql-admin@postgresql.org.pgsql-general>

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.

Thanks

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




^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Is this a "Stupid Question" ?
  2004-06-21 02:50 Is this a "Stupid Question" ? Adam Smith <adamsmith@econ.com>
@ 2004-06-21 04:39 ` CaT <cat@zip.com.au>
  4 siblings, 0 replies; 8+ messages in thread

From: CaT @ 2004-06-21 04:39 UTC (permalink / raw)
  To: Adam Smith <adamsmith@econ.com>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Is this a "Stupid Question" ?
  2004-06-21 02:50 Is this a "Stupid Question" ? Adam Smith <adamsmith@econ.com>
@ 2004-06-21 04:47 ` mike g <mike@thegodshalls.com>
  2004-07-04 08:54   ` Re: Is this a "Stupid Question" ? Adam Smith <adamsmith@econ.com>
  4 siblings, 1 reply; 8+ messages in thread

From: mike g @ 2004-06-21 04:47 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin

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

Are you also transferring data from 7.3 to 7.4?

Mike
> 
> RPM can be 
> On Sun, 2004-06-20 at 21:50, 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.
> > 
> > Thanks
> > 
> > --  Adam  --
> > PS I should probably use the name Eve instead!
> > 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org



^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Is this a "Stupid Question" ?
  2004-06-21 02:50 Is this a "Stupid Question" ? Adam Smith <adamsmith@econ.com>
  2004-06-21 04:47 ` Re: Is this a "Stupid Question" ? mike g <mike@thegodshalls.com>
@ 2004-07-04 08:54   ` Adam Smith <adamsmith@econ.com>
  0 siblings, 0 replies; 8+ messages in thread

From: Adam Smith @ 2004-07-04 08:54 UTC (permalink / raw)
  To: Steve <Steve@nospam.org>



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" ??
> 
> Thanks,
> Steve
> 




^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Is this a "Stupid Question" ?
  2004-06-21 02:50 Is this a "Stupid Question" ? Adam Smith <adamsmith@econ.com>
@ 2004-06-21 04:53 ` Grega Bremec <grega.bremec@noviforum.si>
  2004-06-21 05:41   ` Re: [ADMIN] Is this a "Stupid Question" ? Adam Smith <adamsmith@econ.com>
  4 siblings, 1 reply; 8+ messages in thread

From: Grega Bremec @ 2004-06-21 04:53 UTC (permalink / raw)
  To: Adam Smith <adamsmith@econ.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org

...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/

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: [ADMIN] Is this a "Stupid Question" ?
  2004-06-21 02:50 Is this a "Stupid Question" ? Adam Smith <adamsmith@econ.com>
  2004-06-21 04:53 ` Re: Is this a "Stupid Question" ? Grega Bremec <grega.bremec@noviforum.si>
@ 2004-06-21 05:41   ` Adam Smith <adamsmith@econ.com>
  0 siblings, 0 replies; 8+ messages in thread

From: Adam Smith @ 2004-06-21 05:41 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

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

Grega Bremec wrote:
> ...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,




^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Is this a "Stupid Question" ?
  2004-06-21 02:50 Is this a "Stupid Question" ? Adam Smith <adamsmith@econ.com>
@ 2004-06-27 20:00 ` Ben-Nes Michael <miki@canaan.co.il>
  4 siblings, 0 replies; 8+ messages in thread

From: Ben-Nes Michael @ 2004-06-27 20:00 UTC (permalink / raw)
  To: Adam Smith <adamsmith@econ.com>; postgresql <pgsql-general@postgresql.org>

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" ?


> 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.
>
> Thanks
>
> --  Adam  --
> PS I should probably use the name Eve instead!
>
>
> ---------------------------(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
>




^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Is this a "Stupid Question" ?
  2004-06-21 02:50 Is this a "Stupid Question" ? Adam Smith <adamsmith@econ.com>
@ 2004-06-28 05:50 ` Sebastian Böck <sebastianboeck@freenet.de>
  4 siblings, 0 replies; 8+ messages in thread

From: Sebastian Böck @ 2004-06-28 05:50 UTC (permalink / raw)
  To: Adam Smith <adamsmith@econ.com>; +Cc: pgsql-general@postgresql.org

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 ;)



^ permalink  raw  reply  [nested|flat] 8+ messages in thread


end of thread, other threads:[~2004-07-04 08:54 UTC | newest]

Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-21 02:50 Is this a "Stupid Question" ? Adam Smith <adamsmith@econ.com>
2004-06-21 04:39 ` CaT <cat@zip.com.au>
2004-06-21 04:47 ` mike g <mike@thegodshalls.com>
2004-07-04 08:54   ` Adam Smith <adamsmith@econ.com>
2004-06-21 04:53 ` Grega Bremec <grega.bremec@noviforum.si>
2004-06-21 05:41   ` Adam Smith <adamsmith@econ.com>
2004-06-27 20:00 ` Ben-Nes Michael <miki@canaan.co.il>
2004-06-28 05:50 ` Sebastian Böck <sebastianboeck@freenet.de>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox