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

From: Richard Huxton <dev(at)archonet(dot)com>
To: wheel <wheel(at)wheel(dot)not>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restore database from files (not dump files)?
Date: 2006-12-12 09:58:53
Message-ID: 457E7D5D.5050608@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-12-12 10:49:25 Re: out of memory error on 3 table join
Previous Message Shoaib Mir 2006-12-12 09:55:40 Re: any api in libpq to get the number of connections