Fwd: Re: [pgadmin-support] Demande de support

2012-06-27 Thread Raymond O'Donnell
[sorry - didn't cc the list]. Original Message Subject: Re: [pgadmin-support] Demande de support Date: Wed, 27 Jun 2012 15:47:16 +0100 From: Raymond O'Donnell Reply-To: r...@iol.ie To: Wajdi Dhaouadi On 27/06/2012 15:42, Wajdi Dhaouadi wrote: > support > > 2012/6/27 Raymond

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] Demande de support

2012-06-27 Thread Raymond O'Donnell
On 27/06/2012 14:56, Wajdi Dhaouadi wrote: > Merci de m'envoyer un support . Certainly - what is your issue? Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.

[pgadmin-support] Demande de support

2012-06-27 Thread Wajdi Dhaouadi
Merci de m'envoyer un support .

Re: [pgadmin-support] Fwd: How to run query by command prompt in Postgres

2012-06-27 Thread Kapil Kr. Khandelwal
Thanks to your prompt support...It really helpful for me. Thanks & Regards Kapil Kr. Khandelwal M: 09694179109 CodeScape Consultants, Jaipur On Wed, Jun 27, 2012 at 5:41 PM, Julien Rouhaud wrote: > > > Le 27 juin 2012 à 14:06, "Kapil Kr. Khandelwal" a > écrit : > > Dear Sir > > I want to

Re: [pgadmin-support] Fwd: How to run query by command prompt in Postgres

2012-06-27 Thread Julien Rouhaud
Le 27 juin 2012 à 14:06, "Kapil Kr. Khandelwal" a écrit : Dear Sir I want to run sql query, without any file. I have connected the db, but not getting success run sql query. Did you end your input with a ; Without it, pressing return will just add another line to your query I can run by file,

Re: [pgadmin-support] Fwd: How to run query by command prompt in Postgres

2012-06-27 Thread Kapil Kr. Khandelwal
Dear Sir I want to run sql query, without any file. I have connected the db, but not getting success run sql query. I can run by file, if you can provide me steps of this. Looking forward to positive response from your side. Thanks in advance. Thanks & Regards Kapil Kr. Khandelwal M: 0969417

Re: [pgadmin-support] Fwd: How to run query by command prompt in Postgres

2012-06-27 Thread Raymond O'Donnell
On 27/06/2012 12:18, Kapil Kr. Khandelwal wrote: > > > Dear Team > > I want to a favour from your side. I want to know, how to run sql query > by command prompt in postgres sql. psql -f file-with-query.sql your-database http://www.postgresql.org/docs/9.1/static/app-psql.html Ray. -- Ray

[pgadmin-support] Fwd: How to run query by command prompt in Postgres

2012-06-27 Thread Kapil Kr. Khandelwal
Dear Team I want to a favour from your side. I want to know, how to run sql query by command prompt in postgres sql. I am waiting for your positive response. Thanks in advance. Thanks & Regards Kapil Kr. Khandelwal M: 09694179109 CodeScape Consultants, Jaipur

Re: [pgadmin-support] Time series aggregation

2012-06-27 Thread Yelai, Ramkumar IN BLR STS
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 server 2. I have started the server at 4:03 PM and I reset the jobnextrun ( from pgAd

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

[pgadmin-support] Time series aggregation

2012-06-27 Thread Yelai, Ramkumar IN BLR STS
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 1000 devices for around 1 week of date range, It takes more time to aggregate