New answers tagged

1

To get all members of all roles: SELECT r.rolname as username,r1.rolname as "role" FROM pg_catalog.pg_roles r JOIN pg_catalog.pg_auth_members m ON (m.member = r.oid) JOIN pg_roles r1 ON (m.roleid=r1.oid) WHERE r.rolcanlogin ORDER BY 1; Add r1.rolname='council_stuff' to filter on only that one. Be aware that users ...


1

From this post: ;WITH CTE AS ( SELECT table_name , ( SELECT MAX(pg_ls_dir::int)::text FROM pg_ls_dir('./base') WHERE pg_ls_dir <> 'pgsql_tmp' AND pg_ls_dir::int <= (SELECT relfilenode FROM pg_class WHERE relname ILIKE table_name) ) as folder ...


0

I was running into similar issues with pgAgent all the time, as at my company we used it pretty heavily. The reason it stays "running" is because the pgAgent service crashed and was unable to update the logging row. Like tkrennwa said, that was most likely caused by that bug. The issue is, i've run into too many of those types of bugs with pgAgent where ...


0

According to: http://www.postgresql.org/message-id/BLU0-SMTP179B92C5102247CD961A4B3CF2A0@phx.gbl The temp counter (files and space used) shows a total of all temp files used since probably cluster creation. It does not reflect the current space used by temp files. My system for example shows almost 700GB of temp files used, but the actual space taken up ...



Top 50 recent answers are included