Access is denied error when initializing PostgreSQL DB on Windows

Question

I'm on Windows 10. I downloaded the most recent version of Psql.

I was like:

C:\Program Files\PostgreSQL\9.6\bin>initdb.exe "C:\psql_db"

The files belonging to this database system will be owned by user "Sean".
This user must also own the server process.

The database cluster will be initialized with locale "English_United States.1252".
The default database encoding has accordingly been set to "WIN1252".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory C:/psql_db ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    "pg_ctl" -D "C:\psql_db" -l logfile start

C:\Program Files\PostgreSQL\9.6\bin>"pg_ctl" -D "C:\psql_db" -l logfile start

And it was like:

server starting

Access is denied.

Did you find the answer?

lebowski
– lebowski

2016-09-22 00:32:03 +00:00
Commented Sep 22, 2016 at 0:32 — lebowski
– lebowski, Commented Sep 22, 2016 at 0:32
@Sean Reddy, did you find the solution?

Dinesh Kumar P
– Dinesh Kumar P

2017-02-06 10:11:51 +00:00
Commented Feb 6, 2017 at 10:11 — Dinesh Kumar P
– Dinesh Kumar P, Commented Feb 6, 2017 at 10:11
Any solutions to this?

Yash Goenka
– Yash Goenka

2017-04-21 08:12:49 +00:00
Commented Apr 21, 2017 at 8:12 — Yash Goenka
– Yash Goenka, Commented Apr 21, 2017 at 8:12
@YashGoenka yes

user3556757
– user3556757

2017-09-21 14:05:30 +00:00
Commented Sep 21, 2017 at 14:05 — user3556757
– user3556757, Commented Sep 21, 2017 at 14:05

user3556757 · Accepted Answer · 2017-09-21 14:04:57Z

14

I think you are trying to create the logfile inside C:\Program Files\PostgreSQL\9.6\bin, for which you don't have write permission

Specify something like "pg_ctl" -D "C:\psql_db" -l "c:\users\joe\logfile" start

answered Sep 21, 2017 at 14:04

user3556757

3,6196 gold badges41 silver badges78 bronze badges

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

1 Comment

maris Over a year ago

this solution is woking. Thanks a lot. Better keep the log file outside of your PostgreSQL install folder.

Slavomir · Accepted Answer · 2018-06-12 14:55:27Z

2

This is because of windows file permissions. You can put the data folder on desktop "c:\Users\\Desktop\" instead of "C:\psql_db". Or maybe give your user more permissions.

answered Jun 12, 2018 at 14:55

Slavomir

5414 silver badges8 bronze badges

Collectives™ on Stack Overflow

Access is denied error when initializing PostgreSQL DB on Windows

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related