From: | "Srinivas Kotapally" <ksrinivas(at)bisil(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Using the /var/lib/pgsql/data directory in the absense of a backup for recovery |
Date: | 2003-07-22 21:47:34 |
Message-ID: | 003301c3509a$dd3f3a80$3a185f42@BISIL |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello all
I am a newbie PostgreSQL DB admin. I have the following problem:
1. I have a redhat 8 box which has postgres installed.
2. I have reinstalled postgresql 7.2.1-5 (native postgres installation on
RedHat 7.3) on the redhat 8.0
3. I don't have the database backups from my 7.3 installation - I however
have access to the /var/lib/pgsql/data directory.
My question is... can I use this to recover the database from the 7.3
version. We got hacked and the earlier system was unusable.
I tired to do an initdb but it would not let me provide the existing data
directory and got the following:
-bash-2.05b$ initdb
The files belonging to this database system will be owned by "postgres".
This use must also own the server process.
initdb: The directory /var/lib/pgsql/data exists but is not empty.
If you want to create a new database system, either remove or empty the
directory /var/lib/pgsql/data or run initdb with an argument other than
/var/lib/pgsql/data.
I tried to do fire up the postmaster process and could not fire up the DB.
I don't get a message the system just returns to the prompt without starting
the database.
Any help would be welcome!!
Thanks
Srinivas
From | Date | Subject | |
---|---|---|---|
Next Message | Santiago Matiz | 2003-07-22 21:53:00 | Re: Replication/Failover/HA solution |
Previous Message | Andrew Biagioni | 2003-07-22 21:25:28 | Re: Replication/Failover/HA solution |