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