On 11/21/19 1:52 PM, stan wrote:
On Thu, Nov 21, 2019 at 12:14:16PM -0800, Adrian Klaver wrote:
5) Now in your case you have peer auth(first in the list) for local socket
connections which means a user can only connect on the local socket as the
db postgres user if they are also the os postgr
On Thu, Nov 21, 2019 at 12:14:16PM -0800, Adrian Klaver wrote:
> On 11/21/19 11:09 AM, stan wrote:
> >
>
> > > It would help if you could spell out what you want to achieve, as I am
> > > sure
> > > it has been done before by multiple people on this list.
> > >
> >
> > Can do.
> >
> > At th
On 11/21/19 11:09 AM, stan wrote:
It would help if you could spell out what you want to achieve, as I am sure
it has been done before by multiple people on this list.
Can do.
At the moment, I have 2 instances one production and one sandbox. I want to
be able to run pg_dump -d "production
On Thu, Nov 21, 2019 at 08:18:08AM -0800, Adrian Klaver wrote:
> On 11/21/19 8:12 AM, stan wrote:
> Please reply to list also
> Ccing list.
> > On Thu, Nov 21, 2019 at 07:56:10AM -0800, Adrian Klaver wrote:
> > > On 11/21/19 6:35 AM, stan wrote:
>
> > > > If the 1st rule matches, I am thinking t
On 11/21/19 8:12 AM, stan wrote:
Please reply to list also
Ccing list.
On Thu, Nov 21, 2019 at 07:56:10AM -0800, Adrian Klaver wrote:
On 11/21/19 6:35 AM, stan wrote:
If the 1st rule matches, I am thinking this will override any rule I put in
after such as:
local all postgres md5
Is my unde
On 11/21/19 6:35 AM, stan wrote:
Thanks, found it, I believe:
local all postgres
Good to know first match wins, that is different than some other systems I
am used to.
OK, there appears to be a bit more than I thought to this. Here is the line I
believe is causing me issues:
On Thu, Nov 21, 2019 at 09:15:02AM -0500, stan wrote:
> On Thu, Nov 21, 2019 at 02:05:09PM +0100, Magnus Hagander wrote:
> > On Thu, Nov 21, 2019 at 1:46 PM stan wrote:
> >
> > > I am trying to set up to do some work with pg_dump, and I would like to be
> > > able to connect from my normal user
On Thu, Nov 21, 2019 at 02:05:09PM +0100, Magnus Hagander wrote:
> On Thu, Nov 21, 2019 at 1:46 PM stan wrote:
>
> > I am trying to set up to do some work with pg_dump, and I would like to be
> > able to connect from my normal user to do this. This is on a Ubunt 18.04
> > installation. I have add
On Thu, Nov 21, 2019 at 1:46 PM stan wrote:
> I am trying to set up to do some work with pg_dump, and I would like to be
> able to connect from my normal user to do this. This is on a Ubunt 18.04
> installation. I have added the follwing to pg_hba.conf:
>
> hostall all
I am trying to set up to do some work with pg_dump, and I would like to be
able to connect from my normal user to do this. This is on a Ubunt 18.04
installation. I have added the follwing to pg_hba.conf:
hostall all 0.0.0.0/0 md5
hostssl all al
10 matches
Mail list logo
