Re: queries timeout during backup postgres database

From: akp geek <akpgeek(at)gmail(dot)com>
To: Jerry Sievers <gsievers19(at)comcast(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: queries timeout during backup postgres database
Date: 2012-01-09 19:16:46
Message-ID: CACnhOf+WOwaYw+GB8eMKgHOVee=3s6iwZMm1ZeQ1L=CuQdh6uQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am using pg_dump to back up each schema in the database and there 6
schemas in the database.

thanks

On Mon, Jan 9, 2012 at 1:26 PM, Jerry Sievers <gsievers19(at)comcast(dot)net>wrote:

> akp geek <akpgeek(at)gmail(dot)com> writes:
>
> > Hi All -
> >
> > ? ? ? ? ? ? ? ? During the backup of the database, we experience
> > timeout on queries. any one has experienced the same? Is there any
> > parameters in the postgressql.conf that I have to pay attention to?
> > Can you please help
>
> What backup method and what statement is running if any when canceled?
>
> > Regards
> >
>
> --
> Jerry Sievers
> Postgres DBA/Development Consulting
> e: postgres(dot)consulting(at)comcast(dot)net
> p: 305.321.1144
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-01-09 19:31:06 Re: queries timeout during backup postgres database
Previous Message Jason Buberel 2012-01-09 19:10:56 Re: Time to move table to new tablespace