postgresql password from .pgpass
От | cipriani@Argentina.com |
---|---|
Тема | postgresql password from .pgpass |
Дата | |
Msg-id | 410521C2000011E7@webmail.argentina.com обсуждение исходный текст |
Список | pgsql-general |
I have a problem connecting to the database.I'm trying to execute pg_dump command from a user's $HOME (Linux User). which have a .pgpass. The .pgpass is like this and his permissions are 600 and belongs to a Linux User. localhost:5432:databasename:databaseuser:databaseuser The command iam executing is $/var/lib/pgsql/bin/pg_dump -U databaseuser databasename >database.sql The password's user is plain in the database, put when you try to connect with this command always require a password the pg_hba.conf is like this and his permissions are 622 and belongs to the postgres user. # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all password host all all 127.0.0.1 255.255.255.255 password host all all 192.168.0.0 255.255.0.0 password Please Help me for more details mail me to: cipriani@argentina.com --- E-mail y acceso a Internet UltraVeloz totalmente GRATIS en 25 ciudades, Nro. de acceso 5500-5500 Usuario: Argentina Password: Argentina http://www.Argentina.com
В списке pgsql-general по дате отправления: