X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AED2B3A5B94 for ; Wed, 12 Jan 2005 01:53:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18158-08 for ; Wed, 12 Jan 2005 01:53:15 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id B7D063A5B84 for ; Wed, 12 Jan 2005 01:53:17 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id j0C1rD26050692 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Tue, 11 Jan 2005 18:53:16 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id j0C1rDWR019397; Tue, 11 Jan 2005 18:53:13 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id j0C1rCCq019396; Tue, 11 Jan 2005 18:53:12 -0700 (MST) (envelope-from mfuhr) Date: Tue, 11 Jan 2005 18:53:12 -0700 From: Michael Fuhr To: Hector Rosas Cc: pgsql-admin@postgresql.org Subject: Re: About user administration Message-ID: <20050112015312.GA91219@winnie.fuhr.org> Reply-To: pgsql-admin@postgresql.org References: <25266c5c0501111353275a0864@mail.gmail.com> <20050111222330.GA29431@winnie.fuhr.org> <25266c5c050111154940597169@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <25266c5c050111154940597169@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/80 X-Sequence-Number: 15939 On Tue, Jan 11, 2005 at 04:49:50PM -0700, Hector Rosas wrote: > Well I came from a mysql environment where I give permision to certain > user with some ip, identified by some password and other things. While > reading the documentation, I didn't find anything about that, I read > about that create user, but later, I had to modify pg_hba.conf but > didn't know about that till someone told me, and other things like > creating a user, the user can connect but cannot read any table. > Things like that, that aren't documented in the standard > documentation, All of those things are in the documentation. Did you read the chapters entitled "Database Users and Privileges" and "Client Authentication"? Those chapter titles are obvious and they're visible in the documentation's top-level Table of Contents, so it would be hard to claim that the information was buried where you couldn't find it. > I hope I explainen my self, and if you know about any good doc to > read,please tell me. Thanks The PostgreSQL documentation is quite good -- many people have learned the software thoroughly using nothing else, so give it a chance. Go through the Tutorial and at least skim the rest so you know what's there. If you're going to run your own server then do spend some time reading the Server Administration part. -- Michael Fuhr http://www.fuhr.org/~mfuhr/