Run PostgreSQL CLI (psql) in bash script without password prompt?

Question

Running the PostgreSQL CLI (psql) through a bash script as user postgres causes a password prompt to be sent, even though I can run it manually without a password. When I try to put -w in the script, this error occurs:

psql: fe_sendauth: no password supplied

Can I run psql in an automated way without a password?

possible duplicate of Postgresql: Scripting psql execution with password — mu is too short
– mu is too short, Commented May 4, 2012 at 18:51

BluesRockAddict · Accepted Answer · 2012-05-04 18:26:04Z

12

You can use password file pgpass.conf or use PGPASSWORD variable.

For local development or if security isn't an issue, you could also configure PostgreSQL to run in trust authentication mode by modifying your pg_hba.conf file.

answered May 4, 2012 at 18:26

BluesRockAddict

15.6k3 gold badges40 silver badges35 bronze badges

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

1 Comment

Pablo Santa Cruz Over a year ago

Nice! Didn't know about the PGPASSWORD variable.

Pablo Santa Cruz · Accepted Answer · 2012-05-04 18:25:29Z

1

You can, as long as you are OK with not having authentication for that specific user connecting from the host where script is running. For this, you just add the following line to pghba.conf on your server (you will need to restart PostgreSQL daemon):

host YOUR_DB YOUR_USER YOUR_IP trust

Where:

YOUR_DB: database name
YOUR_USER: user you are using to run the script
YOUR_IP: IP where script runs

Other option could be using expect utility (assuming you are using linux or some unix variant or shell such as cygwin).

answered May 4, 2012 at 18:25

Pablo Santa Cruz

182k33 gold badges250 silver badges300 bronze badges

Collectives™ on Stack Overflow

Run PostgreSQL CLI (psql) in bash script without password prompt?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related