Thread: auto insert data every one minute

Hi all..

I have an sql script consists of insert statement data. I want to insert
every row of data every one minute. How can i do that using batch file in
windows

Thank you
--
View this message in context: http://www.nabble.com/auto-insert-data-every-one-minute-tp20027811p20027811.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

On Fri, Oct 17, 2008 at 12:32 AM, searchelite <searchelite@gmail.com> wrote:

> I have an sql script consists of insert statement data. I want to insert
> every row of data every one minute. How can i do that using batch file in
> windows

Take a look at your windows scheduler in the control panel.  You might
need to spend quite a bit of time configuring a 1 minute interval
since it only seems to be designed for daily occurrences.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

On Fri, Oct 17, 2008 at 12:32 AM, searchelite <searchelite@gmail.com> wrote:
 

I have an sql script consists of insert statement data. I want to insert
every row of data every one minute. How can i do that using batch file in
windows   

Take a look at your windows scheduler in the control panel.  You might
need to spend quite a bit of time configuring a 1 minute interval
since it only seems to be designed for daily occurrences.

 

    searchelite wrote:

> I have an sql script consists of insert statement data. I want to
insert
> every row of data every one minute. How can i do that using batch
file in
> windows

How about using pg_sleep ?

INSERT .... ;
COMMIT;
SELECT pg_sleep(60);

INSERT...;
COMMIT;
SELECT pg_sleep(60);

...

 Best regards,
--
 Daniel
 PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org

    Grzegorz Jaśkiewicz wrote:

> how about windows task scheduler ? (cron-ish thing)

If the OP wants to do the exact same insert every minute, then the OS
scheduler sure does the job.

That's not how I understood the question, though. My interpretation is
that he has a SQL script with an ordered list of INSERTs to perform and
he wants to throttle the execution, in which case scheduling at the OS
level doesn't help that much.

 Best regards,
--
 Daniel
 PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org

Daniel Verite wrote:
>
>     searchelite wrote:
>
>
> How about using pg_sleep ?
>
> INSERT .... ;
> COMMIT;
> SELECT pg_sleep(60);
>
> INSERT...;
> COMMIT;
> SELECT pg_sleep(60);
>
>
>
>


i can use pg_sleep..but i have thousands of data to be inserted..is there
any better way using pg_sleep?

--
View this message in context: http://www.nabble.com/auto-insert-data-every-one-minute-tp20027811p21263763.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

You need to write a process that will do it.
At best you can use crontab if your a lucky and use Unix.



--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

On Saturday January 3 2009 11:46:47 searchelite wrote:
> Daniel Verite wrote:
> >     searchelite wrote:
> >
> >
> > How about using pg_sleep ?
> >
> > INSERT .... ;
> > COMMIT;
> > SELECT pg_sleep(60);
> >
> > INSERT...;
> > COMMIT;
> > SELECT pg_sleep(60);
>
> i can use pg_sleep..but i have thousands of data to be inserted..is there
> any better way using pg_sleep?
>
> --
> View this message in context:
> http://www.nabble.com/auto-insert-data-every-one-minute-tp20027811p21263763
>.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Hi,

searchelite wrote:
...

> i can use pg_sleep..but i have thousands of data to be inserted..is there
> any better way using pg_sleep?

I wonder what is you complete problem? It seems all the advices given
so far are shots-in-the-dark. Could you perhaps expand a bit?

Also for sophisticated solution, if you stick to windows you might
want to consider something different then just pure CMD, say some
scripting language to support.

Tino

Hi

Why don't use pgAgent http://pgadmin.org/docs/dev/pgagent.html ?

Regards,

Christophe Chauvet.

Tino Wildenhain a écrit :
> Hi,
>
> searchelite wrote:
> ...
>
>> i can use pg_sleep..but i have thousands of data to be inserted..is
>> there
>> any better way using pg_sleep?
>
> I wonder what is you complete problem? It seems all the advices given
> so far are shots-in-the-dark. Could you perhaps expand a bit?
>
> Also for sophisticated solution, if you stick to windows you might
> want to consider something different then just pure CMD, say some
> scripting language to support.
>
> Tino
>
>

Tino Wildenhain wrote:
>
>
> I wonder what is you complete problem? It seems all the advices given
> so far are shots-in-the-dark. Could you perhaps expand a bit?
>
> Also for sophisticated solution, if you stick to windows you might
> want to consider something different then just pure CMD, say some
> scripting language to support.
>
> Tino
>
>

I have pre-recorded gps data in .sql insert format..for simulate real-time
tracking, i want to insert the data in let say every one minute

--
View this message in context: http://www.nabble.com/auto-insert-data-every-one-minute-tp20027811p21524797.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

On Sat, 2009-01-17 at 22:40 -0800, searchelite wrote:
>
>
> Tino Wildenhain wrote:
> >
> >
> > I wonder what is you complete problem? It seems all the advices given
> > so far are shots-in-the-dark. Could you perhaps expand a bit?
> >
> > Also for sophisticated solution, if you stick to windows you might
> > want to consider something different then just pure CMD, say some
> > scripting language to support.
> >
> > Tino
> >
> >
>
> I have pre-recorded gps data in .sql insert format..for simulate real-time
> tracking, i want to insert the data in let say every one minute

Feed the data to a loop that waits every 60 seconds. You could also pipe
it to a named pipe while an injector was listening.

Joshua D. Drake

>
> --
> View this message in context: http://www.nabble.com/auto-insert-data-every-one-minute-tp20027811p21524797.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997