Обсуждение: Help me recovery databases.
Good day, Anyone.I lost folders with /basepg_xlog and pg_clog mount another hard disk.(500gb)This is Postgresql 9.1,Ubuntu 12.04Could i restore databases without /base?I have archive_status folder.--ó õ×ÁÖÅÎÉÅÍ,çÅÎÅÒÁÌÏ× àÒÉÊ
"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
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.![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
PGRpdj5UaGFuayB5b3UgdmVyeSBtdWNoLjwvZGl2PjxkaXY+mjwvZGl2PjxkaXY+V2VsbCBkb25l LjwvZGl2PjxkaXY+mjwvZGl2PjxkaXY+QmFja3VwcyBpdCdzIGFsbCkpPC9kaXY+PGRpdj6aPC9k aXY+PGRpdj6aPC9kaXY+PGRpdj4wMS4wNi4yMDE1LCAwMzowNSwgIk1lbHZpbiBEYXZpZHNvbiIg Jmx0O21lbHZpbjY5MjVAZ21haWwuY29tJmd0Ozo8L2Rpdj48YmxvY2txdW90ZSB0eXBlPSJjaXRl Ij48ZGl2PjxkaXY+PGRpdj48ZGl2PjxkaXY+PGRpdj5JZiB5b3UgaGF2ZSBhIHBnX2R1bXBhbGws IG9yIGEgcGdfZHVtcCBvZiB5b3VyIGRhdGFiYXNlcywgeW91ICJtaWdodCIgYmUgYWJsZSB0byBn ZXQgeW91ciBkYXRhIGJhY2sgYnkgZG9pbmcgdGhlIGZvbGxvd2luZy48YnIgLz48YnIgLz48L2Rp dj4xLiBJZiB5b3VyIGRhdGEgZGlyZWN0b3J5IGlzIGNvcnJ1cHRlZCBvciBzdGlsbCBleGlzdHMs IHJlbmFtZSBpdC48L2Rpdj48ZGl2PjIuIE1ha2UgY29waWVzIG9mIHlvdXIgcG9zdGdyZXNxbC5j b25mICZhbXA7IHBnX2hiYS5jb25mIGlmIHlvdSBzdGlsbCBoYXZlIHRoZW0uPC9kaXY+My4gdXNl IGluaXRkYiB0byByZWNyZWF0ZSB0aGUgZGF0YSBkaXJlY3Rvcnk8L2Rpdj40LiBTdGFydCBQb3N0 Z3JlU1FMIGFuZCBjcmVhdGUgdGhlIGRhdGFiYXNlKHMpIHlvdSBuZWVkPC9kaXY+NSwgUmVzdG9y ZSB5b3VyIGRhdGEgZnJvbSBwZ19kdW1wYWxsIG9yIHBnX2R1bXAncy48L2Rpdj42LiBJZiBzdGVw IDUgd29ya3MsIHJlcGxhY2UgdGhlIG5ldyBwZ19oYmEuY29uZiB3aXRoIHRoZSBvbGQgY29weSBp ZiB5b3UgaGF2ZSBpdC48L2Rpdj48ZGl2PjxiciAvPjxkaXY+T24gU3VuLCBNYXkgMzEsIDIwMTUg YXQgNzozOCBQTSwgVG9tYXMgVm9uZHJhIDxzcGFuPiZsdDs8YSBocmVmPSJtYWlsdG86dG9tYXMu dm9uZHJhQDJuZHF1YWRyYW50LmNvbSIgdGFyZ2V0PSJfYmxhbmsiPnRvbWFzLnZvbmRyYUAybmRx dWFkcmFudC5jb208L2E+Jmd0Ozwvc3Bhbj4gd3JvdGU6PGJyIC8+PGJsb2NrcXVvdGUgc3R5bGU9 Im1hcmdpbjowIDAgMCAwLjhleDtib3JkZXItbGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxl ZnQ6MWV4OyI+ImJhc2UiIGlzIHdoZXJlIGFsbCB0aGUgZGF0YSBmaWxlcyBhcmUgbG9jYXRlZCwg c28gdGhlIGFuc3dlciBpcyBtb3N0IGxpa2VseSAnbm8nLjxiciAvPiA8YnIgLz4gT24gMDUvMzEv MTUgMTU6MTEsIEV2aS1NIHdyb3RlOjxiciAvPjxibG9ja3F1b3RlIHN0eWxlPSJtYXJnaW46MCAw IDAgMC44ZXg7Ym9yZGVyLWxlZnQ6MXB4ICNjY2Mgc29saWQ7cGFkZGluZy1sZWZ0OjFleDsiPkdv b2QgZGF5LCBBbnlvbmUuPGJyIC8+IEkgbG9zdCBmb2xkZXJzIHdpdGggL2Jhc2U8YnIgLz4gcGdf eGxvZyBhbmQgcGdfY2xvZyBtb3VudCBhbm90aGVyIGhhcmQgZGlzay4oNTAwZ2IpPGJyIC8+IFRo aXMgaXMgUG9zdGdyZXNxbCA5LjEsIFVidW50dSAxMi4wNDxiciAvPiBDb3VsZCBpIHJlc3RvcmUg ZGF0YWJhc2VzIHdpdGhvdXQgL2Jhc2U/PGJyIC8+IEkgaGF2ZSBhcmNoaXZlX3N0YXR1cyBmb2xk ZXIuPGJyIC8+IC0tPGJyIC8+IPMg9dfB1sXOycXNLOfFzsXSwczP1yDg0snKPC9ibG9ja3F1b3Rl PjxiciAvPiAtLTxiciAvPiBUb21hcyBWb25kcmGaIJogmiCaIJogmiCaIJogmiA8YSBocmVmPSJo dHRwOi8vd3d3LjJuZFF1YWRyYW50LmNvbS8iIHRhcmdldD0iX2JsYW5rIj5odHRwOi8vd3d3LjJu ZFF1YWRyYW50LmNvbTwvYT48YnIgLz4gUG9zdGdyZVNRTCBEZXZlbG9wbWVudCwgMjR4NyBTdXBw b3J0LCBSZW1vdGUgREJBLCBUcmFpbmluZyAmYW1wOyBTZXJ2aWNlczxzcGFuPjxmb250IGNvbG9y PSIjODg4ODg4Ij48YnIgLz4gPGJyIC8+IDxiciAvPiAtLSA8YnIgLz4gU2VudCB2aWEgcGdzcWwt Z2VuZXJhbCBtYWlsaW5nIGxpc3QgKDxhIGhyZWY9Im1haWx0bzpwZ3NxbC1nZW5lcmFsQHBvc3Rn cmVzcWwub3JnIiB0YXJnZXQ9Il9ibGFuayI+cGdzcWwtZ2VuZXJhbEBwb3N0Z3Jlc3FsLm9yZzwv YT4pPGJyIC8+IFRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjo8YnIgLz4gPGEg aHJlZj0iaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1nZW5lcmFsIiB0 YXJnZXQ9Il9ibGFuayI+aHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1n ZW5lcmFsPC9hPjxiciAvPiA8L2ZvbnQ+PC9zcGFuPjwvYmxvY2txdW90ZT48L2Rpdj48YnIgLz48 YnIgLz48YnIgLz4tLSA8YnIgLz48ZGl2PjxkaXY+PGZvbnQgc2l6ZT0iNCI+PGI+PHNwYW4gc3R5 bGU9ImZvbnQtZmFtaWx5OmNvdXJpZXIgbmV3LG1vbm9zcGFjZTsiPk1lbHZpbiBEYXZpZHNvbjwv c3Bhbj48L2I+PC9mb250PjxiciAvPjxmb250IHNpemU9IjMiIHN0eWxlPSJmb250LXdlaWdodDpi b2xkOyI+PHNwYW4gc3R5bGU9ImNvbG9yOiM4MDAwZmY7Ij5JIHJlc2VydmUgdGhlIHJpZ2h0IHRv IGZhbnRhc2l6ZS6aIFdoZXRoZXIgb3Igbm90IHlvdSA8L3NwYW4+PGJyIHN0eWxlPSJjb2xvcjoj ODAwMGZmOyIgLz4gPHNwYW4gc3R5bGU9ImNvbG9yOiM4MDAwZmY7Ij53aXNoIHRvIHNoYXJlIG15 IGZhbnRhc3kgaXMgZW50aXJlbHkgdXAgdG8geW91LiA8L3NwYW4+PGltZyBzcmM9Imh0dHA6Ly91 cy5pMS55aW1nLmNvbS91cy55aW1nLmNvbS9pL21lc2cvdHNtaWxleXMyLzAxLmdpZiIgc3R5bGU9 ImNvbG9yOiM4MDAwZmY7IiAvPjwvZm9udD48L2Rpdj48L2Rpdj48L2Rpdj48L2Jsb2NrcXVvdGU+ PGRpdj6aPC9kaXY+PGRpdj6aPC9kaXY+PGRpdj4tLSA8YnIgLz53d3cuaGVscC10ZWMucnU8L2Rp dj48ZGl2Pnd3dy7IxczQLdTFyy7SxjwvZGl2PjxkaXY+8yD118HWxc7Jxc0s58XOxdLBzM/XIODS yco8L2Rpdj48ZGl2Ppo8L2Rpdj4=