From: Kevin Grittner <kgrittn@ymail.com>
To: Josef Springer <Josef.Springer@joops.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: How can i keep my databases when installing PostgreSQL ?
Date: Sun, 22 Feb 2015 14:27:25 +0000 (UTC)
Message-ID: <217776053.3846435.1424615245759.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <54E9AAA5.1000705@joops.com>
References: <54E9AAA5.1000705@joops.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Josef Springer <Josef.Springer@joops.com> wrote:
> i must reinstall PostgreSQL, because the installed server does not
> work anymore. Because of lost disk sectors the server can not be
> started in the system-services GUI. The result of the starting
> request is
> "Fehler 1053 Der Dienst antwortet nicht auf die Start oder
> Steueranweisung"
>
> What is the doing to preserve existing databases, when reinstalling
> PostgreSQL ?
First, copy the data directory tree to some safe medium.
https://wiki.postgresql.org/wiki/Corruption
The exact steps required after installing new software are going to
vary somewhat depending on the OS and the installer used. Once the
software is there you will either need to set up a service script
pointing to the data directory or copy the data directory in place
of what the installer sets up.
Once you are able to start the database service, I would recommend
that you immediately pg_dump of all databases and restore them to a
freshly created cluster. I would only put that new cluster on the
old machine if I was confident that the cause of the storage
failure had been found and fixed.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kgrittn@ymail.com, Josef.Springer@joops.com
Subject: Re: How can i keep my databases when installing PostgreSQL ?
In-Reply-To: <217776053.3846435.1424615245759.JavaMail.yahoo@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox