Re: [GENERAL] Restoring database from files on disk

2006-12-01 Thread Richard Huxton
veejar wrote: Unfortunately I don't have any other information: dumps, other folders from pgsql root directory. What tools? Start here: http://sources.redhat.com/rhdb/ And you'll want to read and understand the Internals/Physical Storage chapters of the manuals. From past experience recov

Re: [GENERAL] Restoring database from files on disk

2006-12-01 Thread Richard Huxton
veejar wrote: Hello! I had problems with my HDD and i have lost many files. From my pgsql database files I have only "base"-folder. In this folder one is important database: base/45325101 How to correct this one database? You can't. You need all the files in data/ - recover the whole cluste

[GENERAL] Restoring database from files on disk

2006-12-01 Thread veejar
Hello! I had problems with my HDD and i have lost many files. From my pgsql database files I have only "base"-folder. In this folder one is important database: base/45325101 I reinstall my postgresql-server. I have created new database with same name and have copied all files from my old folder