> then say you're postgres in the script with the -U (if you're using psql)
>
> AS ROOT:
> psql -U postgres -h remote_db dbname
>
> Note that ident doesn't work so well between machines, so you might
> want to look at .pgpass
>
That's what I am trying to get working. In actuality I am using ruby
and using a db library but the concept is the same. I need to log in
as postgres when the script is running as root. I could trust all
local connections or something but I don't want to do that either.
When I do a psql -U postgres I get this
psql -U postgres
psql: FATAL: Ident authentication failed for user "postgres"
Obviously I need to tell postgres to trust the user root when
connected locally as postgres.
How do I do that?