Re: Restore database from files (not dump files)?

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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

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