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 <guilla...@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. > > > -- > Guillaume. > http://www.postgresqlfr.org > http://dalibo.com >