pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow can i keep my databases when installing PostgreSQL ?
2+ messages / 2 participants
[nested] [flat]
* How can i keep my databases when installing PostgreSQL ?
@ 2015-02-22 10:08 Josef Springer <Josef.Springer@joops.com>
2015-02-22 14:27 ` Re: How can i keep my databases when installing PostgreSQL ? Kevin Grittner <kgrittn@ymail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Josef Springer @ 2015-02-22 10:08 UTC (permalink / raw)
To: pgsql-admin
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#ffffff">
Hello everybody,<br>
<br>
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<br>
"Fehler 1053 Der Dienst antwortet nicht auf die Start oder
Steueranweisung"<br>
<br>
What is the doing to preserve existing databases, when reinstalling
PostgreSQL ?<br>
<br>
Can anybody help me ?<br>
<br>
Best regards,<br>
<div class="moz-signature">
<title>Signature</title>
<p>Josef Springer<br>
</p>
<br>
</div>
</body>
</html>
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How can i keep my databases when installing PostgreSQL ?
2015-02-22 10:08 How can i keep my databases when installing PostgreSQL ? Josef Springer <Josef.Springer@joops.com>
@ 2015-02-22 14:27 ` Kevin Grittner <kgrittn@ymail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2015-02-22 14:27 UTC (permalink / raw)
To: Josef Springer <Josef.Springer@joops.com>; pgsql-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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-02-22 14:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-02-22 10:08 How can i keep my databases when installing PostgreSQL ? Josef Springer <Josef.Springer@joops.com>
2015-02-22 14:27 ` Kevin Grittner <kgrittn@ymail.com>
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