From: | Tim Uckun <timuckun(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: I can't seem to put the right combination of magic into the pg_hba and pg_ident files. |
Date: | 2009-11-09 04:08:46 |
Message-ID: | 855e4dcf0911082008v72789fc1h129636d240edc69@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> I suspect you are expecting that the map will cause root to be
> logged in as postgres without asking for that. It won't.
> What it will do is allow "psql -U postgres" and similar to work.
That's exactly what I am looking to do. In my case I have a script
that runs as root. I want to log in as postgres user from that script
but the script is running as root.
The way I have it set up doesn't permit that. I want to know what I
need to do in order to make that happen.
>
> BTW, one has to wonder why you are using the root account for this
> work in the first place. Wouldn't it be a lot more secure to use
> a less privileged account (oh, I don't know, maybe postgres)?
>
This script is a part of the initial setup script for the server. It
has to run as root because when it starts running postgres is not
installed and there is no postgres user.
From | Date | Subject | |
---|---|---|---|
Next Message | Jukka Inkeri | 2009-11-09 05:15:22 | Re: Problem to use remote cygwin server using ssh and native psql 8.3.5 |
Previous Message | Chris | 2009-11-09 04:07:47 | Re: question about using pgmemcache |