pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedinstall new version of Redhat without deleting /var/lib/pgsql ? Is it enough ?
4+ messages / 3 participants
[nested] [flat]
* install new version of Redhat without deleting /var/lib/pgsql ? Is it enough ?
@ 2005-10-19 15:47 FM <dist-list@LEXUM.UMontreal.CA>
0 siblings, 2 replies; 4+ messages in thread
From: FM @ 2005-10-19 15:47 UTC (permalink / raw)
To: pgsql-admin
Hello erverybody,
I need to install a new version of Redhat on my server.
On the distro, pgsql data are in : /var/lib/pgsql (which is mounted on
its own partition).
Can I "just" install the new version of Redhat, reinstall the same
version of Postgresql (7.4.8) ?
I'll do a pgdump all just in case
Thanks !
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: install new version of Redhat without deleting
@ 2005-10-19 15:59 Scott Marlowe <smarlowe@g2switchworks.com>
parent: FM <dist-list@LEXUM.UMontreal.CA>
1 sibling, 1 reply; 4+ messages in thread
From: Scott Marlowe @ 2005-10-19 15:59 UTC (permalink / raw)
To: FM <dist-list@lexum.umontreal.ca>; +Cc: pgsql-admin
On Wed, 2005-10-19 at 10:47, FM wrote:
> Hello erverybody,
> I need to install a new version of Redhat on my server.
> On the distro, pgsql data are in : /var/lib/pgsql (which is mounted on
> its own partition).
> Can I "just" install the new version of Redhat, reinstall the same
> version of Postgresql (7.4.8) ?
> I'll do a pgdump all just in case
It might work, but there are no guarantees. The two versions basically
need to have been compiled with a few different settings the same, or
the new version won't be able to run on the old versions data
directory. Worth a try though. As long as you have that pg_dump
sitting around.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: install new version of Redhat without deleting /var/lib/pgsql ? Is it enough ?
@ 2005-10-19 16:22 Dario <dario_d_s@unitech.com.ar>
parent: FM <dist-list@LEXUM.UMontreal.CA>
1 sibling, 0 replies; 4+ messages in thread
From: Dario @ 2005-10-19 16:22 UTC (permalink / raw)
To: FM <dist-list@lexum.umontreal.ca>; pgsql-admin
The new version will update your postgresql packages. It shouldn't wipe your data files, since /etc/init.d/postgresql script checks if there are data in the specified directory. Then you must erase those postgresql (rpm -qa|grep postgres will list packages installed), and install yours.
But, if new subversion is the same (example 7._4_.8 and 7._4_.9 but it's and unchecked and probably not real example), the script could run and the engine will run (it won't delete your files).
I would perform a backup anyway.
-----Mensaje original-----
De: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]En nombre de FM
Enviado el: miƩrcoles, 19 de octubre de 2005 12:47
Para: Mailing List Postgres-Admin
Asunto: [ADMIN] install new version of Redhat without deleting
/var/lib/pgsql ? Is it enough ?
Hello erverybody,
I need to install a new version of Redhat on my server.
On the distro, pgsql data are in : /var/lib/pgsql (which is mounted on
its own partition).
Can I "just" install the new version of Redhat, reinstall the same
version of Postgresql (7.4.8) ?
I'll do a pgdump all just in case
Thanks !
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: install new version of Redhat without deleting
@ 2005-10-19 16:57 FM <dist-list@LEXUM.UMontreal.CA>
parent: Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 0 replies; 4+ messages in thread
From: FM @ 2005-10-19 16:57 UTC (permalink / raw)
To: pgsql-admin
I'm usung postgresql.org RPMS so the RPMS will be exactly the same.
Of course I'll do my pgdump before my try.
Thank to you all !
Scott Marlowe wrote:
> On Wed, 2005-10-19 at 10:47, FM wrote:
>
>>Hello erverybody,
>>I need to install a new version of Redhat on my server.
>>On the distro, pgsql data are in : /var/lib/pgsql (which is mounted on
>>its own partition).
>>Can I "just" install the new version of Redhat, reinstall the same
>>version of Postgresql (7.4.8) ?
>>I'll do a pgdump all just in case
>
>
> It might work, but there are no guarantees. The two versions basically
> need to have been compiled with a few different settings the same, or
> the new version won't be able to run on the old versions data
> directory. Worth a try though. As long as you have that pg_dump
> sitting around.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-10-19 16:57 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-19 15:47 install new version of Redhat without deleting /var/lib/pgsql ? Is it enough ? FM <dist-list@LEXUM.UMontreal.CA>
2005-10-19 15:59 ` Re: install new version of Redhat without deleting Scott Marlowe <smarlowe@g2switchworks.com>
2005-10-19 16:57 ` Re: install new version of Redhat without deleting FM <dist-list@LEXUM.UMontreal.CA>
2005-10-19 16:22 ` Re: install new version of Redhat without deleting /var/lib/pgsql ? Is it enough ? Dario <dario_d_s@unitech.com.ar>
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