Re: [GENERAL] Help me recovery databases.

2015-06-01 Thread Evi-M
Thank you very much. Well done. Backups it's all))  01.06.2015, 03:05, "Melvin Davidson" melvin6...@gmail.com: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 directory4. Start PostgreSQL and create the database(s) you need5, 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.von...@2ndquadrant.com 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Melvin DavidsonI reserve the right to fantasize.  Whether or not you  wish to share my fantasy is entirely up to you.   -- www.help-tec.ruwww.хелп-тек.рфС Уважением,Генералов Юрий 

[GENERAL] Help me recovery databases.

2015-05-31 Thread Evi-M
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.  -- С Уважением,Генералов Юрий