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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: Restore database from files (not dump files)?
Date: 2006-12-05 17:57:36
Message-ID: 200612051757.kB5HvaW13981@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[ The author's email address is clearly bogus, so I can't privately send
him email.]

You seems to be trying to get help by supplying the least amount of
information possible, and not even fully typing out words. Such
approaches usually fail.

I suggest we ignore further emails from this person until more complete
information is provided, and a valid email address.

---------------------------------------------------------------------------

> wheel wrote:
> > In article <74A84126-07CC-458C-B4FD-ECD2431831D8(at)mitre(dot)org>,
> > john(at)mitre(dot)org says...
> > > >> 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.
> > >
> > > It's unclear from your description whether the raw DB files were
> > > moved from another installation - note that the above is only
> > > guaranteed to work if architecture/compiler/etc. are all the same.
> > > If the files were created by exactly the same PG instance, then you
> > > should be okay.
> > >
> > > - John D. Burger
> > > MITRE
> > >
> > The raw db files are not from this installation, but same ver of windows
> > binary pg. Does this mean the db is not going to be useable/recoverable?
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: explain analyze is your friend
>
> --
> Bruce Momjian bruce(at)momjian(dot)us
> EnterpriseDB http://www.enterprisedb.com
>
> + If your life is a hard drive, Christ can be your backup. +

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomi N/A 2006-12-05 18:38:08 Re: Speed of postgres compared to ms sql, is this
Previous Message andy rost 2006-12-05 17:36:38 Unable to restart postgres - database system was interrupted