I try to run this simple command:

  OWNER postgres
  LOCATION 'd:/tablespaces';

However, the tablespace is not created and I got this message:

ERREUR:  n'a pas pu configurer les droits du répertoire « d:/tablespaces » : Permission denied

For non french speakers:

ERROR: was not able to configure the directory rights « d:/tablespaces » : Permission denied

I didn't find any postgres user (net user) and I'm stuck on this...

How to give access to the directory to postgres?

Windows 7
Postgres 9.2

1 Answer 1


For PostgreSQL 9.2 and above there is no postgres system user (by default). It runs as NETWORK SERVICE.

Create d:\tablespaces and give the NETWORK SERVICE (SERVICE RÉSEAU in french) "Full control" over it. That should do the trick.

  • Do you have any pointer to give "Full control"?
    – Stephan
    Nov 19, 2014 at 15:14
  • @Stephan Security tab of properties Nov 19, 2014 at 15:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.