postgres C:: Permission denied using windows

Question

I am using Windows 10

I have a PostgreSQL file when I run inside the PSQL CMD

\i FILENAMEPATH

postgres=# \i C:\Users\Asus\Desktop\Projects\Movies\solution.sql
C:: Permission denied

I get that Permission Denied

C:: Permission denied

Is there a way around this? Or how can I gain permission?

Try forward slashes \i c:/Users/Asus/Desktop/Projects/Movies/solution.sql — user330315
– user330315, Commented Jul 27, 2021 at 14:07
I encountered the same problem, but after spending an hour searching the web, I stumbled upon your comment and your solution worked perfectly for me. Thank you so much for sharing! @a_horse_with_no_name — vetheve
– vetheve, Commented Jan 10, 2023 at 9:56
Using the forward slashes worked for me!!!!! no more Perms DENIED! TYVM — Eric Carvan
– Eric Carvan, Commented Oct 31 at 14:02

Sadra M. · Accepted Answer · 2022-05-11 07:42:54Z

14

As a_horse_with_no_name pointed out, using forward slashes instead of backslashes in the address solves the problem.

This is because windows unlike most OSs, resolves paths with forward slashes.

edited May 11, 2022 at 7:42

answered Apr 24, 2022 at 10:19

Sadra M.

1,5732 gold badges18 silver badges29 bronze badges

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

1 Comment

Awani Over a year ago

i still see the same error despite using forward slashes :/

Sufyx · Accepted Answer · 2022-11-19 14:25:51Z

0

What solved this issue for me is opening a PowerShell in the folder location of the sql file (in folder: shift + right-click -> open PowerShell here), to avoid having to provide a file path, and then running '\i filename.sql'

edited Nov 19, 2022 at 14:25

answered Nov 19, 2022 at 14:25

Sufyx

11 bronze badge

Comments

KLMN · Accepted Answer · 2023-12-08 03:07:34Z

0

In my situation, when attempting to execute the initdb command, I encountered a permission denied error. To resolve this issue, I created a folder within my account's directory, and then the command executed successfully.

PS D:\Software\PostgreSQL\bin> .\pg_ctl initdb  -D "C:\Users\(my user name)\postgresql_data"

answered Dec 8, 2023 at 3:07

KLMN

5594 silver badges13 bronze badges

Collectives™ on Stack Overflow

postgres C:: Permission denied using windows

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related