2011/12/27 Maurício Cruz <c...@sygecom.com.br>: > 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
