f



I can't upgrade to PostgreSQL 7.4 in RedHat 9.0

Hello list

This is my situation:

My box: Pentium III, Red Hat 9.0

I was working fine with PostgreSQL 7.3.2.
Recently I decided to upgrade it to PostgreSQL 7.4 installing the twelve
rpms I downloaded from
ftp://ftp15.us.postgresql.org/binar...dhat/refhat-9/.

I followed the standar command to upgrade rpm packages but the installation
failed due to conflicts with the installed package unixODBC-devel-2.2.3-6.

This is the output I got from the system:
-------------------------------------------
#rpm -Uvh postgresql*7.4-0.5PGDG.i386.rpm
Preparing... ########################[100%]
file /usr/include/sqltypes.h from install of postgresql-devel-7.4-0.5PGDG
conflicts with file from package unixODBC-devel-2.2.3-6
----------------------------------------------

At first solution I tried to uninstall unixODBC (composed by two rpms:
unixODBC-2.2.3-06 and unixODBC-devel-2.2.3-6) but failed due to dependence
with the package libodbc++-0.2.2pre4-12 ( an ODBC class library that
emulates the JBBC interface). So, I change my mind because I fear to enter
in an endless upgrading.

My questions are:

a)What must I do to upgrade from PostgreSQL 7.3.2 I to PostgreSQL 7.4 in Red
Hat 9.0?.
b) If it is neccesary to upgrade the package unixODBC, where I can get the
rpm and what is the
correct version.?


I really hope someone can give me a hand.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

0
mantemu
1/25/2004 3:38:47 AM
comp.postgresql.general 5128 articles. 0 followers. Post Follow

15 Replies
264 Views

Similar Articles

[PageSpeed] 42

On Sunday 25 January 2004 03:38, Manuel Tejada wrote:
> Hello list
>
> This is my situation:
>
> My box: Pentium III, Red Hat 9.0
>
> I was working fine with PostgreSQL 7.3.2.
> Recently I decided to upgrade it to PostgreSQL 7.4 installing the twelve
> rpms I downloaded from
> ftp://ftp15.us.postgresql.org/binar...dhat/refhat-9/.
>
> I followed the standar command to upgrade rpm packages but the installation
> failed due to conflicts with the installed package unixODBC-devel-2.2.3-6.
>
> This is the output I got from the system:
> -------------------------------------------
> #rpm -Uvh postgresql*7.4-0.5PGDG.i386.rpm
> Preparing... ########################[100%]
> file /usr/include/sqltypes.h from install of postgresql-devel-7.4-0.5PGDG
> conflicts with file from package unixODBC-devel-2.2.3-6
> ----------------------------------------------

Check the mailing-list archives. for references to this file (sqltypes.h) - 
this problem cropped up with the RPMs for 7.4.0 (a clash with another 
package).

Incidentally, shouldn't you be using 7.4.1?

-- 
  Richard Huxton
  Archonet Ltd

---------------------------(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

0
dev
1/26/2004 3:39:23 PM
On Saturday 24 January 2004 10:38 pm, Manuel Tejada wrote:
> I followed the standar command to upgrade rpm packages but the installation
> failed due to conflicts with the installed package unixODBC-devel-2.2.3-6.

Use the 7.4.1 RPMs.  The conflict is fixed there, since it is an upstream 
(that is, not an RPM) issue.  The short of it was that the ECPG headers and 
the unixODBC headers both thought they should be in the same place with the 
same file name.  The 7.4.1 install (tarball) patched this to put the ECPG 
headers in a subdirectory, allowing unixODBC to have the name.
-- 
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC  28772
(828)862-5554
www.pari.edu


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

0
lowen
1/26/2004 4:49:50 PM
Where I can get the rpms for PostgreSQL 7.4.1?

The  ftp://ftp15.us.postgresql.org/binary/v7.4.1/redhat/ only has
subdirectories for redhat-6.2, redhat-7.3, redhat-8.0, rhas-2.1, rhel3


----- Original Message ----- 
From: "Lamar Owen" <lowen@pari.edu>
To: "Manuel Tejada" <mantemu@terra.com.pe>; <pgsql-general@postgresql.org>
Sent: Monday, January 26, 2004 11:49 AM
Subject: Re: [GENERAL] I can't upgrade to PostgreSQL 7.4 in RedHat 9.0


> On Saturday 24 January 2004 10:38 pm, Manuel Tejada wrote:
> > I followed the standar command to upgrade rpm packages but the
installation
> > failed due to conflicts with the installed package
unixODBC-devel-2.2.3-6.
>
> Use the 7.4.1 RPMs.  The conflict is fixed there, since it is an upstream
> (that is, not an RPM) issue.  The short of it was that the ECPG headers
and
> the unixODBC headers both thought they should be in the same place with
the
> same file name.  The 7.4.1 install (tarball) patched this to put the ECPG
> headers in a subdirectory, allowing unixODBC to have the name.
> -- 
> Lamar Owen
> Director of Information Technology
> Pisgah Astronomical Research Institute
> 1 PARI Drive
> Rosman, NC  28772
> (828)862-5554
> www.pari.edu
>


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

0
mantemu
1/27/2004 2:03:30 AM
On Monday 26 January 2004 09:03 pm, Manuel Tejada wrote:
> Where I can get the rpms for PostgreSQL 7.4.1?

> The  ftp://ftp15.us.postgresql.org/binary/v7.4.1/redhat/ only has
> subdirectories for redhat-6.2, redhat-7.3, redhat-8.0, rhas-2.1, rhel3

For RH9 you will have to rebuild from the source RPM, since I don't yet have 
an RH9 set built.  The source RPM is in the SRPMS directory under v7.4.1.  Or 
you can wait until either Sander Steffann or someone else builds a set that I 
can upload.  I no longer have an RH9 machine installed to build it with.

You might be able to use the RHEL3 set, though, since RHEL3 and RHL9 are 
pretty close.
-- 
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC  28772
(828)862-5554
www.pari.edu


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

0
lowen
1/27/2004 3:20:32 PM
This is a multi-part message in MIME format.
--------------060006000004040206030101
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

We were able to use the RHEL3 under Red Hat 9 with no problems.

Warmest regards, 
Ericson Smith
Tracking Specialist/DBA
+-----------------------+--------------------------------------+
| http://www.did-it.com | "Crush my enemies, see then driven   |
| eric@did-it.com       | before me, and hear the lamentations |
| 516-255-0500          | of their women." - Conan             |
+-----------------------+--------------------------------------+ 



Lamar Owen wrote:

>On Monday 26 January 2004 09:03 pm, Manuel Tejada wrote:
>  
>
>>Where I can get the rpms for PostgreSQL 7.4.1?
>>    
>>
>
>  
>
>>The  ftp://ftp15.us.postgresql.org/binary/v7.4.1/redhat/ only has
>>subdirectories for redhat-6.2, redhat-7.3, redhat-8.0, rhas-2.1, rhel3
>>    
>>
>
>For RH9 you will have to rebuild from the source RPM, since I don't yet have 
>an RH9 set built.  The source RPM is in the SRPMS directory under v7.4.1.  Or 
>you can wait until either Sander Steffann or someone else builds a set that I 
>can upload.  I no longer have an RH9 machine installed to build it with.
>
>You might be able to use the RHEL3 set, though, since RHEL3 and RHL9 are 
>pretty close.
>  
>

--------------060006000004040206030101
Content-Type: text/x-vcard; charset=utf8;
 name="eric.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="eric.vcf"

begin:vcard
fn:Ericson Smith
n:Smith;Ericson
org:Did-it.com;Programming
adr:#304;;55 Maple Avenue;Rockville Center;NY;11570;USA
email;internet:eric@did-it.com
title:Web Developer
tel;work:516-255-0500
tel;cell:646-483-3420
note:Nothing special!
x-mozilla-html:FALSE
url:http://www.did-it.com
version:2.1
end:vcard


--------------060006000004040206030101
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


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

--------------060006000004040206030101--

0
eric
1/27/2004 3:55:12 PM
You are right, I installed PostgreSQL 7.4.1 rpms from directory RHEL3 on Red
Hat 9.0 and the new version works OK.
The only extrange thing I noticed after the installation is when I press the
rigth button on any file from any directory to select an editor (for example
vim) the editor doesn't respond. I don't know certainly if this malfunction
is related to the new installation.  But the start of PostgreSQL, creation
of user, databases, etc, works well.

By the way, what does mean RHEL3?
Is it a new version of Red Hat?


----- Original Message ----- 
From: "Ericson Smith" <eric@did-it.com>
To: "Lamar Owen" <lowen@pari.edu>
Cc: "Manuel Tejada" <mantemu@terra.com.pe>; <pgsql-general@postgresql.org>
Sent: Tuesday, January 27, 2004 10:55 AM
Subject: Re: [GENERAL] I can't upgrade to PostgreSQL 7.4 in RedHat 9.0


> We were able to use the RHEL3 under Red Hat 9 with no problems.
>
> Warmest regards,
> Ericson Smith
> Tracking Specialist/DBA
> +-----------------------+--------------------------------------+
> | http://www.did-it.com | "Crush my enemies, see then driven   |
> | eric@did-it.com       | before me, and hear the lamentations |
> | 516-255-0500          | of their women." - Conan             |
> +-----------------------+--------------------------------------+
>
>
>
> Lamar Owen wrote:
>
> >On Monday 26 January 2004 09:03 pm, Manuel Tejada wrote:
> >
> >
> >>Where I can get the rpms for PostgreSQL 7.4.1?
> >>
> >>
> >
> >
> >
> >>The  ftp://ftp15.us.postgresql.org/binary/v7.4.1/redhat/ only has
> >>subdirectories for redhat-6.2, redhat-7.3, redhat-8.0, rhas-2.1, rhel3
> >>
> >>
> >
> >For RH9 you will have to rebuild from the source RPM, since I don't yet
have
> >an RH9 set built.  The source RPM is in the SRPMS directory under v7.4.1.
Or
> >you can wait until either Sander Steffann or someone else builds a set
that I
> >can upload.  I no longer have an RH9 machine installed to build it with.
> >
> >You might be able to use the RHEL3 set, though, since RHEL3 and RHL9 are
> >pretty close.
> >
> >
>


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

0
mantemu
1/30/2004 1:50:47 AM
On Thu, Jan 29, 2004 at 08:50:47PM -0500, Manuel Tejada wrote:

> By the way, what does mean RHEL3?

"Red Hat Entreprise Linux", a commercial Linux distribution (meaning you
shouldn't use it unless you pay for it).

> Is it a new version of Red Hat?

You mean Red Hat as in "Red Hat Linux"?  That product has been
discontinued, and superseded by a new project somewhat resembling Debian
called Fedora Linux, which is the "free" version of the Red Hat Linux
distribution.  It doesn't seem to be suited for server use, of course.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"In Europe they call me Niklaus Wirth; in the US they call me Nickel's worth.
That's because in Europe they call me by name, and in the US by value!"

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

0
alvherre
1/30/2004 2:04:53 AM
On Thu, Jan 29, 2004 at 23:04:53 -0300,
  Alvaro Herrera <alvherre@dcc.uchile.cl> wrote:
> On Thu, Jan 29, 2004 at 08:50:47PM -0500, Manuel Tejada wrote:
> 
> > By the way, what does mean RHEL3?
> 
> "Red Hat Entreprise Linux", a commercial Linux distribution (meaning you
> shouldn't use it unless you pay for it).

From discussions I have seen, I don't think that is the correct semantics.
I believe that you can use RHEL for free. But if you by a support license,
you need to buy a support license for all copies of RHEL you are using.

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

0
bruno
1/30/2004 4:05:24 PM
--=-RFKS91PW11xOyzcElCOp
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Fri, 2004-01-30 at 13:04, Alvaro Herrera wrote:
> On Thu, Jan 29, 2004 at 08:50:47PM -0500, Manuel Tejada wrote:
>=20
> > By the way, what does mean RHEL3?
>=20
> "Red Hat Entreprise Linux", a commercial Linux distribution (meaning you
> shouldn't use it unless you pay for it).

No, it means you won't get support unless you pay for it, and if you get
support for a single machine in your organisation using RHEL, you must
get support for all of them.

	Stephen

--=-RFKS91PW11xOyzcElCOp
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQBAHd6V4hFS2REFUecRAlSkAJ4nk7yM+daSDZRrAgde2dW2BYL4qACghLpb
PeTiQRLZxDz7mCCyRsKOnwY=
=XTk6
-----END PGP SIGNATURE-----

--=-RFKS91PW11xOyzcElCOp--

0
srn
2/2/2004 5:22:29 AM
On Mon, Feb 02, 2004 at 04:22:29PM +1100, Stephen Robert Norris wrote:
> On Fri, 2004-01-30 at 13:04, Alvaro Herrera wrote:
> > On Thu, Jan 29, 2004 at 08:50:47PM -0500, Manuel Tejada wrote:
> > 
> > > By the way, what does mean RHEL3?
> > 
> > "Red Hat Entreprise Linux", a commercial Linux distribution (meaning you
> > shouldn't use it unless you pay for it).
> 
> No, it means you won't get support unless you pay for it, and if you get
> support for a single machine in your organisation using RHEL, you must
> get support for all of them.

It's exactly the same thing.  Using an unsupported operating system is
only a matter of time before some cracker 0wnz j00.  Of course, you
could build your own security updates, but it will be a very expensive
thing to do.  In this situation one should really consider switching to
another distribution, like, say, White Box (which is built from the
SRPMs of RHEL), or any other of the big ones.  Or go with some *BSD.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"We are who we choose to be", sang the goldfinch
when the sun is high (Sandman)

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

0
alvherre
2/2/2004 11:11:48 AM
On Mon, 2004-02-02 at 22:11, Alvaro Herrera wrote:
> On Mon, Feb 02, 2004 at 04:22:29PM +1100, Stephen Robert Norris wrote:
> > On Fri, 2004-01-30 at 13:04, Alvaro Herrera wrote:
> > > On Thu, Jan 29, 2004 at 08:50:47PM -0500, Manuel Tejada wrote:
> > > 
> > > > By the way, what does mean RHEL3?
> > > 
> > > "Red Hat Entreprise Linux", a commercial Linux distribution (meaning you
> > > shouldn't use it unless you pay for it).
> > 
> > No, it means you won't get support unless you pay for it, and if you get
> > support for a single machine in your organisation using RHEL, you must
> > get support for all of them.
> 
> It's exactly the same thing.  Using an unsupported operating system is
> only a matter of time before some cracker 0wnz j00.  Of course, you
> could build your own security updates, but it will be a very expensive
> thing to do.  In this situation one should really consider switching to
> another distribution, like, say, White Box (which is built from the
> SRPMs of RHEL), or any other of the big ones.  Or go with some *BSD.

Huh? Or just use Fedora Core, which is what the consumer grade RedHat
distro has become...

-- 
Stephen Norris	  srn@fn.com.au
Farrow Norris Pty Ltd	+61 417 243 239


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

0
srn
2/2/2004 11:42:42 AM
On Mon, Feb 02, 2004 at 10:42:42PM +1100, Stephen Robert Norris wrote:
> On Mon, 2004-02-02 at 22:11, Alvaro Herrera wrote:
> > On Mon, Feb 02, 2004 at 04:22:29PM +1100, Stephen Robert Norris wrote:
> > > On Fri, 2004-01-30 at 13:04, Alvaro Herrera wrote:
> > > > 
> > > > "Red Hat Entreprise Linux", a commercial Linux distribution (meaning you
> > > > shouldn't use it unless you pay for it).
[...]

> Huh? Or just use Fedora Core, which is what the consumer grade RedHat
> distro has become...

But Fedora is very much a desktop linux distribution -- I wouldn't bet a
server on it.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
La web junta la gente porque no importa que clase de mutante sexual seas,
tienes millones de posibles parejas. Pon "buscar gente que tengan sexo con
ciervos incendi�nse", y el computador dir� "especifique el tipo de ciervo"
(Jason Alexander)

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

0
alvherre
2/2/2004 2:59:04 PM
El Lun 02 Feb 2004 11:59, Alvaro Herrera escribi�:
> On Mon, Feb 02, 2004 at 10:42:42PM +1100, Stephen Robert Norris wrote:
> [...]
>
> > Huh? Or just use Fedora Core, which is what the consumer grade RedHat
> > distro has become...
>
> But Fedora is very much a desktop linux distribution -- I wouldn't bet a
> server on it.

Why not? I don' t see much difference from other distributions, and at the 
end, if you want a real server you have to go through all the configuration 
to make sure it's going to have good performaces.

I have a par already installed. :-)

-- 
 12:03:01 up 68 days, 18:19,  3 users,  load average: 0.92, 0.48, 0.34
-----------------------------------------------------------------
Mart�n Marqu�s        | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral
-----------------------------------------------------------------


---------------------------(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

0
martin
2/2/2004 3:04:49 PM
On Mon, Feb 02, 2004 at 12:04:49PM -0300, Martin Marques wrote:
> El Lun 02 Feb 2004 11:59, Alvaro Herrera escribi�:

> > But Fedora is very much a desktop linux distribution -- I wouldn't bet a
> > server on it.
> 
> Why not? I don' t see much difference from other distributions, and at the 
> end, if you want a real server you have to go through all the configuration 
> to make sure it's going to have good performaces.

Fedora Core releases have too short a lifetime, by definition.  You
don't want to be upgrading your servers every 6 months, do you?  I'd
prefer something that gives me some more time before I have to consider
it obsolete.  RHEL is a good example; I think they give you 3 years, 5
for RHAS (is this right?).  Debian, Mandrake, FreeBSD o OpenBSD give me
a lot more confidence than FC because of this.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Si no sabes adonde vas, es muy probable que acabes en otra parte.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

0
alvherre
2/2/2004 5:47:17 PM
El Lun 02 Feb 2004 14:47, Alvaro Herrera escribi�:
> On Mon, Feb 02, 2004 at 12:04:49PM -0300, Martin Marques wrote:
> > Why not? I don' t see much difference from other distributions, and at the 
> > end, if you want a real server you have to go through all the 
configuration 
> > to make sure it's going to have good performaces.
> 
> Fedora Core releases have too short a lifetime, by definition.  You
> don't want to be upgrading your servers every 6 months, do you?  I'd
> prefer something that gives me some more time before I have to consider
> it obsolete.  RHEL is a good example; I think they give you 3 years, 5
> for RHAS (is this right?).  Debian, Mandrake, FreeBSD o OpenBSD give me
> a lot more confidence than FC because of this.

Well, one thing is for sure: It has to short of a life time. :-)

Anyway, even if they did say that the intention was to have three releases a 
year, I can't imagine them even been able to make two. FC1 came by beginning 
of November, and even if they have said there will be a second release in 
May, I doubt they are going to make it before July.

Anyway I have to see how the upgrades perform, because depending on that is 
how bad an idea it is to upgrade each 6 months (RedHat had some bad upgrade 
issues in the past).

-- 
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Mart�n Marqu�s          |   Programador, DBA
Centro de Telem�tica	|     Administrador
               Universidad Nacional
                    del Litoral
---------------------------------------------------------


---------------------------(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

0
martin
2/2/2004 6:10:27 PM
Reply:

Web resources about - I can't upgrade to PostgreSQL 7.4 in RedHat 9.0 - comp.postgresql.general

PostgreSQL - Wikipedia, the free encyclopedia
9.4.1 / February 5, 2015 ; 2 months ago ( 2015-02-05 ) PostgreSQL , often simply "Postgres" , is an object-relational database management system ...

PostgreSQL: The world's most advanced open source database
The official site for PostgreSQL, the world's most advanced open source database

PostgreSQL database fixes “persistent denial-of-service” bug
Maintainers of the PostgreSQL open-source database have patched a vulnerability that allowed attackers to corrupt files and in some cases, execute ...

PostgreSQL dump/restore and client_encoding
... master, then I tried to load the dump via psql into a newly created database on the new master. However, the client_encoding parameter in postgresql.conf ...

postgresql
Read all 'postgresql' posts on .

Updated PostgreSQL targets NoSQL market
Embracing the widely used JSON data-exchange format, the new version of the PostgreSQL open-source database takes aim at the growing NoSQL market ...

French govt to use PostgreSQL, LibreOffice in free software adoption push - ComputerworldUK.com
... to ministers, while software giants Microsoft and Oracle might lose out as the government pushes free software such as LibreOffice or PostgreSQL ...

EnterpriseDB: Federal Agencies Turn to PostgreSQL to Cut Costs
EnterpriseDB announced that U.S. government agencies are moving to Postgres to cut costs as federal budgets tighten.

Postgresql JDBC · GitHub
Build software better, together.

PostgreSQL Now Available On Amazon’s Relational Database Service - TechCrunch
Amazon Web Services (AWS) launched PostgreSQL on Amazon RDS, showing the strength of the open-source database and its market maturity. CTO Werner ...

Resources last updated: 1/28/2016 10:15:54 AM