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@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Jeremy Smith
Sent: Wednesday, February 11, 2004 11:44 AM
To: pgsql-admin@postgresql.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