Re: [pgadmin-support] Time series aggregation

2012-06-28 Thread Dave Page
On Thu, Jun 28, 2012 at 7:21 AM, Yelai, Ramkumar IN BLR STS wrote: > Hi Dave, > > I use to shutdown the postgresql server by stopping the service, followed by > that pgAgent server is automatically stopped. > > However I am getting the following error message in service logger, while > shutdown

Re: [pgadmin-support] Time series aggregation

2012-06-28 Thread Yelai, Ramkumar IN BLR STS
pgAgent). Thanks & Regards, Ramkumar -Original Message- From: Yelai, Ramkumar IN BLR STS Sent: Thursday, June 28, 2012 11:51 AM To: 'Dave Page' Cc: pgadmin-support@postgresql.org Subject: RE: [pgadmin-support] Time series aggregation Hi Dave, I use to shutdown the postgr

Re: [pgadmin-support] Time series aggregation

2012-06-28 Thread Yelai, Ramkumar IN BLR STS
dmin-support] Time series aggregation On Wed, Jun 27, 2012 at 11:44 AM, Yelai, Ramkumar IN BLR STS wrote: > Thanks Dave. > > I have reset the pgagent.pga_job.jobnextrun when server restarts, however it > will be reset by pgAgent, when it starts. > > Following are the steps, I have

Re: [pgadmin-support] Time series aggregation

2012-06-27 Thread Dave Page
On Wed, Jun 27, 2012 at 11:44 AM, Yelai, Ramkumar IN BLR STS wrote: > Thanks Dave. > > I have reset the pgagent.pga_job.jobnextrun when server restarts, however it > will be reset by pgAgent, when it starts. > > Following are the steps, I have done. > > 1. Around 2:45 PM, I have stopped the serve

Re: [pgadmin-support] Time series aggregation

2012-06-27 Thread Yelai, Ramkumar IN BLR STS
From: Dave Page [mailto:dp...@pgadmin.org] Sent: Wednesday, June 27, 2012 2:14 PM To: Yelai, Ramkumar IN BLR STS Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Time series aggregation On Wed, Jun 27, 2012 at 7:15 AM, Yelai, Ramkumar IN BLR STS wrote: > Hi, > > In my cu

Re: [pgadmin-support] Time series aggregation

2012-06-27 Thread Dave Page
On Wed, Jun 27, 2012 at 7:15 AM, Yelai, Ramkumar IN BLR STS wrote: > Hi, > > In my current project,  we are keep inserting  device related data in 5 > minutes basis  in our archiving tables. Soon we added more devices, more > number of  rows will be inserted. > > When we are generating report for