Editing config files which are not in database directory

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Editing config files which are not in database directory
Date: 2009-10-01 08:11:35
Message-ID: 192CACC5E9234CADB2E08D69E91B343C@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Debian server standard installation places pg_hba.conf, pg_ident.conf,
postgresql.conf , start.conf files to /etc/postgresql/8.3/data
Database cluster is in /var/lib/postgresql/8.3/data

Trying to edit pg_hba.conf and postgresql.conf from pgAdmin 1.10.0 from
windows causes errors and shows empty file:

ERROR: absolute path not allowed
CONTEXT: SQL function "pg_file_length" statement 1
STATEMENT: SELECT pg_file_read('/etc/postgresql/8.3/data/pg_hba.conf', 0,
pg_file_length('/etc/postgresql/8.3/data/pg_hba.conf'))

ERROR: could not stat file "postgresql.conf": No such file or directory
CONTEXT: SQL function "pg_file_length" statement 1
STATEMENT: SELECT pg_file_read('postgresql.conf', 0,
pg_file_length('postgresql.conf'))

How to edit conf files from pgAdmin in this case?

Andrus.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2009-10-01 08:18:21 Re: Editing config files which are not in database directory
Previous Message Dan Halbert 2009-09-30 23:24:18 Re: Viewing TEXT objects