Skip site navigation (1) Skip section navigation (2)

Re: Lost instrumentation functions

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To:
Cc: PgAdmin-support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Lost instrumentation functions
Date: 2006-01-22 17:26:24
Message-ID: 43D3C040.8070000@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
Joost Kraaijeveld wrote:
> Hi Dave,
> 
> If I run this query
> 
> select * from pg_logdir_ls() as (filetime timestamp, filename text)
> 
> I get the following response:
> 
> ERROR:  /var/lib/postgresql/8.1/main/pg_log is not browsable: Not a
> directory
> 
> This suggest that the function is available (but not working ;-))

I bet /var/lib/postgresql/8.1/main/pg_log is not a directory... Did you
enable redirect_stderr? The function is working as expected in this
situation.

Please note that pgadmin expects its functions to be existent in the
_maintenance_ DB, for 8.1 usually postgres.

Regards,
Andreas

In response to

Responses

pgadmin-support by date

Next:From: Joost KraaijeveldDate: 2006-01-22 17:40:36
Subject: Re: Lost instrumentation functions
Previous:From: Joost KraaijeveldDate: 2006-01-22 15:50:00
Subject: Re: Lost instrumentation functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group