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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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