Run PostgreSQL function to db located on Linux, from Windows command line

Question

I'm trying to call PostgreSQL function from windows command line. the Postgres DB located on a Linux VM. I can run the command line but been prompted for password. How can I work around it?

Since the DB is on different VM, I can't modify the pgpass.conf file, it doesn't exist. any other easy way?

khampson · Accepted Answer · 2014-06-07 03:20:09Z

1

You can run psql on Windows to run a SELECT query that calls the function. To prevent psql from prompting for a password, you can set the password in the PGPASSWORD environment variable.

Optionally, for something which is generally considered somewhat more secure, you could use the pgpass file, which on Windows is located in %APPDATA%\postgresql\pgpass.conf and store the password in there. More details on that can be found here: http://www.postgresql.org/docs/9.3/static/libpq-pgpass.html

answered Jun 7, 2014 at 3:20

khampson

15.5k4 gold badges45 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

khampson Over a year ago

Cool. Since it appears to have solved your issue, please accept my answer.

Collectives™ on Stack Overflow

Run PostgreSQL function to db located on Linux, from Windows command line

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related