Re: Bug#21681: postgresql: Doesn't allow granting to www-data - Mailing list pgsql-hackers

From Oliver Elphick
Subject Re: Bug#21681: postgresql: Doesn't allow granting to www-data
Date
Msg-id 199804281104.MAA21814@linda.lfix.co.uk
Whole thread Raw
List pgsql-hackers
John Goerzen wrote:

  >>                 Were you able to create a user `www-data'?
  >> I get:
  >
  >I believe that the createuser script did it for me.

Yes, it does.  Very inconsistent!

  >> I agree that there is a bug, but it is that the error message is wrong!
  >
  >If grant would permit the username to be quoted in ' characters, then
  >the problem ought to go away, I think.

Currently, it appears that the authors don't want to change, so it is
necessary to specify a postgres user-id when connecting.

However there is, as you say in another mail, no convenient way of
doing that automatically.  We need an environment variable or a
command-line option to specify the user and (optionally) password.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver

PGP key from public servers; key ID 32B8FAA1

                 ========================================
    Come to me, all you who labour and are heavily laden, and I will
    give you rest. Take my yoke upon you, and learn from me; for I am
    meek and lowly in heart, and you shall find rest for your souls.
    For my yoke is easy and my burden is light.    (Matthew 11: 28-30)



pgsql-hackers by date:

Previous
From: Ralf Berger
Date:
Subject: Re: [QUESTIONS] Postgres still dying on insert
Next
From: "Oliver Elphick"
Date:
Subject: Patch for createuser to make it consistent with CREATE USER