Re: [GENERAL] need help with rebuilding postgresql

2007-10-16 Thread Scott Marlowe
On 10/16/07, jooy <[EMAIL PROTECTED]> wrote: > Thanks for the input. Let me put it in this way:We are running a php > site over postgresql database server. The name of database instance is > FOIM. All of a sudden after Sunday, some guy hacked the system. We > need rebuild the system. Now we have ne

Re: [GENERAL] need help with rebuilding postgresql

2007-10-16 Thread jooy
Thanks for the input. Let me put it in this way:We are running a php site over postgresql database server. The name of database instance is FOIM. All of a sudden after Sunday, some guy hacked the system. We need rebuild the system. Now we have new-installed OS along with Postgres 7. Unfortunately,

Re: [GENERAL] need help with rebuilding postgresql

2007-10-16 Thread Scott Marlowe
On 10/16/07, jooy <[EMAIL PROTECTED]> wrote: > On 10/16/07, Richard Huxton <[EMAIL PROTECTED]> 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 b

Re: [GENERAL] need help with rebuilding postgresql

2007-10-16 Thread jooy
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

Re: [GENERAL] need help with rebuilding postgresql

2007-10-16 Thread Richard Huxton
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

[GENERAL] need help with rebuilding postgresql

2007-10-16 Thread jooy
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 the