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

From Richard Huxton
Subject Re: Restore database from files (not dump files)?
Date
Msg-id 457E7D5D.5050608@archonet.com
Whole thread Raw
In response to Re: Restore database from files (not dump files)?  (wheel <wheel@wheel.not>)
List pgsql-general
wheel wrote:
>
> I guess the reason is that the pg system database etc are lodged in the
> hive under \base\, and the system db contains the metadata about the db
> to be restored?

Actually, the users etc. are stored in \global\
The transaction log (WAL) is in \pg_xlog\
And so on...

> Unfortunately I've tried this now (exact same version of pg windows
> binary, user, password etc) and it didn't work. I'll just forget about
> the db I was trying to restore, it wasn't important, and has certainly
> not been worth the train wreck intro to the group.

Hmm - certainly should work.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Rikard Pavelic
Date:
Subject: returning parameters from function
Next
From: "Shoaib Mir"
Date:
Subject: Re: any api in libpq to get the number of connections