Re: Restore DB - Mailing list pgsql-general

From Shahbaz A. Tyagi
Subject Re: Restore DB
Date
Msg-id 66D5E083E55542689F781480D435E963@dxb.sphere.ae
Whole thread Raw
In response to Re: Restore DB  (Ashish Karalkar <ashishka@synechron.com>)
Responses Re: Restore DB
Re: Restore DB
List pgsql-general
We took using PgAdminIII right click action. And it generated .backup files.

However while restoring whole machine is getting hanged for unlimited time.
So just checking do we have some other way also, as we have complete Postgre
directory also.

Thanks,

Shahbaz A. Tyagi
Sphere Networks

-----Original Message-----
From: Ashish Karalkar [mailto:ashishka@synechron.com]
Sent: Wednesday, February 25, 2009 4:38 PM
To: Shahbaz A. Tyagi
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore DB

Shahbaz A. Tyagi wrote:
>
> Hi,
>
>
>
> We are using Postgres 8.3. We have backed up our db and while trying
> to restore, its not able to. We are using PgAdminIII for the same.
>
>
>
> What all other ways we have to restore the db. We have both the old
> data directory as well as backed up data.
>
>
>
>
>
> Shabz
>
What is the Error?

There are many ways to restore a backup and depends on how you took the
backup.
Plz lets us know how u took the backup and what O/S you r using

--Ashish


pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Warm standby failover mechanism
Next
From: "Stéphane A. Schildknecht"
Date:
Subject: Re: Using xmin to identify last modified rows