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 pe

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 config_fil

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: > > > >> psycopg2.OperationalError: FATAL: databa

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? If it does, is in in an acce