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

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-12 05:52:50
Message-ID: MPG.1fe7e38c16f04626989745@newsgroups.comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <C19E2E1F(dot)5D22D%scott_ribe(at)killerbytes(dot)com>,
scott_ribe(at)killerbytes(dot)com says...
> >>>> 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?
>
> OK, one more try:
>
> - Stop postgres.
>
> - Restore the ***ENTIRE*** ***data*** directory tree. Not "base", not
> something else "to it's location under \base". The entire data directory
> tree, just like the helpful message said.
>
> - Start postgres.
>
> Now, if you did that, and the raw files were from the same OS & architecture
> & postgres build settings, everything is fine. Otherwise, you're out of
> luck.
>
> > 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 doubt that.
>
>

Via Patrick's post I realized what my misstep was, but unforutnately it
has not resulted in a restored database in my case, I'm not sure why.
But thanks for the pointer, I'm sure what you've written is correct,
there is just some condition that prevents success in this case. It is
same OS, exact version of Postgres, everything that I'm aware of is a
match, but something is obviously at variance.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ashish Karalkar 2006-12-12 06:57:39 8.2.0 Installation Problem
Previous Message wheel 2006-12-12 05:47:29 Re: Restore database from files (not dump files)?