Postgres - How to use psql to create a database with the -c command and password authentication?

Question

If I run the following:

psql -h localhost -U admin -c "CREATE DATABASE sales OWNER admin;"

It returns:

psql FATAL: database "admin" does not exist

I need to use password authentication and have setup .pgpass as follows:

localhost:*:*:admin:admin

Any ideas?

Craig Ringer · Accepted Answer · 2014-02-01 05:00:05Z

2

By default, when you connect as a user, the database connected to is the DB of the same name as the user.

If you want to connect to a different DB, you must specify it in the psql command line. Since in this case you're trying to create the DB, you can't connect to it yet, you must connect to another DB (like template1 or postgres) that already exists.

E.g.

psql -h localhost -U admin template1 -c "CREATE DATABASE sales OWNER admin;"
                           ^^^^^^^^^

answered Feb 1, 2014 at 5:00

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

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

Collectives™ on Stack Overflow

Postgres - How to use psql to create a database with the -c command and password authentication?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related