Hi all,
I'm making a lot of changes for my eventual migration to postgres 8.3,
and I was considering changing how data and logs are separated for a
few of my servers.
Currently, the OS and log data are on one disk system, and the actual
data cluster (including configs) are on the other disk syste
I am having problems getting pg_ctl to detach from the controlling
terminal so that it's a proper daemon. I am running
pg_ctl start -w -s -l $logfile within a script, which is invoked from an
automated test framework written in python. If the python process is
stopped by Ctrl-C, postgres dies. But
Kevin Kempter wrote:
Hi List;
we have some monitoring/alert scripts which run sql against the database
(8.1.4) as a non-superuser. The problem is I get
when trying to access current_query from pg_stat_activity.
I ran these grant statements but still no joy:
grant select on pg_stat_activity
