Re: Restore DB - Mailing list pgsql-general

From Ashish Karalkar
Subject Re: Restore DB
Date
Msg-id 49A560A5.1070108@synechron.com
Whole thread Raw
In response to Re: Restore DB  ("Shahbaz A. Tyagi" <shahbaz.tyagi@sphere.ae>)
List pgsql-general
Shahbaz A. Tyagi wrote:
> 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
>
>
>
I am considering that you have taken this directory backup when server
was shutdown.

 Place the directory at desired location and start the server as a
postgres user

pg_ctl -D <path to postgres data directory> start





pgsql-general by date:

Previous
From: "Stéphane A. Schildknecht"
Date:
Subject: Re: Using xmin to identify last modified rows
Next
From: "Albe Laurenz"
Date:
Subject: Re: Using xmin to identify last modified rows