Skip site navigation (1) Skip section navigation (2)

Re: rescue databases after upgrade?

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
To: test(at)fredens(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: rescue databases after upgrade?
Date: 2005-01-13 08:33:49
Message-ID: Pine.LNX.4.61.0501131022490.9891@emo.org.tr (view raw or flat)
Thread:
Lists: pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Wed, 12 Jan 2005 test(at)fredens(dot)net wrote:

> Hi, i was running sql-ledger on redhat 9, then I upgraded to fedora core 3
> and postgresql 7.4.6.
>
> Now there's an error message saying "you need to upgrade data format
> before using postgresql"
>
> On webpages like
>
> http://www.postgresql.org/docs/7.4/static/install-upgrading.html
>
> There's advice how to backup databases and then upgrade postgresql, but is
> the procedure the same when postgresql already has been upgraded, or is
> there a special "rescue" procedure ?

Our RPM sets have a README.rpm-dist file. It says:

"The old server subpackage must be removed first, the new package
installed, and the data restored from dump."

So... I think you should do the following:

* Backup your data directory (In case of emergency)
* Uninstall existing RPMs and install the RPMs which matches your previous 
version on Red Hat 9 (7.3.8 RPMs for Fedore Core 3 are available on any 
FTP mirrors of PostgreSQL). 
* Start PostgreSQL service.
* Under normal conditions, you should be able to access your datas.
* Run pg_dump and get a full backup of your database.
* Remove PostgreSQL rpms.
* Remove data directory.
* Install new set of RPMs.
* Start PostgreSQL service and restore your backup to 7.4.6.

Regards,
- --
Devrim GUNDUZ 
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com                         http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFB5jJvtl86P3SPfQ4RAieZAJ44T3ftdsVunk3GxnxoDSj+usehKgCggdt+
FQqk10qGPsyvps/DyV9/5yA=
=waq2
-----END PGP SIGNATURE-----

In response to

pgsql-novice by date

Next:From: przygodaDate: 2005-01-13 13:32:54
Subject: Common question: what's wrong
Previous:From: Aarni RuuhimäkiDate: 2005-01-13 08:02:45
Subject: Re: pgadmin III in linux -where are the installed files located?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group