X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 28869D1D8DA for ; Wed, 11 Feb 2004 17:56:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 24764-04 for ; Wed, 11 Feb 2004 13:56:06 -0400 (AST) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id 6C4B5D1D8AA for ; Wed, 11 Feb 2004 13:56:06 -0400 (AST) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id i1BHs2c5011608; Wed, 11 Feb 2004 10:54:02 -0700 (MST) Date: Wed, 11 Feb 2004 10:49:07 -0700 (MST) From: "scott.marlowe" To: Jeremy Smith Cc: "Pgsql-Admin@Postgresql. Org" Subject: Re: psql not starting up.. In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/167 X-Sequence-Number: 12341 You need to rpm -e 'oldpostgresqlpackagenamehere' to get rid of 7.3 first. On Wed, 11 Feb 2004, Jeremy Smith wrote: > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >