PostgreSQL - Execute SQL error

Help! (Home for newbies)
1

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.

2

Hi There,

Nobody can help me?
:frowning:

3

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).

4

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.