Hi Guido, first I would recommend restoring your pg_hba file to its original state for now, only because it could have a syntax error in it (that's what the "cannot load" message suggests to me at least).
Things to check: In your settings.py/settings_local.py, are the database username and password correct? And these are postgres and XXX, where XXX is the password you are able to use with your psql command? If that is the case, then I'm not sure what could be wrong. You should be able to type XXX into the command prompt when you run ... setup_db if it works for psql. One good tip: in your command prompt you can run set PGPASSWORD=XXX before running ... setup_db, because psql will always look for that environment variable before asking for a password. I do this if I know I will have to be rerunning those commands a lot and I don't want to keep being prompted for the password. Adam On Tue, Apr 24, 2018 at 11:13 AM, guido cimadomo <gu...@cimadomo.com> wrote: > Thanks for all the help in my attempt to install Arches (Win8.1 x64), > > After resolving elasticsearch installation, I actually find an error > creating the postgres database, following the > > > python manage.py packages -o setup_db > > at the same point as in an existing thread in this group, which is not giving > me a solution. I receive this error message: > > File "C:/Projects\ENV\lib\site-packages\psycopg2\__init__.py", line 130 in > connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync > django.db.utils.OperationalError: FATAL: pw authentification failed for user > postgres > > I checked the pw issuing psql -U postgres -W -h localhost, so I'm pretty sure > about the pw (different from the one suggested on Arches documentation). > > I also attempted to modify pg_hba.config substituting md5 with true as > suggested in some stack thread... In this case reissuing the database > creation command doesn't ask me for a pw, but again stops at the same line 130 > but with a different error: django.db.utils.OperationalErro: FATAL: cannot > load pg_hba.conf > > > Not sure if it could be originated by a bad postgres installation or I can > check some other solution before reinstalling postgres 9.6.8... > > > best, > > -- > -- To post, send email to archesproject@googlegroups.com. To unsubscribe, > send email to archesproject+unsubscr...@googlegroups.com. For more > information, visit https://groups.google.com/d/forum/archesproject?hl=en > --- > You received this message because you are subscribed to the Google Groups > "Arches Project" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to archesproject+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- -- To post, send email to archesproject@googlegroups.com. To unsubscribe, send email to archesproject+unsubscr...@googlegroups.com. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to archesproject+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
