From: | David <lists(at)theflorys(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pgAdmin error |
Date: | 2008-11-22 06:35:19 |
Message-ID: | 4927A827.5040702@theflorys.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am trying to use pgAdmin 1.8.4 to edit the pg_hba.conf file on a
PostgreSQL 8.3 database running on Ubuntu 8.10. I get the following
error message:
An error has occurred:
ERROR: absolute path not allowed
CONTEXT: SQL function "pg_file_length" statement 1
then...
Backend Access Configuration Editor -
/etc/postresql/8.3/main/pg_hba.conf on Kepler...
with a blank screen.
My configuration seems ok. Any help?
from the pgadmin.log
2008-11-22 01:20:21 INFO : Server name: kepler.fdu.edu (resolved to:
132.238.16.3)
2008-11-22 01:20:21 INFO : Opening connection with connection string:
host='kepler.fdu.edu' hostaddr=132.238.16.3 dbname='postgres'
user='david' password='XXXXXX' port=5432 sslmode=require
2008-11-22 01:20:24 QUERY : Set query (kepler.fdu.edu:5432): SET
DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding,
datlastsysoid
FROM pg_database WHERE oid = 11511
2008-11-22 01:20:24 INFO : Setting client_encoding to 'UNICODE'
2008-11-22 01:20:24 QUERY : Set query (kepler.fdu.edu:5432): SELECT
proname, pronargs, proargtypes[0] AS arg0, proargtypes[1] AS arg1,
proargtypes[2] AS arg2
FROM pg_proc
JOIN pg_namespace n ON n.oid=pronamespace
WHERE proname IN ('pg_tablespace_size', 'pg_file_read',
'pg_logfile_rotate', 'pg_postmaster_starttime', 'pg_terminate_backend',
'pg_reload_conf', 'pgstattuple', 'pgstatindex')
AND nspname IN ('pg_catalog', 'public')
2008-11-22 01:20:24 QUERY : Scalar query (kepler.fdu.edu:5432): SHOW
hba_file
2008-11-22 01:20:24 QUERY : Query result:
/etc/postgresql/8.3/main/pg_hba.conf
2008-11-22 01:20:24 QUERY : Scalar query (kepler.fdu.edu:5432): SELECT
pg_file_read('/etc/postgresql/8.3/main/pg_hba.conf', 0,
pg_file_length('/etc/postgresql/8.3/main/pg_hba.conf'))
2008-11-22 01:20:24 ERROR : ERROR: absolute path not allowed
CONTEXT: SQL function "pg_file_length" statement 1
From | Date | Subject | |
---|---|---|---|
Next Message | Ciprian Dorin Craciun | 2008-11-22 06:50:45 | Re: Using Postgres to store high volume streams of sensor readings |
Previous Message | Zagato | 2008-11-22 06:08:15 | Re: Interval Format |