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

Re: Editing config files which are not in database directory

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Editing config files which are not in database directory
Date: 2009-10-01 08:18:21
Message-ID: 937d27e10910010118k30341d50j5dafdf80b934994b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
2009/10/1 Andrus <kobruleht2(at)hot(dot)ee>:
> 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?

Unless you're running pgAdmin directly on the server, you can't I'm
afraid. This is a security restriction in the adminpack contrib module
in PostgreSQL itself.


-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

In response to

Responses

pgadmin-support by date

Next:From: AndrusDate: 2009-10-01 09:02:20
Subject: Re: Editing config files which are not in database directory
Previous:From: AndrusDate: 2009-10-01 08:11:35
Subject: Editing config files which are not in database directory

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