On Wed, 2011-09-21 at 12:24 +0200, Willy-Bas Loos wrote:
> [...]
> It's a late reply, sry about that.
> pgAdmin stalls on me when i open the server status window, since i
> installed the adminpack.
> (pgAdmin version 1.12.2 on ubuntu 11.04)
> It shows an error, which doesn't react to click events.
> from the pgadmin log:
> 2011-09-21 11:14:16 ERROR : ERROR: could not read directory
> "pg_log": No such file or directory
> The applications then stalls.
>
> Postgres in on a server running postgresql 8.4 on ubuntu lucid.
> The adminpack is from tha package postgresql-contrib-8.4, probably
> from the lucid-updates repository, the version is 8.4.8-0ubuntu0.10.04
> topmost line is /* $PostgreSQL:
> pgsql/contrib/adminpack/adminpack.sql.in,v 1.6 2007/11/13 04:24:27
> momjian Exp $ */
>
> So i made a symlink /var/lib/postgresql/8.4/main/pg_log --> /var/log/postgresql/
> Now pgAdmin doesn't stall anymore when i open the server status, but
> the log windows shows a message:
> "logging_collector not enabled or log_filename misconfigured"
>
> I didn't change the default location of the logs.
>
The adminpack should only work if you use the logging_collector and the
default values for log_directory and log_filename. One of these is
probably wrongly configured.
--
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com