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

Re: Set up a database without backup

From: "Alejandro D(dot) Burne" <alejandro(dot)dburne(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Set up a database without backup
Date: 2007-07-25 00:54:54
Message-ID: 8398dc6d0707241754p72959329k3e2f8ef7a86e5450@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
2007/7/24, tech(at)g-sistemas(dot)com <tech(at)g-sistemas(dot)com>:
> Hello everybody.
>
> I'm using PostgreSQL on Windows XP.
>
> I had to format de harddisc, and I'm lost databases and tablespaces
> configuration (1 database and 1 tablespace), I have a copy of directory
> where was the tablespaces ( but I haven't a backup made by pgAdmin ).
>
> What do I for set up my database and tablespace ?
>
> It could be: creating a new database and tablespace, and after copy files
> of older tablespace to newer tablespace?
>
> Thanks In Advance
>
> With Regards
>
> Juan.
>

If u have the dirs where the db where initialized you can reinstall
the "same" version of postgres on your windows machine and then
replace the data dir with your files backup.

Alejandro

In response to

pgsql-admin by date

Next:From: Phillip SmithDate: 2007-07-25 02:05:20
Subject: Data directory was initialized by PostgreSQL version 8.3
Previous:From: PostgreSQL AdminDate: 2007-07-24 16:48:26
Subject: Re: deinstallation - reinstallation on Mac OS 10.4

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