postgreSQL permission problems

[Tom Emerson]

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