Re: Help me recovery databases.

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(dot)vondra(at)2ndquadrant(dot)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(at)postgresql(dot)org)
> 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.