تخطي للذهاب إلى المحتوى
لقد تم الإبلاغ عن هذا السؤال
2 الردود
6658 أدوات العرض
الصورة الرمزية
Phat

Database creation error: connection to server at "localhost" (::1), port 5432 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections?


Can anyone help me with this i cannot fix this although ive been searching for a lot

الصورة الرمزية
إهمال
الصورة الرمزية
Jort de Vreeze
أفضل إجابة

There are several ways to verify the PostgreSQL installation. You can try to connect to the PostgreSQL database server from any client application. But a quick way to verify the installation is through the psql program that comes with the Windows installation.


First, click the psql application to launch it (or enter psql in the searchbar). The psql command-line program will display.

source: https://www.postgresqltutorial.com/postgresql-getting-started/install-postgresql/

I hope this helps!

الصورة الرمزية
إهمال
Phat
الكاتب

Hello, sorry for the late reply.

I cannot find any of my SQL Shell even when ive deleted the psql once and reinstalled it on my computer, can you help me how do i fix this?

Phat
الكاتب

I tried to uninstall and then reinstall it again

Database creation error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "openpg"

Then this happens

الصورة الرمزية
Lukas Mayer
أفضل إجابة

Most likely your PostgreSQL service is not running. If you are running a SystemD based distribution (which you probably do), what is the output of:

systemctl status postgresql.serivce


الصورة الرمزية
إهمال
Phat
الكاتب

I'm using window, can you tell me how to, im a student. I have odoo experience at school but at home i have no idea setting odoo server up to make things.
Thank you a lot

Phat
الكاتب

Database [postgres]:
Port [5432]:
Username [postgres]:
psql: warning: extra command-line argument "-U" ignored
psql: warning: extra command-line argument "postgres" ignored
psql: warning: extra command-line argument "-d" ignored
psql: warning: extra command-line argument "postgres" ignored
psql: warning: extra command-line argument "-p" ignored
psql: warning: extra command-line argument "5432" ignored
psql: error: could not translate host name "systemctl" to address: Unknown host