Обсуждение: FW: [NOVICE] From a real novice
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. Ihope 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 secondversion has been installed on top of the first one. I do not know either version. I suspect that to minimize all thevariables, it would probably benefit me to simply deinstall all version of pgsql and then simply start off with the mostcurrent one available, 7.3.2. From the changes I've read about it, I can very much appreciate the advancements made inthis 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 handson 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 itmay 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 am trulya 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
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 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 > > > ---------------------------(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) >
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) > > >
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) > > > > > >
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
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) > > > > > > > > > >