[ADMIN] psql shell with no password prompt

Hi, I created several SQL that are automatically executed via windows task scheduler, here is an example psql -U "dbadmin" -d mydb -f D:\script.sql It was running well until I changed the user (to open a session) associated to these task. The script prompt for a password for user dbadmin. How to

Re: [ADMIN] psql shell with no password prompt

Thanks Kevin, Which of these 2 methods is the best practice? It is working with pgpass. But not yet with hba.conf I tried this without success. hostall all 127.0.0.1/32 trust steve "Kevin Grittner" 27/07/2010 01:17 PM A , cc Objet Re: [ADMIN] psql shell with

[ADMIN] exceeded MAX_ALLOCATED_DESCS while trying to open file

Hi, Using postgres 9.2, I created a FOREIGN TABLE on a csv file. It works. But I need to change the structure of the data and I created several sql select using union, like select from .foreign table... where... union select from .foreign table... where... union ... It works for the firs

Re: [ADMIN] exceeded MAX_ALLOCATED_DESCS while trying to open file

The csv has 34 columns and I need to create a crosstab (using 8 columns so I can't use built in crosstab functions). That is why I need to make several sql select. I'm using foreign table so my client can update is csv file without having to run the ETL to update a table in postgres. Using tem