Re: Django can't find database

2016-10-23 Thread Antonis Christofides
No, "peer authentication failed for user "gary"" doesn't mean that psql can't find the database; it means what it says, authentication failed. Peer authentication is quite complicated. "psql -U gary archivedb" is a local connection (using Unix sockets I think), and by default postgresql uses

Re: Django can't find database

2016-10-22 Thread Gary Roach
psql -U gary -d archivedb gives: FATAL: Peer authentication failed for user "gary" which probably means that psql can't find the database either. My process table ( ps -xaf) shows: 642 ?S 0:07 /usr/lib/postgresql/9.6/bin/postgres -D /var/lib/postgresql/9.6/main -c

Re: Django can't find database

2016-10-22 Thread Vijay Khemlani
Can you connect to the database via command line? psql -U gary -d archivedb On Sat, Oct 22, 2016 at 3:48 PM, Jamie Lawrence wrote: > > > On Oct 22, 2016, at 11:35 AM, Gary Roach > wrote: > > > When I try to migrate, I get the following error:

Re: Django can't find database

2016-10-22 Thread Jamie Lawrence
> On Oct 22, 2016, at 11:35 AM, Gary Roach wrote: > When I try to migrate, I get the following error: > >> psycopg2.OperationalError: FATAL: database "archivedb" does not exist > What's happening here? Are you certain the ‘archivedb’ database actually exists?

Django can't find database

2016-10-22 Thread Gary Roach
Hi all, Debian System, stretch, 64 bit. KDE4 Desktop Django 1.10 Postgresql 9.6 with psycopg2 When I try to migrate, I get the following error: Traceback (most recent call last): File "/home/gary/workspace/djenv/lib/python3.5/site-packages/django/db/backends/base/base.py", line 199, in