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" :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 yo

Re: [GENERAL] Help me recovery databases.

2015-05-31 Thread Melvin Davidson
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

Re: [GENERAL] Help me recovery databases.

2015-05-31 Thread Tomas Vondra
"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

[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.  -- С Уважением,Генералов Юрий