Skip site navigation (1) Skip section navigation (2)

Re: Restoring databases from a different installment on Windows

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Restoring databases from a different installment on Windows
Date: 2006-05-29 14:26:58
Message-ID: e5f0bn$4jm$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-general
"Berislav Lopac" <berislav(dot)lopac(at)gmail(dot)com> wrote
>I have recently reinstalled my Windows mychine, including the
> PostgreSQL server, but (due to a system crash, unrelated to Postgres) 
> I
> wasn't able to dump my databases to import them now. However, I have a
> full copy of the original system, including all the files of the
> original Postgres installation.
>
> Is there a way to restore the databases from the original installation
> into the new one? For example, in MySQL I would be able to just copy
> the data files; is there something similar in Postgres?
>

If you don't have a tablespace built (i.e. all data are in your initial 
data directory), then just like MySQL, you can replace your current data 
directory with that folder.

Regards,
Qingqing 



In response to

Responses

pgsql-general by date

Next:From: Samer AbukhaitDate: 2006-05-29 15:09:10
Subject: National Number to text conversion
Previous:From: Tom LaneDate: 2006-05-29 14:20:33
Subject: Re: The server's LC_CTYPE locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group