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.

Answer 1

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

• Isaac Rabinovitch: psql: FATAL: Ident authentication failed for user "postgres"
• Cody: psql: FATAL: Peer authentication failed for user "postgres"
• leonbloy: stackoverflow.com/questions/2942485/… @Cody stackoverflow.com/questions/11913897/…
• Frankline: If I may add, psql -U postgres postgres -h localhost
• leonbloy: @Frankline : that should not be necessary in Windows