In article <4573282A.4040605@zijn-digital.com>, brian@zijn-digital.com
says...
> wheel wrote:
> > 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?
> >
>
> Just start Postgres. If the data dir is ok, it should run fine.
>
> I'm assuming the binary is 8.1 but are the data files from the same version?
>
> b
I see...I'm using pgAdmin III with 8.1.5, and the dbs don't reappear in
the pgAdmin list of databases automatically. I'll see if I can figure
out how to get pgAdmin to 'see' the dbs that have been moved here. At
least it seems from what you're saying it's just a matter of the
restored dbs being invisible to pgAdmin.
