Re: Restore DB

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(at)synechron(dot)com]
> Sent: Wednesday, February 25, 2009 4:38 PM
> To: Shahbaz A. Tyagi
> Cc: pgsql-general(at)postgresql(dot)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