Create database from command line

Question

I  m trying to create a data base from command line  My OS is centos and postgres version is 10 9   sudo -u postgres psql createdb test Password for user test    Why asking me by user

User · Answer

PGPORT 5432 PGHOST  my database domain com  PGUSER  postgres  PGDB  mydb  createdb -h  PGHOST -p  PGPORT -U  PGUSER  PGDB

User · Answer

As the default configuration of Postgres  a user called postgres is made and the user postgres has full super admin access to entire PostgreSQL instance running on your OS   sudo -u postgres psql   The above command gets you the psql command line interface in admin mode   Creating user  sudo -u postgres createuser  lt username gt    Creating Database   sudo -u postgres createdb  lt dbname gt    NOTE   lt    are not to be used while writing command  they are used just to signify the variables

User · Answer

Change the user to postgres    su - postgres   Create User for Postgres    createuser testuser   Create Database    createdb testdb   Acces the postgres Shell  psql   enter the password for postgressql    Provide the privileges to the postgres user    alter user testuser with encrypted password  qwerty     grant all privileges on database testdb to testuser

User · Answer

PostgreSQL Create Database - Steps to create database in Postgres   Login to server using postgres user su - postgres  Connect to postgresql database   bash-4 1  psql psql  12 1  Type  help  for help  postgres    Execute below command to create database   CREATE DATABASE database name  Check for detailed information below  https   orahow com postgresql-create-database

User · Answer

Try   sudo -u postgres psql -c  create database test

User · Answer

As some of the answers point out  createdb is a command line utility that could be used to create database   Assuming you have a user named dbuser  the following command could be used to create a database and provide access to dbuser   createdb -h localhost -p 5432 -U dbuser testdb   Replace localhost with your correct DB host name  5432 with correct DB port  and testdb with the database name you want to create   Now psql could be used to connect to this newly created database   psql -h localhost -p 5432 -U dbuser -d testdb   Tested with createdb and psql versions 9 4 15

User · Answer

createdb is a command line utility which you can run from bash and not from psql  To create a database from psql  use the create database statement like so   create database  databasename     Note  be sure to always end your SQL statements with

[postgresql] Create database from command line

Examples related to postgresql