Re: [ADMIN] PGSQL-IDLE connection problem

2013-01-29 Thread Sathish Reddy Yelala
hi, Thanks for the response.Here I have few more queries regarding Connections. 1.When the connection goes to state 2. when the connection becomes active 3.Is there any chance to database get slow because of connections Any help would be appreciated..

Re: [ADMIN] corrupted indexes when using base backups generated from hot standby

2013-01-29 Thread Lonni J Friedman
On Tue, Jan 29, 2013 at 8:38 AM, Heikki Linnakangas wrote: > On 29.01.2013 18:36, Lonni J Friedman wrote: >> >> On Tue, Jan 29, 2013 at 8:32 AM, Heikki Linnakangas >> wrote: >>> >>> Thanks. I'm afraid I didn't get any wiser from the log output. Since this >>> is >>> >>> a test system, could you

[ADMIN] Re: corrupted indexes when using base backups generated from hot standby

2013-01-29 Thread Heikki Linnakangas
On 29.01.2013 18:36, Lonni J Friedman wrote: On Tue, Jan 29, 2013 at 8:32 AM, Heikki Linnakangas wrote: Thanks. I'm afraid I didn't get any wiser from the log output. Since this is a test system, could you reduce the test case into something smaller and self-contained? Sorry, I don't underst

Re: [ADMIN] corrupted indexes when using base backups generated from hot standby

2013-01-29 Thread Lonni J Friedman
On Tue, Jan 29, 2013 at 8:32 AM, Heikki Linnakangas wrote: > On 26.01.2013 01:28, Lonni J Friedman wrote: >> >> On Tue, Jan 15, 2013 at 2:57 AM, Heikki Linnakangas >> wrote: >>> >>> That process sounds correct. Since you're using pg_basebackup -x option, >>> you >>> >>> don't even need to copy t

[ADMIN] Re: corrupted indexes when using base backups generated from hot standby

2013-01-29 Thread Heikki Linnakangas
On 26.01.2013 01:28, Lonni J Friedman wrote: On Tue, Jan 15, 2013 at 2:57 AM, Heikki Linnakangas wrote: That process sounds correct. Since you're using pg_basebackup -x option, you don't even need to copy the WAL logs, although it shouldn't do any harm either . The tar file should contain ever

Re: [ADMIN] PGSQL-IDLE connection problem

2013-01-29 Thread Flavio Henrique Araque Gurgel
Em 28-01-2013 07:12, Sathish Reddy Yelala escreveu: Hi, we had problem with connections.when we start the database there huge number of connections goes to which leads to database access slow. These connections are opened by your client application, not by PostgreSQL. How can we