Обсуждение: Core 5 Upgrade
I forgot to dump before I upgraded to Fedora Core 5 (Postgresql 8.0.x to 8.1.x). Is there an easy way to bring up an 8.0.x server long enough to dump the data? -- http://yosemitephotos.net/
Hi, On Sat, 2006-03-25 at 20:46 +0000, Rick Ellis wrote: > I forgot to dump before I upgraded to Fedora Core 5 (Postgresql > 8.0.x to 8.1.x). Is there an easy way to bring up an 8.0.x server > long enough to dump the data? Do a source 8.0 installation, and start pg_ctl with /var/lib/pgsql/data. Dump your data, and then stop existing postmaster, and go on with the upgrade. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
In article <1143322011.3974.10.camel@evim.gunduz.org>, Devrim GUNDUZ <devrim@commandprompt.com> wrote: >Do a source 8.0 installation, and start pg_ctl with >/var/lib/pgsql/data. Dump your data, and then stop existing >postmaster, and go on with the upgrade. I was afraid you'd say that :) But it worked. Thanks. -- http://yosemitenews.info/
On Sat, 2006-03-25 at 23:26 +0200, Devrim GUNDUZ wrote: > Hi, > > On Sat, 2006-03-25 at 20:46 +0000, Rick Ellis wrote: > > I forgot to dump before I upgraded to Fedora Core 5 (Postgresql > > 8.0.x to 8.1.x). Is there an easy way to bring up an 8.0.x server > > long enough to dump the data? > > Do a source 8.0 installation, and start pg_ctl with /var/lib/pgsql/data. > Dump your data, and then stop existing postmaster, and go on with the > upgrade. > > Regards, I have a similar problem. Had FC4 and PostgresQL installed. Upgraded to FC5, and want to use PostgresQL for a bugzilla backend. My problem is the same as the parent poster, but rather then save my old data I want to delete it. All of it. How would I go about doing that? AmadeusZ.-
Amadeus Zilfinski <amadeus0@cox.net> writes:
> I have a similar problem. Had FC4 and PostgresQL installed. Upgraded to
> FC5, and want to use PostgresQL for a bugzilla backend. My problem is
> the same as the parent poster, but rather then save my old data I want
> to delete it. All of it. How would I go about doing that?
Just rm -rf /var/lib/pgsql/data ... then you can start the new postmaster.
regards, tom lane
On Mon, 2006-03-27 at 20:22 -0500, Tom Lane wrote: > Amadeus Zilfinski <amadeus0@cox.net> writes: > > I have a similar problem. Had FC4 and PostgresQL installed. Upgraded to > > FC5, and want to use PostgresQL for a bugzilla backend. My problem is > > the same as the parent poster, but rather then save my old data I want > > to delete it. All of it. How would I go about doing that? > > Just rm -rf /var/lib/pgsql/data ... then you can start the new postmaster. > > regards, tom lane Thanks. That did it. Now to get the rest of FC5 up and running... AmadeusZ.-