Re: help (maybe i'm a little stupid)

no :-)
just add

"sameuser" under
DATABASE
in your configuration line in pg_hba.conf

or read this:

# This record identifies networked hosts that are
permitted to connect
# via IP connections.
#
# Format:
#
#   host  DBNAME  IP_ADDRESS  ADDRESS_MASK  AUTH_TYPE
[AUTH_ARGUMENT]
#
# DBNAME can be:
#     o the name of a PostgreSQL database
#     o "all" to indicate all databases
#     o "sameuser" to allow access only to databases with
the same
#       name as the connecting user


so replace "all" with "sameuser" where you need this.

# TYPE     DATABASE    IP_ADDRESS    MASK
 AUTH_TYPE  AUTH_ARGUMENT

local      all
 trust
host       all         127.0.0.1     255.255.255.255
 trust



--- Thomas Beutin <tyrone@laokoon.IN-Berlin.DE> wrote:
> Hi,
>
> On Mon, Jul 15, 2002 at 08:44:39AM +0200, Fabrizio
> wrote:
> > i made a page in php interfacing with postgresql
> server. i had a problem but
> > i solve that one assuming postmaster with options
> -i and specifying port
> > 5432. but then, when i call via browser my page,
> it returns error "fatal1:
> > user apache does not exist...". if i must modify
> pg_hba.conf, how can i do?
> > thanx
> Look for the "createuser" shell command. And don't
> forget to give the permission
> for the tables to this user ("GRANT" command on the
> psql prompt).
> OR
> Connect to the databes as the database super (NOT
> RECOMMENDED).
>
> INHO the best thing is to create an user apache
> without permission for
> database or table creation.
>
> -tb
> --
> Thomas Beutin
> tb@laokoon.IN-Berlin.DE
> Beam me up, Scotty. There is no intelligent live
> down in Redmond.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org


__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com