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. 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?
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:
Show quoted text
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 noviceI'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)
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.
Show quoted text
-----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 noviceHi 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 noviceI'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" tomajordomo@postgresql.org)
Import Notes
Resolved by subject fallback
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:
Show quoted text
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 noviceHi 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 noviceI'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" tomajordomo@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:
Show quoted text
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
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 as libpgeasy.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 do that in and in which order?
Show quoted text
-----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 noviceWell, 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 -printthat 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 noviceHi 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 thatyou 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 noviceI'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)
Import Notes
Resolved by subject fallback