PostgreSQL Discussion - Problem upgrading from 8.0.1 to 8.0.3

Author

Problem upgrading from 8.0.1 to 8.0.3

Clodoaldo Pinto

2005-08-25, 9:24 am

I was running 8.0.1 and PHP in FC3 with no problems.

Then i upgraded to 8.0.3 using yum and yum installed
postgresql-libs.i386 0:7.4.8-1.FC3.1. (Is it Ok?)

Now i am receving this message from PHP:
PHP Fatal error: Call to undefined function: pg_pconnect()

php-pgsql was already installed. I removed it and tried to reinstall
and got this dependencies errors:

# yum install php-pgsql*
Setting up Install Process
Setting up Repos
base 100% |===================
======| 1.1 kB 00:00
updates-released 100% |===================
======| 951 B 00:00
Reading repository metadata in from local files
base : ####################
####################
########## 2622/2622
updates-re: ####################
####################
########## 1041/1041
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package php-pgsql.i386 0:4.3.11-2.6 set to be updated
--> Running transaction check
--> Processing Dependency: libpq.so.3 for package: php-pgsql
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package postgresql-libs.i386 0:7.4.8-1.FC3.1 set to be updated
--> Running transaction check
--> Processing Dependency: libpq.so.4 for package: postgresql-python
--> Processing Dependency: libpq.so.4 for package: postgresql-contrib
--> Processing Dependency: postgresql-libs = 8.0.3 for package:
postgresql-devel--> Processing Dependency: libpq.so.4 for package:
postgresql-server
--> Processing Dependency: libpq.so.4 for package: postgresql
--> Finished Dependency Resolution
Error: Missing Dependency: libpq.so.4 is needed by package postgresql-python
Error: Missing Dependency: libpq.so.4 is needed by package postgresql-contrib
Error: Missing Dependency: postgresql-libs = 8.0.3 is needed by
package postgresql-devel
Error: Missing Dependency: libpq.so.4 is needed by package postgresql-server
Error: Missing Dependency: libpq.so.4 is needed by package postgresql

Regards, Clodoaldo Pinto

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

http://www.postgresql.org/docs/faq

Alvaro Herrera

2005-08-28, 1:23 pm

On Thu, Aug 25, 2005 at 10:17:05AM -0300, Clodoaldo Pinto wrote:
> I was running 8.0.1 and PHP in FC3 with no problems.
>
> Then i upgraded to 8.0.3 using yum and yum installed
> postgresql-libs.i386 0:7.4.8-1.FC3.1. (Is it Ok?)

It would have been better if it had picked postgresql-compat (or
whatever the name is for the package that has libpq3 in the 8.0.3
release). Probably if you install that package by hand or convince yum
to do it for you, the problem would be solved. Most likely you need to
uninstall the 7.4 package at the same time.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org> )
"Now I have my system running, not a byte was off the shelf;
It rarely breaks and when it does I fix the code myself.
It's stable, clean and elegant, and lightning fast as well,
And it doesn't cost a nickel, so Bill Gates can go to hell."

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

Clodoaldo Pinto

2005-08-28, 1:23 pm

2005/8/28, Alvaro Herrera <alvherre@alvh.no-ip.org>:
> On Thu, Aug 25, 2005 at 10:17:05AM -0300, Clodoaldo Pinto wrote:
> It would have been better if it had picked postgresql-compat (or
> whatever the name is for the package that has libpq3 in the 8.0.3
> release). Probably if you install that package by hand or convince yum
> to do it for you, the problem would be solved. Most likely you need to
> uninstall the 7.4 package at the same time.
>

I didn't know about compat. What I did was to extract libpq3 from
7.4.8 and copied it to its place. Then forced the install of
php-pgsql.

Regards, Clodoaldo Pinto

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

http://www.postgresql.org/docs/faq

Sponsored Links