Hi,
I'm in the process of quoting a completely free software solution to a
client, and need to make the choice of software attractive with
feature lists (I know PgSQL is the Ultimate Database, but how do I
convince the buyer? :-)
You won't believe that I spent more than 4 hours last night, tryin
Jozef KRSSAK writes:
> 4. name of my account:
> krssak
>
> 5. pg_hba.conf:
> local rocnikovy trust
> hostrocnikovy 127.0.0.1 255.255.255.255 ident map
>
> 6. pg_ident.conf:
> map krssak jozok
>
> 7. create user jozok;
> 9.
> krssak@p
>This is just a guess, which may be wrong as you did not post your postmaster
>options and the error message explicitly points out IDENT as the culprit. If
>my guess is wrong, your IDENT setup would be a good place to look (and
>tcpwrappers or anything else that might affect).
IDENT setup is OK,
sorry, I want to say:
PGALLOWTCPIP=yes
but nothing
krssak@pec:~$ psql -h localhost -d rocnikovy
Connection to database 'rocnikovy' failed.
IDENT authentication failed for user 'krssak'
krssak@pec:~$
Jozef Krssak
---(end of broadcast)---
TIP 4: D
of course:
postmaster.init:
PGALLOWTCPIP=yes
---
Jozef KRSSAK
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hi,
>From my UNIX login, which is a valid user for the database too, I connect to
database. I don't have permission to add, delete, view system tables till
now.
Now, if I use the command "CONNECT" as user "pgadmin", which is
administrator of the database, the connect succeeds, and now, I am able
