"Berislav Lopac" <berislav.lopac@xxxxxxxxx> 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