Lists: | pgsql-general |
---|
From: | Jerry LeVan <jerry(dot)levan(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Installing Fedora 15 hosed my db... |
Date: | 2011-06-16 19:01:30 |
Message-ID: | 1308250892.27308.9.camel@bigbox.skynet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Yesterday I upgraded from fedora 14 to fedora 15...
The install process sorta trashed my 8.4 db...here is
what I have:
postgresql-server-9.0.4-1.fc15.i686
postgresql-pltcl-8.4.4-1PGDG.fc12.i386
postgresql-docs-8.4.4-1PGDG.fc12.i386
postgresql-libs-9.0.4-1.fc15.i686
postgresql-contrib-8.4.4-1PGDG.fc12.i386
postgresql-9.0.4-1.fc15.i686
postgresql-plpython-8.4.4-1PGDG.fc12.i386
postgresql-devel-8.4.4-1PGDG.fc12.i386
I have a couple of other machines that that contain the
db so I could do a pg_dumpall to get something to stuff
into my db at the appropriate time.
I would like to upgrade to 9.0.4...
I could not find the contrib module for 9.0.4 module in yumex. I really
need the dbink tool to keep the dbs on my machines up to date.
Any suggestions on how I can cleanup the mess I created *and* get
a complete 9.0.4 installation?
Thanks,
Jerry
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | jerry(dot)levan(at)gmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Installing Fedora 15 hosed my db... |
Date: | 2011-06-16 20:05:03 |
Message-ID: | 8901.1308254703@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Jerry LeVan <jerry(dot)levan(at)gmail(dot)com> writes:
> Yesterday I upgraded from fedora 14 to fedora 15...
> The install process sorta trashed my 8.4 db...here is
> what I have:
> postgresql-server-9.0.4-1.fc15.i686
> postgresql-pltcl-8.4.4-1PGDG.fc12.i386
> postgresql-docs-8.4.4-1PGDG.fc12.i386
> postgresql-libs-9.0.4-1.fc15.i686
> postgresql-contrib-8.4.4-1PGDG.fc12.i386
> postgresql-9.0.4-1.fc15.i686
> postgresql-plpython-8.4.4-1PGDG.fc12.i386
> postgresql-devel-8.4.4-1PGDG.fc12.i386
> Any suggestions on how I can cleanup the mess I created *and* get
> a complete 9.0.4 installation?
Well, you could
(1) remove all the PGDG RPMs,
(2) install the regular Fedora postgresql RPMs,
including postgresql-upgrade
(3) run "service postgresql upgrade"
(I haven't actually tested postgresql-upgrade in the context of
upgrading from 8.4 PGDG RPMs instead of the regular Fedora ones, but
in theory it should work. As always, a filesystem backup of your
database is a good thing to have in case of disaster.)
regards, tom lane
From: | Jerry LeVan <jerry(dot)levan(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Installing Fedora 15 hosed my db... |
Date: | 2011-06-16 20:29:13 |
Message-ID: | 1308256156.9646.16.camel@bigbox.skynet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Thu, 2011-06-16 at 16:05 -0400, Tom Lane wrote:
> Jerry LeVan <jerry(dot)levan(at)gmail(dot)com> writes:
> > Yesterday I upgraded from fedora 14 to fedora 15...
> > The install process sorta trashed my 8.4 db...here is
> > what I have:
> > postgresql-server-9.0.4-1.fc15.i686
> > postgresql-pltcl-8.4.4-1PGDG.fc12.i386
> > postgresql-docs-8.4.4-1PGDG.fc12.i386
> > postgresql-libs-9.0.4-1.fc15.i686
> > postgresql-contrib-8.4.4-1PGDG.fc12.i386
> > postgresql-9.0.4-1.fc15.i686
> > postgresql-plpython-8.4.4-1PGDG.fc12.i386
> > postgresql-devel-8.4.4-1PGDG.fc12.i386
>
> > Any suggestions on how I can cleanup the mess I created *and* get
> > a complete 9.0.4 installation?
>
> Well, you could
> (1) remove all the PGDG RPMs,
> (2) install the regular Fedora postgresql RPMs,
> including postgresql-upgrade
> (3) run "service postgresql upgrade"
>
> (I haven't actually tested postgresql-upgrade in the context of
> upgrading from 8.4 PGDG RPMs instead of the regular Fedora ones, but
> in theory it should work. As always, a filesystem backup of your
> database is a good thing to have in case of disaster.)
> regards, tom lane
Oh snap!
I had excluded postgresql from the fedora repo because I had been using
pgdg repo.
When I enabled postgresql in the repo all of the missing rpms magically
appeared in the yumex update section :0
Jerry