Re: Very stupid backup I made

From: James Gregory <james(at)anchor(dot)net(dot)au>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very stupid backup I made
Date: 2003-03-21 11:53:15
Message-ID: 1048247595.19671.5.camel@pirate.bridge.anchor.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2003-03-20 at 23:48, Juraj Fedel wrote:
> On Thu, Mar 20, 2003 at 11:59:38AM +0530, Shridhar Daithankar wrote:
> > man pg_dump
> >
> > Bye
> > Shridhar
>
> I will remmember this. For shure I will. If I was not so compulsive
> maybe I could save myself lot of trouble with little reading before doiiing
> something stupid.
> Thanks a lot. This will help in the future.

As an item of curiosity - is there a way to resurrect the database from
a backup of the files? I understand that if the backup was taken while
the db was running it would be in an inconsistent state, but surely if
the whole thing was there postgres would be able to roll back the
transactions?

Why can't postgres be restored from file backups? Is there a hack to do
it?

James.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Georgi Chorbadzhiyski 2003-03-21 12:10:26 Re: rules problem
Previous Message Deepa K 2003-03-21 11:45:40 Inserting a bitarray value through storedprocedure