Re:The Number One Trait of a Great Developer
by skyebook on Tuesday September 03, 2013 @10:51AM
(#6321280)
As someone who moved from MySQL to Postgres, the only thing that took some getting used to was users being actual Unix users that you create and then grant access to. At the time it seemed odd considering what MySQL did but it ended up being a feature I like quite a bit.
[ Parent
| on HN ]
Re:The Number One Trait of a Great Developer
by fusiongyro on Tuesday September 03, 2013 @11:11AM
(#6321382)
PG roles are stored in the DB, not Unix. You can set up pg_hba to use ident authentication so that users are automatically granted access by their Unix login, but it isn't the default (and usually not recommended), and you still have to have PG roles in the database for them to correspond to. So I think there's been a misunderstanding.