Thanks so much. We now have CentOS and postgresql ready. But we are missing the backup files, that's, we haven't done pg_dump our database. How to restore the database from some files like using mdb file to restore a Access database? Is it possible in Postgres? I am new to Postgres. Your help will be appreciated. jooy On 10/16/07, Richard Huxton <dev@xxxxxxxxxxxx> wrote: > jooy wrote: > > Hello all, > > We have a serious problem. Out dedicated server was hacked last > > Sunday. And technical support used a new hard drive with new-installed > > centOS to build our new server. Unfortunately, we don't have database > > backup(pg_dump). We only have the old drive mounted and access normal > > files. Is there any way we can just use those files to restore the > > database? If we can, How? Any input are extremely welcome. > > You need an old copy of Postgesql - the same version you previously had. > It should also have the same build-options. The simplest solution would > probably be to do a minimal install of your old O.S. (a previous version > of CentOS) and then the relevant version of PostgreSQL. > > If there's an RPM with the right version of PostgreSQL for your current > CentOS, you could try that, but take a filesystem backup first. > > -- > Richard Huxton > Archonet Ltd > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
