Re: [ADMIN] Set up a database without backup

2007/7/24, tech@g-sistemas.com <tech@g-sistemas.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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match