postgreSQL permission problems

[Mike Starke]

Right before Derek replied I figured out the pg_hba file right.
So her was right on. although I have it fairly wide open, I'm able to
get in and evaluate the program.

I do have one question: Someone posted earlier this week about
postgres utilizing the GRANT & REVOKE statements. In MySQL, it is pretty
straightforward (at least to me) what happens when you issue GRANT statements.
How is this handled in postgreSQL? Does it make entries in a table somewhere, or does
it manipulate the pg_hba file? Or?

v/r
mike


:On Fri, Jun 28, 2002 at 01:49:19PM -0700, Tom Emerson wrote:
 Mike, how is the postmaster started?  (postmaster is the postgresql 
 backend server)
 
 There is an option the postmaster needs in order to allow 
 network connections.
 
 Example, looking at the process list (ps ax):
 /usr/local/pgsql/bin/postmaster -i -D /web/pgsql
 
 The "-i" option seen here allows tcp connections, without it, quite a few 
 of the software's can't connect.  If you don't see this "-i" option, that 
 may be your problem.
 
 A typical startup command for the postmaster looks like this (but all on 
 one line!):
 su - postgres -c "/usr/local/pgsql/bin/postmaster -i -D /web/pgsql 
 >logfile 2>&1 &"
 
 
 On Fri, 28 Jun 2002, Mike Starke wrote:
 
 I am attempting to get SQL-Ledger up and running and am running
 into a few problems as it pertains to postgreSQL.
 
 I have done the following:
 
 1. As the user postgres (I'm on a debian sysem btw), I have done:
    'createuser mike'
 
 2. As the user 'mike' I have done:
    'createdb mydb'
 
 3. I can, as user 'mike' do:
    'psql mydb'
    and get to the command line utility.
 
 4. I have also ensured that I have the line"
    'tcpip_socket = 1'
    in /etc/postgresql.conf
 
 5. I have mucked around in /etc/postgresql/pg_hba.conf a bit and not sure
    what I have done in there.
 
 At any rate, when I fire up http://localhost/sqlledger.admin.pl, login, and then try
 to "Create Dataset" under the user 'mike', my linux (mike) password, and connect to 'mydb',
 I get the following error:FATAL 1: IDENT authentication failed for user "mike".
 
 I'm suspect my problems lie within pg_hba.conf, but whatever I do (thinking it is wide open)
 I continue to get the same error message.
 
 Can anyone offer some guidance here?
 
 v/r
 Mike
 ________________________________________________
 See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post to the list quickly and you use Netscape to write mail.
 
 PLUG-discuss mailing list  -  PLUG-discuss@lists.plug.phoenix.az.us
 http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
 
 ________________________________________________
 See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post to the list quickly and you use Netscape to write mail.
 
 PLUG-discuss mailing list  -  PLUG-discuss@lists.plug.phoenix.az.us
 http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss