When running postgres, the postgres user is normally not a user that you can login via the psycopg2 connector with. You should use a specific user for the database that you want to connect to. The postgres user is a superuser and is normally connected to a local user that you need to login via.
Regards, Andréas Den tors 17 jan. 2019 kl 22:56 skrev Nadhem Zmandar < [email protected]>: > I've installed psycopg2 before running he server. So I think it's an other > problem > > Le jeu. 17 janv. 2019 à 16:50, Harryxon Ndegwa < > [email protected]> a écrit : > >> did u install psycopg2 using pip, >> that is, pip install psycopg2 >> i see its a connection error make sure u have psycopg2 connector >> installed in your environment >> >> #%£& >> >> On Thu, 17 Jan 2019 6:22 pm Nadhem Zmandar <[email protected] >> wrote: >> >>> I am beginner with Django. I've downloaded an open source Django project >>> to start learning and I've installed PostGres and PgAdmin and tested >>> them.and I have checked all details in the settings.py (especially the >>> password) to link the project to the database created on PgAdmin. >>> However when I run the project I have this error >>> >>> PS D:\django\btre_project-master> python manage.py runserver >>> Performing system checks... >>> >>> System check identified no issues (0 silenced). >>> Unhandled exception in thread started by <function >>> check_errors.<locals>.wrapper at 0x04394300> >>> Traceback (most recent call last): >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\backends\base\base.py", >>> line 216, in ensure_connection >>> self.connect() >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\backends\base\base.py", >>> line 194, in connect >>> self.connection = self.get_new_connection(conn_params) >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\backends\postgresql\base.py", >>> line 178, in get_new_connection >>> connection = Database.connect(**conn_params) >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\psycopg2\__init__.py", >>> line 130, in connect >>> conn = _connect(dsn, connection_factory=connection_factory, >>> **kwasync) >>> psycopg2.OperationalError: FATAL: password authentication failed for >>> user "postgres" >>> >>> >>> The above exception was the direct cause of the following exception: >>> >>> >>> Traceback (most recent call last): >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\utils\autoreload.py", >>> line 225, in wrapper >>> fn(*args, **kwargs) >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\core\management\commands\runserver.py", >>> line 120, in inner_run >>> self.check_migrations() >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\core\management\base.py", >>> line 442, in check_migrations >>> executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS]) >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\migrations\executor.py", >>> line 18, in __init__ >>> self.loader = MigrationLoader(self.connection) >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\migrations\loader.py", >>> line 49, in __init__ >>> self.build_graph() >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\migrations\loader.py", >>> line 212, in build_graph >>> self.applied_migrations = recorder.applied_migrations() >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\migrations\recorder.py", >>> line 61, in applied_migrations >>> if self.has_table(): >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\migrations\recorder.py", >>> line 44, in has_table >>> return self.Migration._meta.db_table in >>> self.connection.introspection.table_names(self.connection.cursor()) >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\backends\base\base.py", >>> line 255, in cursor >>> return self._cursor() >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\backends\base\base.py", >>> line 232, in _cursor >>> self.ensure_connection() >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\backends\base\base.py", >>> line 216, in ensure_connection >>> self.connect() >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\utils.py", >>> line 89, in __exit__ >>> raise dj_exc_value.with_traceback(traceback) from exc_value >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\backends\base\base.py", >>> line 216, in ensure_connection >>> self.connect() >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\backends\base\base.py", >>> line 194, in connect >>> self.connection = self.get_new_connection(conn_params) >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\backends\postgresql\base.py", >>> line 178, in get_new_connection >>> connection = Database.connect(**conn_params) >>> File >>> "C:\Users\nadhem\AppData\Local\Programs\Python\Python37-32\lib\site-packages\psycopg2\__init__.py", >>> line 130, in connect >>> conn = _connect(dsn, connection_factory=connection_factory, >>> **kwasync) >>> django.db.utils.OperationalError: FATAL: password authentication failed >>> for user "postgres" >>> >>> >>> >>> >>> >>> Could any one help me please ? >>> Thank you >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Django users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at https://groups.google.com/group/django-users. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/0fcd21c9-95f0-40cb-89c7-ae713e459605%40googlegroups.com >>> <https://groups.google.com/d/msgid/django-users/0fcd21c9-95f0-40cb-89c7-ae713e459605%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "Django users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/django-users/cwbw85N7Qa8/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/django-users. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/CAPqDb9MzjQtmULXjJ%2B01bvB-rDiObP%2B9vGyto45tQuBr%3D%3D4i7A%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CAPqDb9MzjQtmULXjJ%2B01bvB-rDiObP%2B9vGyto45tQuBr%3D%3D4i7A%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/django-users. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAPwXE%2BhaVUOCMw_FEjuHCwQOgT1bsLBLiyT_WoS3OPiOBaxZWg%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAPwXE%2BhaVUOCMw_FEjuHCwQOgT1bsLBLiyT_WoS3OPiOBaxZWg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAK4qSCdnPjeb3MGXDT7NVwiw5_n0CY03MLR_BsZ95SE5CzQshw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
