How to create a user for Postgres from the command line for bash automation

postgresql ubuntu postgresql-9.2
Tampa picture Tampa · Sep 10, 2013 · Viewed 83.8k times · Source

I am using Ubuntu 12.04 and Postgress 9.2.

I need to create this user with this password e.g.

postgres://admin:[email protected]:5432

How to do that from the command line? I need to automate with a bash script. I have a fresh install.

Answer

Tomas Greif picture Tomas Greif · Sep 10, 2013

This will create user admin with password test101 on localhost:

psql -c "CREATE USER admin WITH PASSWORD 'test101';"

Related questions

Postgresql 9.2 installation on Ubuntu 12.04

For installing postgresql 9.2 I followed this url : http://www.ubuntugeek.com/how-to-install-postgresql-9-2-on-ubuntu-server-using-ppa.html But at the end of installation output is like : Setting up postgresql-common (140~precise) ... locale: Cannot set LC_MESSAGES to default locale: No such file or …

Read More
Postgresql: password authentication failed for user "postgres"

I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user "postgres" for both console client and Pgadmin. I have typed user as "postgres" and password "postgres", because it worked before. But now authentication is failed. I did it …

Read More
How to thoroughly purge and reinstall postgresql on ubuntu?

Somehow I've managed to completely bugger the install of postgresql on Ubuntu karmic. I want to start over from scratch, but when I "purge" the package with apt-get it still leaves traces behind such that the reinstall configuration doesn't run …

Read More