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