PostgreSQL Database Configuration Issue

[deepaktony]

Hi,

I tried to configure PostgreSQL database, but as per documentation, "create_database_windows.bat" Batch file is not available in winccoa_path/data/NGA/PostgreSQL/sql/ directory.

(Documentation Link - https://www.winccoa.com/documentation/W ... stall.html)

So, I am not able to generate and configure the PostgreSQL database in my WinCC OA 3.18 P009.
Please suggest to proceed ahead.

Thank You!

[kilianvp]

Do you have a file "create_database_windows.ps1" ? Thats the correct file.

[deepaktony]

Hi Kilianvp,

"create_database_windows.ps1" is there in the same folder. But, as per documentation step, I was looking for the "create_database_windows.bat" file.

Anyway, I have tried with "create_database_windows.ps1" file as well, but it is giving error.

[leoknipp]

It is already known that the documentation does not fit the files in the WinCC OA version. This issue will be corrected in future releases.
Have you tried to execute the script in a Windows PowerShell?

Best Regards
Leopold Knipp
Senior Support Specialist

[deepaktony]

"create_database_windows.ps1" file was giving some error. After addition of PostgreSQL bin Path in "environment variable" of PC, it executed fine. (C:\Program Files\PostgreSQL\13\bin).

Thanks