[How-To] Fix Problem PostgreSQL PSQL display code page warning

 

Warning:

WARNING: Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly.

Solution:

Run terminal command chcp 1252

(refer https://stackoverflow.com/questions/20794035/postgresql-warning-console-code-page-437-differs-from-windows-code-page-125)

Read More

[How-To] Fix Chocolate PostgreSQL installation error - password (error: FATAL: password authentication failed)

 Error:

A number of discussion threads on postgre password not working.

refer https://stackoverflow.com/questions/12562928/psql-exe-password-authentication-failed-in-windows,

https://stackoverflow.com/questions/18698889/postgresql-on-windows-is-there-a-default-password, and

https://stackoverflow.com/questions/20794035/postgresql-warning-console-code-page-437-differs-from-windows-code-page-125

Explanation:

It could be that the program "...expects an user “postgres” with the password “postgres” for the database connection. But these credentials didn’t work!"

(refer https://nexusger.de/posts/2015-10-30-elixir-postgres-and-chocolatey/)

Solution:

PostgreSQL Version 13 has been found to be installed correctly. User Version 13.

choco install postgresql13 --params '/Password:test /Port:5433' --ia '--enable-components server,commandlinetools'

(refer https://community.chocolatey.org/packages/postgresql/13.9.1)

Read More