Hi,
From the shared log files it seems that initcluster script ran successfully and also able to start the cluster and stopped after sometime. Could you please check if data directory "C:\Program Files\PostgreSQL\10\data" is exist or not. If its exist then share the log files to from log folder to identify the issue. Also check the permission of the data directory if its properly set.
In addition to the above troubleshooting could you please try changing the temp directory as follows,
1> Try changing the TEMP directory
For Example,
Try to launch the installer from cmd by setting the manual TEMP location,
c:\>mkdir mytemp
c:\>cd mytemp
c:\mytemp>set TEMP=c:\mytemp
c:\mytemp>
c:\mytemp>echo %TEMP%
c:\mytemp
c:\mytemp>c:\postgresql-9.6.3-2-windows-x64.exe
Check if the installer is able to complete the installation or not.
Just to let you know.
I can run the PgAMIN program but it has no cluster attached.
The C:\Program Files\PostgreSQL\10\data directory does exist. The installation creates a pg_log file within it, which is empty.
It seems that somehow the server can't communicate with the data folder, so all of the checks on the data cluster using the icacals
Here is one of the batch files (radE2EC7.bat) that fails:
@ECHO OFF
CHCP 1252
icacls "C:\TD1_SHR\PostGreSQL" /T /C /grant "NT AUTHORITY\NetworkService":(OI)(CI)(F) > "C:\Users\TDFM1\AppData\Local\Temp\rad9B37A.tmp" 2>&1
EXIT /B %ERRORLEVEL%
TDFM1 is an administrator for the PC, and we are running logged on to the TDFM1 account.
The C:\USERS\TDFM1\ folder is not shared. Its security settings provide full control to the System, TDFM1, and Administrators user names. No other users show up.
This is also true for the C:\Users\TDFM1\AppData\Local\Temp folder.
When PGADMIN communicates with the data cluster does it do so as an external user?
Could this be a sharing problem? How do I check whether the Port 5432 is somehow blocked?
I will try what you suggest.
Should I uninstall everyting first?
Does "postgresql-9.6.3-2-windows-x64.exe" need to be copied to the C:\ or can I call it from where it is currently stored?
Also, when I open PGADMIN, there is no server shown.
When I then open a cmd.exe window and issue the following, it does not show port 5432 to be open.
C:\Users\TDFM1>netstat -an |find /i "listening" > c:\netstatresults.txt
results are:
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:623 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3029 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
TCP 0.0.0.0:5053 0.0.0.0:0 LISTENING
TCP 0.0.0.0:5054 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8678 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8679 0.0.0.0:0 LISTENING
TCP 0.0.0.0:16992 0.0.0.0:0 LISTENING
TCP 0.0.0.0:22350 0.0.0.0:0 LISTENING
TCP 0.0.0.0:43210 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49152 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49153 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49154 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49155 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49183 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49184 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49230 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49242 0.0.0.0:0 LISTENING
TCP 127.0.0.1:5939 0.0.0.0:0 LISTENING
TCP 127.0.0.1:42000 0.0.0.0:0 LISTENING
TCP 127.0.0.1:42001 0.0.0.0:0 LISTENING
TCP 127.0.0.1:43227 0.0.0.0:0 LISTENING
TCP 127.0.0.1:49348 0.0.0.0:0 LISTENING
TCP 127.0.0.1:54531 0.0.0.0:0 LISTENING
TCP 192.168.6.75:139 0.0.0.0:0 LISTENING
TCP [::]:135 [::]:0 LISTENING
TCP [::]:445 [::]:0 LISTENING
TCP [::]:623 [::]:0 LISTENING
TCP [::]:3029 [::]:0 LISTENING
TCP [::]:3389 [::]:0 LISTENING
TCP [::]:5053 [::]:0 LISTENING
TCP [::]:16992 [::]:0 LISTENING
TCP [::]:22350 [::]:0 LISTENING
TCP [::]:49152 [::]:0 LISTENING
TCP [::]:49153 [::]:0 LISTENING
TCP [::]:49154 [::]:0 LISTENING
TCP [::]:49155 [::]:0 LISTENING
TCP [::]:49184 [::]:0 LISTENING
TCP [::]:49230 [::]:0 LISTENING
TCP [::]:49242 [::]:0 LISTENING
TCP [::1]:49347 [::]:0 LISTENING
Hi jabunch,
Hope you are doing good.
PostgreSql installs a service on the system when you install postgreSQL on windows. Please check for the service with the name postgresql in the Services management console. If the postgresSQL service is not running could you please start the service manually and then check if the server appears on pgAdmin. Please let us know how it goes.
Thanks,
Swagata
So, I followed the instructions on creating a mylib folder, setting the
%TEMP% and starting the installer from c:\.
It failed in the same way as my other attempts to install. batch files
open due to errors and two error boxes appear.
The postgresql service is not running and does not exist, even when I look
at all services using msconfig
When I start PGADMIN , it opens but there are no servers on the far left in Browser->Servers Pane.
the
Please note: This post is now being handled by a private support option to ensure appropriate attention.
Further communications are pending.
Other comments from the PGR community are still welcome to be added here.
PGR Administration
Was this ever resolved? I am having the same issue at the moment with PostgreSQL 10.3
Hi Brucelee,
Hope you are doing good !
Regarding the previous issue, we are still collecting information from the "jabunch" for troubleshooting.
As per the logs shared by "jabunch", indicates that server was started successfully but it doesn't look like it was started. The service start/stop details should be logged into event logs, as you are facing same issue so if possible could you please share the event logs located at Event Viewer-> Windows logs -> Application"
You may also try running "C:\Program Files\PostgreSQL\10\installer\server\startserver.vbs" postgresql-x64-10 to see if the service is started successfully.
I had a similar issue, it was resolved for me after changing the password in the setup wizard. It seems having curled braces or special characters in the password is causing unexpected/faulty behaviour in scripts executed by the setup.
I had '§' and '{' in my initial password and it gave the same error. I used a simpler password without special characters during the setup and it worked just fine. Changed the password afterwards.
Hello, I've a similar issue did you were able to resolve the issue ?