[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

RHDB restore procedure



I recently inherited the task of restoring a database from rhdb2.1 (postgres
7.2.3).  The backup was performed by running:

pg_dump -U user database_name -f output_dump_file

Now, I have a 1.9GB txt dump file, but am having a hard time restoring it
back to postgres.

To further cause me problems, /var/lib/pgsql *was* mounted on a SAN.  The
datacenter where the servers were colocated basically went away along with
the data on the SAN.  So, there is nothing left of the /var/lib/pgsql
directory, thus no users to login to psql with, no pg_hba.conf, etc.

Can someone point me in the right direction?

TIA

Mike


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]