From: | jooy <oldatum(at)gmail(dot)com> |
---|---|
To: | "Richard Huxton" <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: need help with rebuilding postgresql |
Date: | 2007-10-16 21:06:41 |
Message-ID: | 881614230710161406n7cd45cdfr5b90ec311a5c3c42@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)archonet(dot)com> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2007-10-16 21:39:19 | Re: Preserving view source code |
Previous Message | Tom Lane | 2007-10-16 20:56:07 | Re: SPI_exec() + PG_TRY/PG_CATCH |