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

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Gera Mel Handumon [ Di, 08 Dezember 2009 04:59 ] [ ID #2025110 ]

Re: pg DATA folder restoration

On Mon, Dec 7, 2009 at 8:59 PM, Gera Mel Handumon <geramel.h [at] 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...

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Scott Marlowe [ Di, 08 Dezember 2009 05:09 ] [ ID #2025111 ]

Re: pg DATA folder restoration

On Mon, Dec 7, 2009 at 9:09 PM, Scott Marlowe <scott.marlowe [at] gmail.com> wrote:
> On Mon, Dec 7, 2009 at 8:59 PM, Gera Mel Handumon <geramel.h [at] 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.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Scott Marlowe [ Di, 08 Dezember 2009 05:12 ] [ ID #2025112 ]
Datenbanken » gmane.comp.db.postgresql.admin » pg DATA folder restoration

Vorheriges Thema: PostgreSQL monitoring
Nächstes Thema: Question about replication options