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

From wheel
Subject Re: Restore database from files (not dump files)?
Date
Msg-id MPG.1fda10e0a5d8a5e989739@newsgroups.comcast.net
Whole thread Raw
In response to Restore database from files (not dump files)?  (wheel <wheel@wheel.not>)
Responses Re: Restore database from files (not dump files)?  (brian <brian@zijn-digital.com>)
List pgsql-general
In article <200612011732.kB1HWUk19778@momjian.us>, bruce@momjian.us
says...
> 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.
>
>
Yes I have the entire dir/file set. But what does "If so, just restore
the directory start it up a binary" mean? Restore the dir, you mean copy
it to it's location under \base? What does start it up a(s?) binary
mean? I'm new to postgres.

I have copied the folders back to the base dir (like C:\PostgreSQL\data
\base\16404) if that's step one but what after that?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Concatenate performance question
Next
From: "Niederland"
Date:
Subject: vacuum in standalone mode