I'm trying to create db on PostgreSQL on linux machine. And I use following command to create the DB.
createdb mydbname;
This is throwing following error.
createdb: could not connect to database postgres: FATAL: database "postgres" does not exist
I'm new to PostgreSQL. Can you please guide me to go through this error? Simply I want to create a DB on psql.
It looks like you dropped the postgres database. It's the default used for many admin operations, so you might want to re-create it:
createdb --maintenance-db=template1 -T template0 postgres;
What that's doing is connecting to the built-in DB template1 in order to create the db postgres by making a copy of template0.
Once that's done, your command:
createdb mydbname;
will work as normal.
createdb: illegal option -- d Try "createdb --help" for more information. createdb: database creation failed: ERROR: syntax error at or near "TABLESPACE" at character 26createdb -T template1 postgres; it mean change the -d to -D. Then my issue is fixed. Was that the the command you wanted to execute?-T. The solution is working fine. then I can mark it as correct answer.-D to -T on the answer I can make it as green. It will be useful to others.su - postgres change user to postgres
psql - run psql terminal
postgres# create database somedatabase create database;
postgres#\c somedatabase connecto to database
somedatabase# your are connected to that database as postgres user
psql give error like follows (psql: FATAL: database "postgres" does not exist)
sudo service postgresql start or alikepsql -U postgres -l to list all the databases. You should have postgres database.su - postgres change user to postgres
createdb
createdb somedatabase
psql somedatabase
The first line changes to the postgres system user. The second line creates a database for the postgres admin user. The third line creates the database you were trying to make. The fourth line connects to it as the postgres user.
