Search Postgresql Archives

Re: Help me recovery databases.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you very much.
 
Well done.
 
Backups it's all))
 
 
01.06.2015, 03:05, "Melvin Davidson" <melvin6925@xxxxxxxxx>:
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.

1. If your data directory is corrupted or still exists, rename it.
2. Make copies of your postgresql.conf & pg_hba.conf if you still have them.
3. use initdb to recreate the data directory
4. Start PostgreSQL and create the database(s) you need
5, Restore your data from pg_dumpall or pg_dump's.
6. If step 5 works, replace the new pg_hba.conf with the old copy if you have it.

On Sun, May 31, 2015 at 7:38 PM, Tomas Vondra <tomas.vondra@xxxxxxxxxxxxxxx> wrote:
"base" is where all the data files are located, so the answer is most likely 'no'.

On 05/31/15 15:11, Evi-M wrote:
Good day, Anyone.
I lost folders with /base
pg_xlog and pg_clog mount another hard disk.(500gb)
This is Postgresql 9.1, Ubuntu 12.04
Could i restore databases without /base?
I have archive_status folder.
--
С Уважением,Генералов Юрий

--
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
 
 
--
www.help-tec.ru
www.хелп-тек.рф
С Уважением,Генералов Юрий
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux