| Lists: | pgsql-general |
|---|
| From: | "Shahbaz A(dot) Tyagi" <shahbaz(dot)tyagi(at)sphere(dot)ae> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Restore DB |
| Date: | 2009-02-25 12:08:25 |
| Message-ID: | 15E9166824C14091BF96F84F3967BDD5@dxb.sphere.ae |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Ashish Karalkar <ashish(dot)karalkar(at)enterprisedb(dot)com> |
|---|---|
| To: | "Shahbaz A(dot) Tyagi" <shahbaz(dot)tyagi(at)sphere(dot)ae> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restore DB |
| Date: | 2009-02-25 12:16:48 |
| Message-ID: | 49A536B0.3060400@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Ashish Karalkar <ashishka(at)synechron(dot)com> |
|---|---|
| To: | "Shahbaz A(dot) Tyagi" <shahbaz(dot)tyagi(at)sphere(dot)ae> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restore DB |
| Date: | 2009-02-25 12:38:14 |
| Message-ID: | 49A53BB6.8080506@synechron.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | "Shahbaz A(dot) Tyagi" <shahbaz(dot)tyagi(at)sphere(dot)ae> |
|---|---|
| To: | "'Ashish Karalkar'" <ashishka(at)synechron(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Restore DB |
| Date: | 2009-02-25 13:54:04 |
| Message-ID: | 66D5E083E55542689F781480D435E963@dxb.sphere.ae |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(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
| From: | Ashish Karalkar <ashishka(at)synechron(dot)com> |
|---|---|
| To: | "Shahbaz A(dot) Tyagi" <shahbaz(dot)tyagi(at)sphere(dot)ae> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restore DB |
| Date: | 2009-02-25 15:15:49 |
| Message-ID: | 49A560A5.1070108@synechron.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(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
| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Shahbaz A(dot) Tyagi" <shahbaz(dot)tyagi(at)sphere(dot)ae> |
| Cc: | Ashish Karalkar <ashishka(at)synechron(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restore DB |
| Date: | 2009-02-26 14:11:56 |
| Message-ID: | dcc563d10902260611w2e7a6642u5d2ea1877b83cbda@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Wed, Feb 25, 2009 at 6:54 AM, Shahbaz A. Tyagi
<shahbaz(dot)tyagi(at)sphere(dot)ae> 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.
Are you sure it's actually failing and not just taking a long time?