search for: pgpass

Hi, I noticed that, on Windows at least, if I have a password set in the database.yml file for a database that I also have in my pgpass.conf file, the Rails adapter will die with a password authentication error. I don''t seem to have this issue on Unix systems. It''s simple enough to solve - just comment out the password info in the database.yml file. I just wondered if there was a more generic solution (other tha...

...urrent -> /var/data/hll_th/hll_th_forex_rss/releases/20140214211431 │?? ├── releases │?? └── shared ├── log ├── lost+found └── pgpass -> .pgpass The questions I have are: What is an appropriate SELinux context for such a directory structure given it is used by a httpd service? Is the default user home setting of system_u:object_r:home_root_t acceptable? Is system_u:object_r:httpd_sys_content_t preferable instead? is some o...

...ample.com dbname=virtual user=virtual There is a reference to identify the rest of the parameters via libpq in the postgres documentation. From postgres, libpq says the connection environment variables are: hostname:port:database:username:password http://www.postgresql.org/docs/7.4/static/libpq-pgpass.html Should the dovecot-pgsql.conf docs be changed from "dbname=users" to "database=users" ??

...;SKIP_POSTGRESSQL") == "")) { tests } Then, if variables like POSTGRES_USER, POSTGRES_HOST, POSTGRES_DATABASE (more on DATABASE below) are found they will be used, otherwise nothing is specified and the drivers will typically read values from configuration files like .my.cnf and .pgpass. It would be nice to have a mechanism for examples, vignettes, and demos, but I don't see any nice way to do this. Paul Gilbert wrote: >> However, there is still a problem of potential conflicts on database >> "test" if parallel testing occurs. (I've had this pro...

I have a shell script (sh) where I create a user and import data to a postgres database <snip> su -c "createuser -A -D -P $PG_user" postgres su -c "psql -d$PG_database -h localhost -U$PG_user -W -f postgresql.sql " postgres </snip> when the script executes those command, it ask for a password, how could I do this without have to enter the passwd, I would like that