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
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
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:
> 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?
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
5 matches
Mail list logo