Thread: The postgres server don't work

On 1/7/22 10:05, Mohammed falih wrote:
> Hello Mr/Mrs
> I hope you are fine and doing well
> I have a problem with the postgres server
> first my operating system is windows 10 pro
> and my postgres version is 13
> this problem i have tried to solve it for more than two weeks and 
> nothing changed
> lastly I have formatted the laptop and downloaded only PostgreSQL 
> program and it worked well for less than a hour then its server broken

Questions and comments inline below.

Define broken?

In other words what does the Postgres log show in the period from when 
it ran to when it did not?

> the error says in sql shell " could not connect to server: Connection 
> refused (0x0000274D/10061)
>          Is the server running on host "localhost" (::1) and accepting
>          TCP/IP connections on port 5432?"
> I changed the port and nothing different
> yes this problem is happening regularly but with me nothing solved it

The issue is the below where it could not find the executable. Are you 
starting the service as an administrator?

> 
> I tried to go to configuration files (the pg_hba.conf ( I added a line 
> in the last
> host all all 0.0.0.0/0 <http://0.0.0.0/0> md5)
> and in postgresql.conf file (the listening addresses was already to :"*")
> 
> also I when I try to start the server from service tab says
> the postgres service cannot restart
> it says that "some services stop automatically if they are not in use by 
> other services or programs
> and when I check it in the event viewer there is an error says
>   "FATAL: XX000: C:\Program Files\PostgreSQL\13\bin\postgres.exe: could 
> not locate matching postgres executable LOCATION: getInstallationPaths, 
> d:\pginstaller_13.auto\postgres.windows-x64\src\backend\postmaster\postmaster.c:1489"

Does this path C:\Program Files\PostgreSQL\13\bin\postgres.exe actually 
exist?

> 
> and maybe you need to know that after I finish installing the postgre 
> program I haven't installed the stack builder and when I run the sql 
> shell for first time there were a problem says "Console code page (437) 
> differs from Windows code page (1252)
>           8-bit characters might not work correctly. See psql reference
>           page "Notes for Windows users"

This has to do with the psql client not the server.

> and I solved this problem by go to registry 
> editor/HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/command processor
> and there i have entered a new string value called Autorun and its value 
> is chcp 1252
> 
> I hope you’ll help me to fix this problem because I have many tasks I 
> couldn't do because the postgres problem
> 
> thank you for your efforts
> my best regards
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 1/8/22 14:47, Mohammed falih wrote:
> I mean by broken that when I run psql shell or padding I receive this 
> error " " could not connect to server: Connection
> refused (0x0000274D/10061)
>   Is the server running on host "localhost" (::1) and accepting
>        TCP/IP connections on port 5432?"
> 
> and about the log file , usually this problem happens after my laptop 
> turned off or restart
> so last line in the log file is "database system is shut down"
> and no matter how many times I tried by restart the laptop nothing  changes

I am not following '...usually this problem happens after my laptop 
turned off or restart...'. This would seem to imply that the service 
does start sometimes. Is that the case?

> 
> the ex files are all in their right location , and I tried both ways in 
> regular running and as administrator and nothing different
> 
> yes the postgres.exe is exist there

Do you have an Anti-Virus program running on this machine?

> 
> and about the console code problem ,yes maybe this error is related to 
> the client but I realized that after I make this solution and make  
> restart to the laptop , the postgres begins to not working ,maybe this 
> was a coincidence I don't know

Then undo the changes and see what happens? I sort of doubt it is the 
issue though.

> 
> thank you for your efforts
> On Sat, 8 Jan 2022, 9:45 pm Adrian Klaver, <adrian.klaver@aklaver.com 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 1/8/22 15:29, Mohammed falih wrote:
> yes I think the service doesn't even start

Yet below you said it does.

> 
> I have only the default protection that comes with the operating system
> 
> wow the postgres started working!! but the problem came back that talks

Did you revert the change you made earlier to get it to work?


> about console code " WARNING: Console code page (437) differs from 
> Windows code page (1252)
> 
> 8-bit characters mightnot  work correctly. See psql reference
>           page "Notes for Windows users"for  details."
> 

So follow the instructions here :

https://www.postgresql.org/docs/current/app-psql.html

"
Notes for Windows Users

psql is built as a “console application”. Since the Windows console 
windows use a different encoding than the rest of the system, you must 
take special care when using 8-bit characters within psql. If psql 
detects a problematic console code page, it will warn you at startup. To 
change the console code page, two things are necessary:

     Set the code page by entering cmd.exe /c chcp 1252. (1252 is a code 
page that is appropriate for German; replace it with your value.) If you 
are using Cygwin, you can put this command in /etc/profile.

     Set the console font to Lucida Console, because the raster font 
does not work with the ANSI code page.
"

In the terminal before running psql do:

cmd.exe /c chcp 1252



-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 1/8/22 15:29, Mohammed falih wrote:
> yes I think the service doesn't even start
> 
> I have only the default protection that comes with the operating system
> 
> wow the postgres started working!! but the problem came back that talks 
> about console code " WARNING: Console code page (437) differs from 
> Windows code page (1252)
> 
> 8-bit characters mightnot  work correctly. See psql reference
>           page "Notes for Windows users"for  details."
> 

I don't use Windows anymore so I am going from memory here. In the 
Windows menu there should be an entry for Postgres and its sub-programs. 
One of those should be named something like psql or database shell. 
Click on that, it will run a shell script that prompts you for 
connection information and if I remember correctly also takes care of 
the above issue.


-- 
Adrian Klaver
adrian.klaver@aklaver.com