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-25T13:32:14.403

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 '13 at 13:32

answered Apr 20 '11 at 20:04

leonbloy

73,180
20
142
190

1

psql: FATAL: Ident authentication failed for user "postgres" – Isaac Rabinovitch Feb 20 '13 at 20:55
1

psql: FATAL: Peer authentication failed for user "postgres" – Cody Apr 01 '13 at 02:48
http://stackoverflow.com/questions/2942485/psql-fatal-ident-authentication-failed-for-user-postgres @Cody http://stackoverflow.com/questions/11913897/postgres-whats-the-difference-between-local-and-localhost-connection-type – leonbloy Apr 01 '13 at 12:58
If I may add, `psql -U postgres postgres -h localhost` – Frankline Sep 25 '13 at 11:46
@Frankline : that should not be necessary in Windows – leonbloy Sep 25 '13 at 13:31

Postgresql creating database

1 Answers1

Linked