How do you create a Postgresql database on a Windows system?

Question

I installed Postgresql and have pgAdmin III running.

I'm following the instructions in the Postgres doc on how to get my database started, but I'm not having luck with the first line.

Typing postmaster into my cmd is returning

not recognized...

It seems this command is only for Linux or Mac machines.

Does anyone know how to apply these instructions to Windows? Or if a manual for Windows exists? (Googling has turned up nothing useful)

You do it in sql shell not in cmd.Check your postgres folder in programs — Mihai
– Mihai, Commented Jan 27, 2015 at 8:58
Connect to the database and run create database. See the manual for details: postgresql.org/docs/current/static/sql-createdatabase.html You should never, ever run postmaster.exe or postgres.exe directly. Postgres is usually started through a service on Windows. And don't read the manual for an completely outdated version. Use the manual for your version. — user330315
– user330315, Commented Jan 27, 2015 at 9:02
Open pgAdmin, connect to your postgres-server (running local) using the default database "postgres" and create a new database. — Frank Heikens
– Frank Heikens, Commented Jan 27, 2015 at 11:28

Patrick · Accepted Answer · 2015-01-27 09:01:54Z

1

If you installed PostgreSQL from the EnterpriseDB distribution then the postmaster is already running as a service. You can check this from the Control Panel (Administrative Tools | Services). Can you connect to your local installation using pgAdmin III? If so, then you are all set. In pgAdmin III, connect to the local server, then on the Databases node in the tree under the server select 'New database...'.

answered Jan 27, 2015 at 9:01

Patrick

33k7 gold badges73 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

How do you create a Postgresql database on a Windows system?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related