Cannot start PostgreSQL 10 server after directory permision change

From: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Cannot start PostgreSQL 10 server after directory permision change
Date: 2018-10-22 07:22:29
Message-ID: 002e01d469d7$fe569800$fb03c800$@1nar.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I have PostgreSQL 10.5 (x64) running on Windows 10 (x64) installed from
EnterpriseDB setup.

I changed complete ownership of my drive E: including all sub directories
and files due to some permission problems on it. There are no OS files
installed in drive E:. However, PostgreSQL data files are in that drive and
PostgreSQL failed to start after that permission change.

I get following two errors at startup in Windows Event Viewer:
Postgres: could not Access directory "E:\PostgreSQL_DATA": No such file or
directory
Run initdb or pg_basebackup to initialize a PostgreSQL data directory.

I tried to set ownership of that directory to NETWORK SERVICE that did not
help.

Is there a way to fix that problem?

Thanks & regards,
Ertan Küçükoğlu

Browse pgsql-admin by date

  From Date Subject
Next Message Fabio Pardi 2018-10-22 09:51:35 Re: minimal network speed for replication
Previous Message prasanna rk 2018-10-21 01:01:37 Re: minimal network speed for replication