Thread: pg DATA folder restoration
Hello, My pc crash, all i can do is get the DATA folder of postgresql. What is the proper restoration procedure of DATA folder to newly installed postgresql server (MSwindows). TIA -- Gera Mel E. Handumon ----------------------------------------------------------------- "Share your knowledge. It's a way to achieve immortality" - Dalai Lama
On Mon, Dec 7, 2009 at 8:59 PM, Gera Mel Handumon <geramel.h@gmail.com> wrote: > Hello, > > My pc crash, all i can do is get the DATA folder of postgresql. > What is the proper restoration procedure of DATA folder to newly > installed postgresql server (MSwindows). Install pgsql, move data dir out of way, put old one in place, pray, sacrifice chickens, start pgsql and see what happens. Note that the praying and chicken sacrifice are optional...
On Mon, Dec 7, 2009 at 9:09 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote: > On Mon, Dec 7, 2009 at 8:59 PM, Gera Mel Handumon <geramel.h@gmail.com> wrote: >> Hello, >> >> My pc crash, all i can do is get the DATA folder of postgresql. >> What is the proper restoration procedure of DATA folder to newly >> installed postgresql server (MSwindows). > > Install pgsql, move data dir out of way, put old one in place, pray, > sacrifice chickens, start pgsql and see what happens. Oh between install pg and move data dir you need to shut down the pgsql service if it's up and running already.