Re: [GENERAL] pg_role vs. pg_shadow or pg_user

The 8.1 version of the docu explicitly outlined the migration, the 9.1 version no longer covers the way things were before 8.1. In the meantime I also found which cleared things up exhaustively and by example. Alex Am 14.

Re: [GENERAL] pg_role vs. pg_shadow or pg_user

Alexander Reichstadt writes: > in the documentation of 8.1 the concept of roles is outlined compared > to users and groups at > . Um ... why are you reading 8.1 documentation while running 9.1? There are likely to be some obsolete things

Re: [GENERAL] pg_role vs. pg_shadow or pg_user

You only get pg_shadow entries for roles that can login (rolcanlogin = true). CREATE ROLE defaults to NO LOGIN. CREATE USER defaults to LOGIN. See http://www.postgresql.org/docs/9.1/interactive/sql-createrole.html _

[GENERAL] pg_role vs. pg_shadow or pg_user

Hi, in the documentation of 8.1 the concept of roles is outlined compared to users and groups at . I am running 9.1 and due to currently learning about the ins and outs of users and permissions in postgres as opposed to mysql, and becau