Skip site navigation (1) Skip section navigation (2)

Re: when to modify..

From: Chris Travers <chris(at)travelamericas(dot)com>
To: Lori <lorid(at)dri(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: when to modify..
Date: 2005-05-11 01:22:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Lori wrote:

> Either Im tired or the documentation is confusing,
> when do I need to modify pg_hba.conf
> vs just doing a
> createuser
> thanks

create user creates a database user account.

pg_hba.conf provides a set of access permissions regarding where and how 
users and/or computers can connect to the database.

You MUST have both permission in the pg_hba.conf AND a valid user 
account to log in.

Does that make sense?

Best Wishes,
Chris Travers
Metatron Technology Consulting

> lori
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

pgsql-admin by date

Next:From: Dave HeldDate: 2005-05-11 13:59:58
Subject: Re: Irrevocable privileges
Previous:From: Alex ShepherdDate: 2005-05-11 00:41:34
Subject: Problem with SSL - Server went 100% Busy

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group