pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedchanging pb_hba.conf file with pgadmin3
5+ messages / 3 participants
[nested] [flat]
* changing pb_hba.conf file with pgadmin3
@ 2014-01-14 18:37 Jose Gilney <jgilney@gmail.com>
2014-01-14 18:53 ` Re: changing pb_hba.conf file with pgadmin3 Rosser Schwarz <rosser.schwarz@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Jose Gilney @ 2014-01-14 18:37 UTC (permalink / raw)
To: pgsql-admin
Is it possible to edit pg_hba.conf of a postgresql cluster running on a
linux (debian) server, from my pgadmin application running on windows 7?
If so, what are the steps to accomplish that?
I appreciate your help.
Gilnei
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: changing pb_hba.conf file with pgadmin3
2014-01-14 18:37 changing pb_hba.conf file with pgadmin3 Jose Gilney <jgilney@gmail.com>
@ 2014-01-14 18:53 ` Rosser Schwarz <rosser.schwarz@gmail.com>
2014-01-14 19:35 ` Re: changing pb_hba.conf file with pgadmin3 Korry Douglas <korry.douglas@enterprisedb.com>
0 siblings, 1 reply; 5+ messages in thread
From: Rosser Schwarz @ 2014-01-14 18:53 UTC (permalink / raw)
To: Jose Gilney <jgilney@gmail.com>; pgsql-admin
On Tue, Jan 14, 2014 at 10:37 AM, Jose Gilney <jgilney@gmail.com> wrote:
> Is it possible to edit pg_hba.conf of a postgresql cluster running on a
> linux (debian) server, from my pgadmin application running on windows 7?
>
No, that's not possible, and probably won't ever be. Consider the security
implications of enabling that kind of thing...
rls
--
:wq
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: changing pb_hba.conf file with pgadmin3
2014-01-14 18:37 changing pb_hba.conf file with pgadmin3 Jose Gilney <jgilney@gmail.com>
2014-01-14 18:53 ` Re: changing pb_hba.conf file with pgadmin3 Rosser Schwarz <rosser.schwarz@gmail.com>
@ 2014-01-14 19:35 ` Korry Douglas <korry.douglas@enterprisedb.com>
2014-01-14 19:47 ` Re: changing pb_hba.conf file with pgadmin3 Rosser Schwarz <rosser.schwarz@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Korry Douglas @ 2014-01-14 19:35 UTC (permalink / raw)
To: Rosser Schwarz <rosser.schwarz@gmail.com>; +Cc: Jose Gilney <jgilney@gmail.com>; pgsql-admin
> On Tue, Jan 14, 2014 at 10:37 AM, Jose Gilney <jgilney@gmail.com
> <mailto:jgilney@gmail.com>> wrote:
>
> Is it possible to edit pg_hba.conf of a postgresql cluster running
> on a linux (debian) server, from my pgadmin applicationrunning on
> windows 7?
>
>
> No, that's not possible, and probably won't ever be. Consider the
> security implications of enabling that kind of thing...
pgadmin could use the new ALTER SYSTEM command (coming in 9.4)
http://www.depesz.com/2014/01/09/waiting-for-9-4-add-alter-system-command-to-edit-the-server-configu...
-- Korry
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: changing pb_hba.conf file with pgadmin3
2014-01-14 18:37 changing pb_hba.conf file with pgadmin3 Jose Gilney <jgilney@gmail.com>
2014-01-14 18:53 ` Re: changing pb_hba.conf file with pgadmin3 Rosser Schwarz <rosser.schwarz@gmail.com>
2014-01-14 19:35 ` Re: changing pb_hba.conf file with pgadmin3 Korry Douglas <korry.douglas@enterprisedb.com>
@ 2014-01-14 19:47 ` Rosser Schwarz <rosser.schwarz@gmail.com>
2014-01-14 20:27 ` Re: changing pb_hba.conf file with pgadmin3 Korry Douglas <korry.douglas@enterprisedb.com>
0 siblings, 1 reply; 5+ messages in thread
From: Rosser Schwarz @ 2014-01-14 19:47 UTC (permalink / raw)
To: Korry Douglas <korry.douglas@enterprisedb.com>; +Cc: Jose Gilney <jgilney@gmail.com>; pgsql-admin
On Tue, Jan 14, 2014 at 11:35 AM, Korry Douglas <
korry.douglas@enterprisedb.com> wrote:
> pgadmin could use the new ALTER SYSTEM command (coming in 9.4)
>
ALTER SYSTEM is for setting (some — specifically, runtime configurable)
postgresql.conf directives, not pg_hba.conf rules. See <
http://www.postgresql.org/docs/devel/static/sql-altersystem.html;
Assume for a moment that you could change hba rules with ALTER SYSTEM: what
happens if a malicious user were to add a "host all all 0.0.0.0/0 reject"
rule? Or, perhaps worse, "host all postgres 0.0.0.0/0 trust"?
rls
--
:wq
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: changing pb_hba.conf file with pgadmin3
2014-01-14 18:37 changing pb_hba.conf file with pgadmin3 Jose Gilney <jgilney@gmail.com>
2014-01-14 18:53 ` Re: changing pb_hba.conf file with pgadmin3 Rosser Schwarz <rosser.schwarz@gmail.com>
2014-01-14 19:35 ` Re: changing pb_hba.conf file with pgadmin3 Korry Douglas <korry.douglas@enterprisedb.com>
2014-01-14 19:47 ` Re: changing pb_hba.conf file with pgadmin3 Rosser Schwarz <rosser.schwarz@gmail.com>
@ 2014-01-14 20:27 ` Korry Douglas <korry.douglas@enterprisedb.com>
0 siblings, 0 replies; 5+ messages in thread
From: Korry Douglas @ 2014-01-14 20:27 UTC (permalink / raw)
To: Rosser Schwarz <rosser.schwarz@gmail.com>; +Cc: Jose Gilney <jgilney@gmail.com>; pgsql-admin
> On Tue, Jan 14, 2014 at 11:35 AM, Korry Douglas
> <korry.douglas@enterprisedb.com
> <mailto:korry.douglas@enterprisedb.com>> wrote:
>
> pgadmin could use the new ALTER SYSTEM command (coming in 9.4)
>
> ALTER SYSTEM is for setting (some — specifically, runtime
> configurable) postgresql.conf directives, not pg_hba.conf rules. See
> <http://www.postgresql.org/docs/devel/static/sql-altersystem.html;
Ah right... sorry I misread the original question.
-- Korry
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2014-01-14 20:27 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-01-14 18:37 changing pb_hba.conf file with pgadmin3 Jose Gilney <jgilney@gmail.com>
2014-01-14 18:53 ` Rosser Schwarz <rosser.schwarz@gmail.com>
2014-01-14 19:35 ` Korry Douglas <korry.douglas@enterprisedb.com>
2014-01-14 19:47 ` Rosser Schwarz <rosser.schwarz@gmail.com>
2014-01-14 20:27 ` Korry Douglas <korry.douglas@enterprisedb.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox