Re: [SQL] Call a external app on postgreSQL start-up (windows)

[Filip Rembiałkowski]

2011/12/27 Maurício Cruz :
>
> I need to execute it after the postgreSQL started service.

OK, so the method I described should be good for you.
The script could be put in Task Scheduler every 15 minutes, or minimal
delay that is acceptable.
It can be written in windos batch language, or Perl, or Python, or whatever...



please CC the list when replying ( use "reply to all" )

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Call a external app on postgreSQL start-up (windows)

[Filip Rembiałkowski]

2011/12/27 Maurício Cruz :
> Hi all,
>
> I need to execute some rotines on windows every time that postgreSQL is
> start at the server machine,

before it's started or just after it's started?


> I was thinking to create a PL/PGSQL to call this executable, or something
> like...
there are no triggers other than INSERT/UPDATE/DELETE yet.

I would rather go and create external script
- read lastruntime from savefile (simple one line text file will do)
- connect to postgres and fetch SELECT now(), pg_postmaster_start_time();
- if "pg_postmaster_start_time" is newer than statefile timestamp,
save "now" to savefile and run the job.

(I looked at PgAgent but from the docs I see it does not yet have
"once per server startup" logic).


>
> Does any one, have done something like this ? or have any idea ?
>
>
>
> Thanks everyone!
>
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

[SQL] Call a external app on postgreSQL start-up (windows)

[Maurício Cruz]

Hi all,

I need to execute some rotines on windows every time that postgreSQL is 
start at the server machine,
I was thinking to create a PL/PGSQL to call this executable, or 
something like...


Does any one, have done something like this ? or have any idea ?



Thanks everyone!



--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql