pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
install 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>
  2005-10-19 15:59 ` Re: install new version of Redhat  without deleting Scott Marlowe <smarlowe@g2switchworks.com>
  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>
  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: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 ` Scott Marlowe <smarlowe@g2switchworks.com>
  2005-10-19 16:57   ` Re: install new version of Redhat  without deleting 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
  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   ` FM <dist-list@LEXUM.UMontreal.CA>
  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

* Re: install new version of Redhat without deleting /var/lib/pgsql ? Is it enough ?
  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 16:22 ` Dario <dario_d_s@unitech.com.ar>
  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


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