Re: psql not starting up..

To follow up on this, I just did try deleting those files and running the
RPM process again, and received the same errors.

rpm -ih postgresql-libs-7.4-0.3PGDG.i386.rpm
########################################### [100%]
file /usr/lib/libpq.so.3 from install of postgresql-libs-7.4-0.3PGDG
conflicts with file from package postgresql-libs-7.3.3-1PGDG
.
.
.

Jeremy

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Jeremy Smith
Sent: Wednesday, February 11, 2004 11:44 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] psql not starting up..

Hi again,

I have started working on migrating my DBs from mysql to postgres today and
ran into a problem. When I type in psql, I get this error:

Welcome to psql 7.3.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

psql: relocation error: psql: undefined symbol: PQgetssl

It is showing psql as being version 7.3.3 even though I upgraded to 7.4.0
last night. But when I installed the RPM for the libraries (among other
things) I got errors like this:

file /usr/share/locale/zh_CN/LC_MESSAGES/libpq.mo from install of
postgresql-libs-7.4-0.3PGDG conflicts with file from package
postgresql-libs-7.3.3-1PGDG

should I just go through one by one and delete the files that it is telling
me I have a conflict with?

Thanks alot!
Jeremy

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster