Re: Pgsql 7.3.3 on redhat 7.2 - Mailing list pgsql-general

From frbn
Subject Re: Pgsql 7.3.3 on redhat 7.2
Date
Msg-id 3F9687F5.3060000@seafrigo.com
Whole thread Raw
In response to Re: Pgsql 7.3.3 on redhat 7.2  ("Daniel E. Fisher" <danfisher@bwkip.com>)
Responses Re: Pgsql 7.3.3 on redhat 7.2  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-general
hi,
it seems you use the /usr/bin/pg_dumpall featured by the redhat default
install

verify this with "which pg_dumpall"
(rpm -ql postgresql to see all the files of this package)

you upgraded from sources didn't you ?

your fresh new install has the default prefix /usr/local (redhat uses /usr)

2 ways :  recompile/install with ./configure --prefix=/usr ...
or remove completely the redhat postgresql package (rpm -e postgresql)

By the way, UPGRADE YOU GCC!

2.96's is a redhat experimental buggy compiler (it should never have
been released)

I don't mean installing gcc-3.x but don't stay with 2.96 (2.95.x is good)


Daniel E. Fisher wrote:

>Ok...ran into problems backing database up.
>
>trying to run  pg_dumpall > backup102003
>
>gives me
>
>Database version 7.3.3 compiled by gcc 2.96
>
>Archiver DB  ver 7.1.3
>Aborting cause of version mismatch.
>
>use ignore if ok?
>
>Now it does have 7.3.3 on it but that is the old version of 7.1.3
>before the upgrade.  I really want to backup my data before I do this..
>but is it safe to ignore...
>
>I did copy  /usr/local/pgsql  to another directory just incase...
>is this good enough?
>
>-Dan
>
>-----Original Message-----
>From: pgsql-general-owner@postgresql.org
>[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Alvaro Herrera
>Sent: Monday, October 20, 2003 3:03 PM
>To: Daniel E. Fisher
>Cc: PGSQL List
>Subject: Re: [GENERAL] Pgsql 7.3.3 on redhat 7.2
>
>
>On Mon, Oct 20, 2003 at 01:03:23PM -0400, Daniel E. Fisher wrote:
>
>
>
>>After reading all my server logs:
>>
>>No error messages or nothing. Weird..
>>
>>
>
>Including Apache's /var/log/httpd/access_log and
>/var/log/httpd/error_log during restart?
>(or wherever you may have moved them)
>
>
>
>>May have something to do with reading wrong libpq Alvaro?
>>
>>
>
>Maybe ... check out what ldd path-to-pgsql.so says (PHP's support
>library)
>
>
>


pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: lastval(seq) ?
Next
From: Oksana Yasynska
Date:
Subject: Re: plpgsql: return multiple result sets or temp table