Postgresql creating database

Question

Well I installed the latest postgreql database on my Windows 7.

Now I'm trying to create a database via the psql.exe command line

When I open it, it says

psql: FATAL: database "Jansu" does not exist

So I read somewhere, that when no database is specified, it tried to find database with my username or something.

Anyways..how do i create a new database, when I can't access the commandline.

leonbloy · Accepted Answer · 2013-09-25 13:32:14Z

26

Read psql syntax. You can specify database, user and other parameters. If it's a new installation, there should be a default database 'postgres', you can connect to that one.

 psql -U postgres postgres

(In Unix environments you might need to add -h localhost in order to force a TCP connection, otherwise it'd try to use Unix-domain sockets, which might not work for other than the postgres user. )

You can create databases from there, or from the command line with createdb

edited Sep 25, 2013 at 13:32

answered Apr 20, 2011 at 20:04

leonbloy

76.4k22 gold badges149 silver badges197 bronze badges

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

5 Comments

Isaac Rabinovitch Over a year ago

psql: FATAL: Ident authentication failed for user "postgres"

Cody Over a year ago

psql: FATAL: Peer authentication failed for user "postgres"

leonbloy Over a year ago

stackoverflow.com/questions/2942485/… @Cody stackoverflow.com/questions/11913897/…

Frankline Over a year ago

If I may add, psql -U postgres postgres -h localhost

leonbloy Over a year ago

@Frankline : that should not be necessary in Windows

Collectives™ on Stack Overflow

Postgresql creating database

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related