PostgreSQL - Execute SQL error

4 posts / 0 new
Last post
#1 Mon, 08/27/2007 - 03:30
rfs1970

PostgreSQL - Execute SQL error

Hi There,

I am using virtualmin pro and When I try to execute a sql script into a postgresql database i get the error:

psql: FATAL: Ident authentication failed for user "postgres"

Someone could help me to fix that issue?

Thank you,

r.

Tue, 08/28/2007 - 13:53
rfs1970

Hi There,

Nobody can help me?
:(

Wed, 08/29/2007 - 08:32 (Reply to #2)
Joe
Joe's picture

This doesn't look like you're using the Webmin PostgreSQL module. Looks like you're hitting it from the command line, maybe? Or maybe PostgreSQL has been configured differently from the defaults...

You'll want to start by browsing to the Webmin:Servers:PostgreSQL module and see if things work. If not, it'll give you an error that we can probably do something with. This one seems to indicate that PostgreSQL is only allowing ident authentication, which doesn't make any sense (I don't think...but maybe it depends on the platform and how it was installed).

--

Check out the forum guidelines!

Wed, 08/29/2007 - 15:45
Renato

Hi Joe,

Thank you for your reply.

That is my situation:
I am using Virtualmin pro in Ubuntu 6.10 server
I can normally access the postgresql module at the Server Webmin section,
and I can stop and start the postgre server using the buttons in webmin.

This problem occurs when I try to upload a file(/sql query) into a database:

Output from uploaded SQL commands ..
psql: FATAL: Ident authentication failed for user "postgres"

r.

Topic locked