On 11/13/2011 06:09 PM, Alexander Burbello wrote:
Hi folks,
My server has a daily routine to import a dump file, however its taking long
time to finish it.
The original db has around 200 MB and takes 3~4 minutes to export (there are
many blob fields), however it takes 4 hours to import using p
Hi,
On 14 November 2011 11:09, Alexander Burbello wrote:
> What can I do to tune this database to speed up this restore??
> My current db parameters are:
> shared_buffers = 256MB
> maintenance_work_mem = 32MB
You should increase maintenance_work_mem as much as you can.
full_page_writes, archive_
Hi folks,
My server has a daily routine to import a dump file, however its taking
long time to finish it.
The original db has around 200 MB and takes 3~4 minutes to export (there
are many blob fields), however it takes 4 hours to import using pg_restore.
What can I do to tune this database to spe
On Wed, Feb 25, 2009 at 6:54 AM, 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
> d
. Tyagi
Sphere Networks
-Original Message-
From: Ashish Karalkar [mailto:ashis...@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
-Original Message-
From: Ashish Karalkar [mailto:ashis...@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
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.
Sh
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.
Sh
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
