[ADMIN] pg_dumapp does not save objects added in pg_catalog

2009-09-28 Thread ali . pouya
Hi all, I'm novice to postgresql and in this list. I hope this is the good place to put my question. In my project I have added some plpgsql functions in pg_catalog. But when I save the cluster with pg_dumpall I do not find my function definitions in the output file. Is this normal ? Have I to r

[ADMIN] Measurin the lag between a master and a replica

2012-07-19 Thread Ali Pouya
timestamp. I do not know any function returning the timestamp. Is there any way to get the timestamp relative to the result of pg_current_xlog_location() ? Thanks for your help Best regards Ali Pouya