Archive for May 30, 2005

Find out the fd that are in use and by what.

May 30, 2005 e No comments
To find out what filedescriptors or sockets are used by a particular application, you can run...

sockstat -u

HOWTO

Method to cleanly DROP FUNCTIONs by wildcard in Postgres

May 30, 2005 e No comments

Cut and paste the output of this execution:


SELECT 'DROP function ' || proname || ' ('|| oidvectortypes(proargtypes) || ') CASCADE;' from pg_proc WHERE proname ~ '^create_product$';

HOWTO