Re: Editing config files which are not in database directory
| От | Dave Page |
|---|---|
| Тема | Re: Editing config files which are not in database directory |
| Дата | |
| Msg-id | 937d27e10910010118k30341d50j5dafdf80b934994b@mail.gmail.com обсуждение исходный текст |
| Ответ на | Editing config files which are not in database directory ("Andrus" <kobruleht2@hot.ee>) |
| Ответы |
Re: Editing config files which are not in database directory
|
| Список | pgadmin-support |
2009/10/1 Andrus <kobruleht2@hot.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
В списке pgadmin-support по дате отправления: