Hi John,
Thanks for the replies.
The problem was the ident in the host. Problem solved.
Thanks a lot!
Best Regards,
On Fri, Dec 2, 2011 at 11:46 PM, John R Pierce wrote:
> On 12/02/11 3:41 PM, Andre Lopes wrote:
>>
>> My pg_hba.conf have this:
>> [code]
>> # TYPE DATABASE USER
On 12/02/11 3:41 PM, Andre Lopes wrote:
My pg_hba.conf have this:
[code]
# TYPE DATABASEUSERCIDR-ADDRESSMETHOD
# "local" is for Unix domain socket connections only
local all all ident
# IPv4 local connections:
hos
Hi Adrian,
Thanks for the reply.
My pg_hba.conf have this:
[code]
# TYPE DATABASEUSERCIDR-ADDRESSMETHOD
# "local" is for Unix domain socket connections only
local all all ident
# IPv4 local connections:
hostal
On 12/02/11 3:13 PM, Andre Lopes wrote:
[code]
Exception Value:
FATAL: Ident authentication failed for user "mypoatgreuser"
[/code]
There is more permissions that I must to give to the user
"mypoatgreuser"? What could be wrong here?
'ident' is the default authentication type for local
On Friday, December 02, 2011 3:13:41 pm Andre Lopes wrote:
> Hi,
>
> I've installed PostgreSQL 9.0 in CentOS6 I don't have configured
> anything in Postgre, I just created a user with this method:
>
>
> With the method above I have no problems in enter "psql" but when I
> try to connect with th
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andre Lopes
Sent: Friday, December 02, 2011 6:14 PM
To: postgresql Forums
Subject: [GENERAL] Can't access to database from webapp in PostgreSQL 9.0, from
shell it
Hi,
I've installed PostgreSQL 9.0 in CentOS6 I don't have configured
anything in Postgre, I just created a user with this method:
[article]
Here is how I do to create a Postgres user with the same username as
my regular login in Linux Ubuntu.
Go to your terminal with your regular user and do:
{