Difference between users, groups, and roles on Postgres and Redshift

Postgres We’ll start here, because Postgres generally sets the standard for relational databases. In Postgres 9, users and groups were replaced with roles (Postgres have been very kind, and have maintained user and group as aliases for role for backwards compatibility). The difference between users and roles? Simply put, users can now be considered as roles with the ability to login. Redshift Redshift forked from Postgres somewhere … Continue reading “Difference between users, groups, and roles on Postgres and Redshift”


Something went wrong. Please refresh the page and/or try again.

About Me

Hi, I’m Vinay Are. Sr. Database Engineer at Teladoc Health Inc. I spend my time with my daughter and wife when I am not working. In my spare time, I do landscape and macro photography as a hobby. This blog is for my love of databases, a place to store important things I want to remember about databases

Subscribe to My Blog

Get new content delivered directly to your inbox.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: