Pgsql 7.3.3 on redhat 7.2

[Daniel E. Fisher]

> I can't get a rest for a min guys.

I go away for the weekend and my server is getting this error.

Fatal error: Call to undefined function: pg_connect() in
/var/www/html/crohns/phpBB2/db/postgres7.php on line 79

Your PHP doesn't have support for PostgreSQL.

Look at phpinfo();

--->
From the backup to the current php.ini file... this is what was changed...
Looks like an autoupdate on php happened.

This was turned off in the current php.ini
;;;;;;;;;;;;;;; ;
; File Uploads ;
;;;;;;;;;;;;;;; ;

; Whether to allow HTTP file uploads.
file_uploads = Off
the backup had this tuned on

?

this cause it?

-Dan

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[frbn]

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: pg************* ****@postgresql .org
[mailto:pg****** ***********@pos tgresql.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)

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Paul Thomas]

On 22/10/2003 14:36 frbn wrote:

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)

I've found the easiest way to over-write a RPM installed version with one
one compiled from source is to use pg_config --configure to get all the
original options which the RMP version was built with. I then supply these
options to the configure script. This way, I know that the new version
will over-write the old version.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings