| From: | wheel <wheel(at)wheel(dot)not> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restore database from files (not dump files)? |
| Date: | 2006-12-01 18:14:31 |
| Message-ID: | MPG.1fda10e0a5d8a5e989739@newsgroups.comcast.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In article <200612011732(dot)kB1HWUk19778(at)momjian(dot)us>, bruce(at)momjian(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-12-01 18:21:03 | Re: porducing documentation from postgres |
| Previous Message | John DeSoi | 2006-12-01 18:01:47 | Re: porducing documentation from postgres |