PostgreSQL 8.1.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-58)
I am not the admin that installs or runs the server. This server (and the others below) are at another institution.
NOTE: I have access other servers which do not cause this particular problem, but have other errors:
PostgreSQL 8.1.11 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-59)
select count(*) from pg_proc where proname='pg_file_write'; returns 0
the scroll bar on the logfile pane doesn't respond to mouse movement:
Logfile pane message: Logs are not available for this server
PostgreSQL 8.1.11 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-59)
select count(*) from pg_proc where proname='pg_file_write'; returns 1
error: /dbms/postgresql/db/dtftest/pg_log is not browsable: No such file or directory
the scroll bar on the logile file pane works fine and has a log entry in it:
redirect_stderr not enabled or log_filename misconfigured
On Wed, Jul 8, 2009 at 3:04 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
Le mercredi 8 juillet 2009 à 16:09:15, Michael Shapiro a écrit :
> The query
> select count(*) from pg_proc where proname='pg_file_write';
> returns 1
>
Which release of PostgreSQL are you using? Did you change it? (I'm thinking
about a 8.1 to something upgrade). Because the error message says you don't
have $libdir/admin81.so (or .dll on Windows) installed on your server. I see
two ways to get such an error: someone removed or renamed $libdir/admin81.so
or someone upgraded the PostgreSQL server.
--