-----BEGIN PGP SIGNED MESSAGE-----
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
> 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.
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
-----END PGP SIGNATURE-----
In response to
pgsql-novice by date
|Next:||From: przygoda||Date: 2005-01-13 13:32:54|
|Subject: Common question: what's wrong|
|Previous:||From: Aarni Ruuhimäki||Date: 2005-01-13 08:02:45|
|Subject: Re: pgadmin III in linux -where are the installed files located?|