Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Patric Michael
Hi Greg... On Fri, Jul 16, 2010 at 10:29 PM, Greg Smith wrote: > Patric Michael wrote: > >> /usr/share/pgsql/postgresql.conf.sample >> /var/lib/pgsql/data/postgresql.conf >> /home/archives/db/postgresql.conf >> /home/postgres/data/postgresql.conf >> >> The first line is the --datadir as reported

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Greg Smith
Patric Michael wrote: /usr/share/pgsql/postgresql.conf.sample /var/lib/pgsql/data/postgresql.conf /home/archives/db/postgresql.conf /home/postgres/data/postgresql.conf The first line is the --datadir as reported by pg_configure --configure The second line is the 7.4 data dir according to its PG_

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Patric Michael
On Fri, Jul 16, 2010 at 10:14 PM, Scott Marlowe wrote: > On Fri, Jul 16, 2010 at 11:10 PM, Patric Michael > wrote: > > Scott... > > > > On Fri, Jul 16, 2010 at 5:48 PM, Scott Marlowe > > wrote: > >> > >> So what does > >> > >> sudo locate postgresql.conf > >> > >> say? > > > > That I am irredeem

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Scott Marlowe
On Fri, Jul 16, 2010 at 11:10 PM, Patric Michael wrote: > Scott... > > On Fri, Jul 16, 2010 at 5:48 PM, Scott Marlowe > wrote: >> >> So what does >> >> sudo locate postgresql.conf >> >> say? > > That I am irredeemably lazy as an admin?  :) Lazy isn't always bad. Sometimes it makes you an effici

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Patric Michael
Scott... On Fri, Jul 16, 2010 at 5:48 PM, Scott Marlowe wrote: > > So what does > > sudo locate postgresql.conf > > say? > That I am irredeemably lazy as an admin? :) /usr/share/pgsql/postgresql.conf.sample /var/lib/pgsql/data/postgresql.conf /home/archives/db/postgresql.conf /home/postgres/da

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Scott Marlowe
On Fri, Jul 16, 2010 at 6:08 PM, Patric Michael wrote: > Thank you Tom, and I do agree in theory, but I am still unconvinced that > something else isnt amiss because I do recall having to rewrite the web > scripts which access the database, after I upgraded.  Seems there was a > change where an em

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Stephen Frost
* Patric Michael (bluesta...@gmail.com) wrote: > Is there any way for me to tell *without* postmaster or psql running, aside > from the contents of PG_VERSION? pg_controldata, as Tom suggested... Stephen signature.asc Description: Digital signature

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Patric Michael
Thank you Tom, and I do agree in theory, but I am still unconvinced that something else isnt amiss because I do recall having to rewrite the web scripts which access the database, after I upgraded. Seems there was a change where an empty field no longer returned a zero but a null (or vice versa) w

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: > On most modern Unixen it's perfectly possible for an existing process to > continue to run an executable that's been deleted from the filesystem. Indeed, but it's not generally a good thing. I'd recommend installing something which checks for such things a

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Tom Lane
Patric Michael writes: > HI Scott. I think if anything, the reverse is true. It is entirely > possible that I started 7.4 in a different directory by hand and that the > 7.4 server had been running all this time. Since I can't find any other > instances pf pg_ctl, I may well have deleted the ol

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Patric Michael
On Fri, Jul 16, 2010 at 4:08 PM, Scott Marlowe wrote: > On Fri, Jul 16, 2010 at 4:31 PM, Patric Michael > wrote: > > > > > Everything came back up as expected, with the exception of postgres. > When I > > went to start it manually, I got an error warning of an unrecognized > > tcpip_socket parame

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Scott Marlowe
On Fri, Jul 16, 2010 at 4:31 PM, Patric Michael wrote: > Hi all... > > I joined this list in an effort to solve a puzzle I fail to understand. > Thank you in advance for taking the time to read. > > I've been managing a domain for the last eight years as an erstwhile > administrator.  Erstwhile me

Re: [ADMIN] Stumped by a version conflict.

2010-07-16 Thread Craig James
On 7/16/10 3:31 PM, Patric Michael wrote: Hi all... I joined this list in an effort to solve a puzzle I fail to understand. Thank you in advance for taking the time to read. I've been managing a domain for the last eight years as an erstwhile administrator. Erstwhile meaning it is largely a ma

[ADMIN] Stumped by a version conflict.

2010-07-16 Thread Patric Michael
Hi all... I joined this list in an effort to solve a puzzle I fail to understand. Thank you in advance for taking the time to read. I've been managing a domain for the last eight years as an erstwhile administrator. Erstwhile meaning it is largely a matter of setting up and automating the routin