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@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 Davidson
I reserve the right to fantasize.š Whether or not you
wish to share my fantasy is entirely up to you.