[GENERAL] Updating 9.0.4 -- 9.1.1: How best to ???

[r d]

Hi,

I would like to know which if any is a recommended install and upgrade
method.

My situation is summarized as:

I currently have Postgresql 9.0.4 installed via the Fedora Core FC15 yum
repo, and 9.1.x is not there (yet).

I decided to install the PGDG repo (pgdg-fedora91-9.1-5.noarch) to make it
update. It does not.

The FC15 packages are called postgresql_* and not postgresql90_*, the
PGDG packages are called postgresql91_*.


Since both repositories apparently get into each others way, my question is,
what is the best (recommended) way to update or install postgres:

- Dump my FC15 installation and replace it with one coming from the PGDG
repo?
- Wait for the 9.1 packages to appear in the Fedora Core repo?

I prefer install from repo as there is currently no reason for me to install
from source.

Thanks in advance,

RD

Re: [GENERAL] Updating 9.0.4 -- 9.1.1: How best to ???

[Devrim GÜNDÜZ]

Hi,

On Sun, 2011-10-02 at 12:41 +0200, r d wrote:
 
 I decided to install the PGDG repo (pgdg-fedora91-9.1-5.noarch) to
 make it update. It does not.

Fedora/Red Hat distro RPMs a only binary compatible since last year. I
broke package compatibility by enabling multiple version installation.

 The FC15 packages are called postgresql_* and not postgresql90_*,
 the PGDG packages are called postgresql91_*.

See above.

 Since both repositories apparently get into each others way, my
 question is, what is the best (recommended) way to update or install
 postgres:
 
 - Dump my FC15 installation and replace it with one coming from the
 PGDG repo?

This might be one of the options. However, as compared to Fedora RPMs,
we don't offer upgrade path. Fedora RPMs have a 

service (or systemctl... whatever) postgresql upgrade

option. So, an upgrade path could be:

* Replace current packages with PGDG packages. Please note that data
directory of 9.0 will be under /var/lib/pgsql/9.0, not /var/lib/pgsql.

* Make sure that db is working.

* Now, install 9.1 in parallel.

* Perform upgrade using pg_upgrade or pg_dump.

* Start 9.1

 - Wait for the 9.1 packages to appear in the Fedora Core repo? 

Fedora will release 9.1 in F-16. Fedora 15 won't have 9.1.

Regards,

-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part