Re: Help me recovery databases.

From: Evi-M <79114888805(at)yandex(dot)ru>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help me recovery databases.
Date: 2015-06-01 07:22:37
Message-ID: 1747381433143357@web8g.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<div>Thank you very much.</div><div> </div><div>Well done.</div><div> </div><div>Backups it's all))</div><div> </div><div> </div><div>01.06.2015, 03:05, "Melvin Davidson" &lt;melvin6925(at)gmail(dot)com&gt;:</div><blockquote type="cite"><div><div><div><div><div><div>If you have a pg_dumpall, or a pg_dump of your databases, you "might" be able to get your data back by doing the following.<br /><br /></div>1. If your data directory is corrupted or still exists, rename it.</div><div>2. Make copies of your postgresql.conf &amp; pg_hba.conf if you still have them.</div>3. use initdb to recreate the data directory</div>4. Start PostgreSQL and create the database(s) you need</div>5, Restore your data from pg_dumpall or pg_dump's.</div>6. If step 5 works, replace the new pg_hba.conf with the old copy if you have it.</div><div><br /><div>On Sun, May 31, 2015 at 7:38 PM, Tomas Vondra <span>&lt;<a href="mailto:tomas(dot)vondra(at)2ndquadrant(dot)com" target="_blank">tomas(dot)vondra(at)2ndquadrant(dot)com</a>&gt;</span> wrote:<br /><blockquote style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex;">"base" is where all the data files are located, so the answer is most likely 'no'.<br /> <br /> On 05/31/15 15:11, Evi-M wrote:<br /><blockquote style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex;">Good day, Anyone.<br /> I lost folders with /base<br /> pg_xlog and pg_clog mount another hard disk.(500gb)<br /> This is Postgresql 9.1, Ubuntu 12.04<br /> Could i restore databases without /base?<br /> I have archive_status folder.<br /> --<br /> С Уважением,Генералов Юрий</blockquote><br /> --<br /> Tomas Vondra                  <a href="http://www.2ndQuadrant.com/" target="_blank">http://www.2ndQuadrant.com</a><br /> PostgreSQL Development, 24x7 Support, Remote DBA, Training &amp; Services<span><font color="#888888"><br /> <br /> <br /> -- <br /> Sent via pgsql-general mailing list (<a href="mailto:pgsql-general(at)postgresql(dot)org" target="_blank">pgsql-general(at)postgresql(dot)org</a>)<br /> To make changes to your subscription:<br /> <a href="http://www.postgresql.org/mailpref/pgsql-general" target="_blank">http://www.postgresql.org/mailpref/pgsql-general</a><br /> </font></span></blockquote></div><br /><br /><br />-- <br /><div><div><font size="4"><b><span style="font-family:courier new,monospace;">Melvin Davidson</span></b></font><br /><font size="3" style="font-weight:bold;"><span style="color:#8000ff;">I reserve the right to fantasize.  Whether or not you </span><br style="color:#8000ff;" /> <span style="color:#8000ff;">wish to share my fantasy is entirely up to you. </span><img src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif" style="color:#8000ff;" /></font></div></div></div></blockquote><div> </div><div> </div><div>-- <br />www.help-tec.ru</div><div>www.хелп-тек.рф</div><div>С Уважением,Генералов Юрий</div><div> </div>

Attachment Content-Type Size
unknown_filename text/html 2.8 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sven R. Kunze 2015-06-01 07:25:18 Re: [to_tsvector] German Compound Words
Previous Message Noah Misch 2015-06-01 04:55:34 Re: [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1