Date: Sun, 22 Feb 2015 14:27:25 +0000 (UTC)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
To: Josef Springer <Josef.Springer@joops.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Message-ID: <217776053.3846435.1424615245759.JavaMail.yahoo@mail.yahoo.com>
In-Reply-To: <54E9AAA5.1000705@joops.com>
References: <54E9AAA5.1000705@joops.com>
Subject: Re: How can i keep my databases when installing PostgreSQL
 ?
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Length: 1239
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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