could not create local user with password authentication

[maxadamo]

Describe the Bug

in order to create a user with password, which authenticates over the socket, I need an entry like this one:

local   user     db         md5

but this entry should be placed before this one:

# Order: 2
local   all     all             ident

however, this is Order 2 and Order 1 is already taken.

Expected Behavior

All the stanzas after 1 should be shifted, at least by 10 positions.

Steps to Reproduce

create a rule like this:

local   user     db         md5

it will never work, because this one takes precedence:

local   all     all             ident

Environment

• Version: not applicable (this code is still the same in the main branch)
• Platform: not applicable

Additional Context

None

[maxadamo]

a possible workaround is to set value for the key order to a negative number.