Re: Restore database from files (not dump files)? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Restore database from files (not dump files)?
Date
Msg-id 200612011732.kB1HWUk19778@momjian.us
Whole thread Raw
In response to Restore database from files (not dump files)?  (wheel <wheel@wheel.not>)
List pgsql-general
wheel wrote:
> Can a pgsql 8.1 database be restored from the raw file? For one database
> I have only the files found in  the base folder, example C:\PostgreSQL
> \data\base\16404, there are many files called 1247, 1248, etc (no
> extension). I think these are the files that make up the database? For
> this db I don't have a dump file, just what is on disk. I do know the
> users and passwords etc. I've hunted around quite a bit in various
> places and most of the restore discussions center around files created
> with pg_dump.

Uh, do you have the entier /data directory tree?  If so, just restore
the directory start it up a binary.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-general by date:

Previous
From: "Alejandro Michelin Salomon \( Adinet \)"
Date:
Subject: RES: Problem with function parameters
Next
From: "Magnus Hagander"
Date:
Subject: Re: transfer just the data directories from linux to windows?