pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedredhat Ent3 et postegresql v7.4.3
5+ messages / 4 participants
[nested] [flat]
* redhat Ent3 et postegresql v7.4.3
@ 2004-08-12 12:51 MPaule Torre <torre@obs-vlfr.fr>
2004-08-12 15:51 ` Re: redhat Ent3 et postegresql v7.4.3 Gaetano Mendola <mendola@bigfoot.com>
2004-08-12 17:37 ` Re: redhat Ent3 et postegresql v7.4.3 Uwe C. Schroeder <uwe@oss4u.com>
0 siblings, 2 replies; 5+ messages in thread
From: MPaule Torre @ 2004-08-12 12:51 UTC (permalink / raw)
To: pgsql-admin
Hello everybody
I have a red hat ent.3 operationg system. It has been delivered with
postgresql v7.3.6-1
I would like to use a new stable version : v7.4.3
(server on linux and an ontother PC under windows 2000 to test and develop
: with cygwin => v7.4.3 or v7.4.2 available)
Do you have any information about installing postgresql v7.4.3 rpm on this
redhat ent 3 operating system ? is it working well ?
Do I have to delete the oldest package (rpm too) ?
More thanks in advance
-------------------------------------------------------------------------------------------
TORRE MPaule
Observatoire Oceanologique -OOV
PROOF Base de Données/Web
Quai de la Darse, BP8,Cas. Nicolas
06238 VILLEFRANCHE sur MER
FRANCE
TEL (33)4.93.76.38.77
FAX (33)4.93.76.38.73
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: redhat Ent3 et postegresql v7.4.3
2004-08-12 12:51 redhat Ent3 et postegresql v7.4.3 MPaule Torre <torre@obs-vlfr.fr>
@ 2004-08-12 15:51 ` Gaetano Mendola <mendola@bigfoot.com>
2004-08-12 21:17 ` Re: redhat Ent3 et postegresql v7.4.3 Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 5+ messages in thread
From: Gaetano Mendola @ 2004-08-12 15:51 UTC (permalink / raw)
To: MPaule Torre <torre@obs-vlfr.fr>
MPaule Torre wrote:
> Hello everybody
>
> I have a red hat ent.3 operationg system. It has been delivered with
> postgresql v7.3.6-1
I'd like to know why RH still deliver 7.3.x after almost one year
with the 7.4 around.
Regards
Gaetano Mendola
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: redhat Ent3 et postegresql v7.4.3
2004-08-12 12:51 redhat Ent3 et postegresql v7.4.3 MPaule Torre <torre@obs-vlfr.fr>
2004-08-12 15:51 ` Re: redhat Ent3 et postegresql v7.4.3 Gaetano Mendola <mendola@bigfoot.com>
@ 2004-08-12 21:17 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2004-08-12 21:17 UTC (permalink / raw)
To: Gaetano Mendola <mendola@bigfoot.com>; +Cc: MPaule Torre <torre@obs-vlfr.fr>; pgsql-admin
Gaetano Mendola <mendola@bigfoot.com> writes:
> MPaule Torre wrote:
>> I have a red hat ent.3 operationg system. It has been delivered with
>> postgresql v7.3.6-1
> I'd like to know why RH still deliver 7.3.x after almost one year
> with the 7.4 around.
Because their policy is "no breakage for the lifetime of this product".
RHEL3 will ship with PG 7.3.something for its support lifetime. (Heck,
I'm going to have to fix PG 7.1 for RHAS 2.1 :-(.) If we (PG) had a
transparent update capability across major versions, maybe there would
be some wiggle room, but we don't. I don't get to force RHEL3 customers
through a dump/initdb/reload cycle, no matter how much I'd like to.
Fedora is up to speed with our latest release, but that's a totally
different distribution made with different goals in mind.
regards, tom lane
Red Hat Database project
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: redhat Ent3 et postegresql v7.4.3
2004-08-12 12:51 redhat Ent3 et postegresql v7.4.3 MPaule Torre <torre@obs-vlfr.fr>
@ 2004-08-12 17:37 ` Uwe C. Schroeder <uwe@oss4u.com>
1 sibling, 0 replies; 5+ messages in thread
From: Uwe C. Schroeder @ 2004-08-12 17:37 UTC (permalink / raw)
To: MPaule Torre <torre@obs-vlfr.fr>; pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Usually the RPM's work fine if they're build for that version of operating
system.
What I tend to do is not trust RPM to do the update correctly (particularly
with postgres).
So normally for an upgrade I:
pg_dumpall > backup.dump
shut down the postmaster
make a backup copy of the old data directory (usually /var/lib/pgsql)
do an rpm -e on all postgres and libpq packages.
make sure /var/lib/pgsql is gone now
install the new version from the rpms which should create a complete setup and
also do the initdb for you.
then restore the databases as postgres user with
psql template1 < backup.dump
do a vacuum full analyze verbose on all databases
If that went all well you should have all your data back in place. You may
have to fiddle with the postgres.conf and pg_hba.conf settings, because
removing the old postgres version will also erase those files. So you may
want to keep a copy around for reference.
Hope that helps
UC
On Thursday 12 August 2004 05:51 am, MPaule Torre wrote:
> Hello everybody
>
> I have a red hat ent.3 operationg system. It has been delivered with
> postgresql v7.3.6-1
>
> I would like to use a new stable version : v7.4.3
> (server on linux and an ontother PC under windows 2000 to test and develop
>
> : with cygwin => v7.4.3 or v7.4.2 available)
>
> Do you have any information about installing postgresql v7.4.3 rpm on this
> redhat ent 3 operating system ? is it working well ?
> Do I have to delete the oldest package (rpm too) ?
>
>
> More thanks in advance
>
>
> ---------------------------------------------------------------------------
>---------------- TORRE MPaule
> Observatoire Oceanologique -OOV
> PROOF Base de Données/Web
> Quai de la Darse, BP8,Cas. Nicolas
> 06238 VILLEFRANCHE sur MER
> FRANCE
> TEL (33)4.93.76.38.77
> FAX (33)4.93.76.38.73
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
- --
UC
- --
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax: +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQFBG6rmjqGXBvRToM4RAusjAKCdWQUpxNd5aZsdavUhzw8h7hua1ACdH7t6
ojvcu1GTOIIC3VA/bkhYyMw=
=eib4
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 5+ messages in thread
* redhat Ent3 et postegresql v7.4.3
@ 2004-08-13 08:32 MPaule Torre <torre@obs-vlfr.fr>
0 siblings, 0 replies; 5+ messages in thread
From: MPaule Torre @ 2004-08-13 08:32 UTC (permalink / raw)
To: pgsql-admin
More thanks to everybody for your advises.
I will download the version rpm on the ftp10us web site.
I appreciate your help
I wanted to specified :
- I am on redhaten3 for one year because I did not know what will be fedora
- My database is a new one , so there is no problem with dumping
Thank you very much !
MPaule
-------------------------------------------------------------------------------------------
TORRE MPaule
Observatoire Oceanologique -OOV
PROOF Base de Données/Web
Quai de la Darse, BP8,Cas. Nicolas
06238 VILLEFRANCHE sur MER
FRANCE
TEL (33)4.93.76.38.77
FAX (33)4.93.76.38.73
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-08-13 08:32 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-12 12:51 redhat Ent3 et postegresql v7.4.3 MPaule Torre <torre@obs-vlfr.fr>
2004-08-12 15:51 ` Gaetano Mendola <mendola@bigfoot.com>
2004-08-12 21:17 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-08-12 17:37 ` Uwe C. Schroeder <uwe@oss4u.com>
2004-08-13 08:32 redhat Ent3 et postegresql v7.4.3 MPaule Torre <torre@obs-vlfr.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox