Re: RPMs for RedHat ES3.0 - installation problem

On Wed, 5 Oct 2005, Hui Zhou wrote:

> I have tried suggestion from Philip Yarra but I still could not get the
> 8.0.3 installed. Any help is appreciated. Thanks in advance.
>
> ----------------------------------------------- Command line
> ----------------------------------------------
> [root(at)maramar postgrsqllib]# rpm -i
> compat-postgresql-libs-3-3PGDG.i686.rpm
> warning: compat-postgresql-libs-3-3PGDG.i686.rpm: V3 DSA signature:
> NOKEY, key ID 748f7d0e
> error: Failed dependencies:
> postgresql-libs < 8.0.2 conflicts with
> compat-postgresql-libs-3-3PGDG

It seems that you have PostgreSQL 8.0 or 8.0.1 installed on your system.
You don't need the compat RPM if you are running those releases of
PostgreSQL.

If you want to upgrade to 8.0.2 and above, follow the usual upgrade
procedure first.

Regards,

--
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
>From pgsql-admin-owner(at)postgresql(dot)org Thu Oct 6 05:44:43 2005
X-Original-To: pgsql-admin-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 65616DA407
for <pgsql-admin-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Thu, 6 Oct 2005 05:44:42 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 03848-04
for <pgsql-admin-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Thu, 6 Oct 2005 08:44:36 +0000 (GMT)
Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254])
by svr1.postgresql.org (Postfix) with ESMTP id 3081ADA3CC
for <pgsql-admin(at)postgresql(dot)org>; Thu, 6 Oct 2005 05:44:36 -0300 (ADT)
Received: from bell.credativ.de (p50897593.dip.t-dialin.net [80.137.117.147])
(using TLSv1 with cipher RC4-MD5 (128/128 bits))
(No client certificate requested)
by gauss.credativ.com (Postfix) with ESMTP id EA9F6D7656;
Thu, 6 Oct 2005 10:44:33 +0200 (CEST)
From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Adriano Gaspar" <adrianogaspar(at)ibest(dot)com(dot)br>
Subject: Re: System Tables
Date: Thu, 6 Oct 2005 10:44:19 +0200
User-Agent: KMail/1.8.1
Cc: pgsql-admin(at)postgresql(dot)org
References: <20051005192928(dot)21F902BA66(at)webemail03(dot)ibest(dot)com(dot)br>
In-Reply-To: <20051005192928(dot)21F902BA66(at)webemail03(dot)ibest(dot)com(dot)br>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Content-Disposition: inline
Message-Id: <200510061044(dot)19570(dot)peter_e(at)gmx(dot)net>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.055 required=5 tests=[AWL=0.005,
FORGED_RCVD_HELO=0.05]
X-Spam-Level:
X-Archive-Number: 200510/78
X-Sequence-Number: 19150

Am Mittwoch, 5. Oktober 2005 21:29 schrieb Adriano Gaspar:
> I´m interesting in learning Postgre because I´m working with it now, if you
> can, i want to know wich are the system tables, and in wich of them can I
> find a table with all of the tables, and constrants.

I don't know what "Postgre" is supposed to be, but in case you're talking
about PostgreSQL, the chapter "System Catalogs" in the documentation should
give you all the information you need.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/