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 ensure_connection
self.connect()
File
"/home/gary/workspace/djenv/lib/python3.5/site-packages/django/db/backends/base/base.py",
line 171, in connect
self.connection = self.get_new_connection(conn_params)
File
"/home/gary/workspace/djenv/lib/python3.5/site-packages/django/db/backends/postgresql/base.py",
line 175, in get_new_connection
connection = Database.connect(**conn_params)
File
"/home/gary/workspace/djenv/lib/python3.5/site-packages/psycopg2/__init__.py",
line 164, in connect
conn = _connect(dsn, connection_factory=connection_factory, async=async)
psycopg2.OperationalError: FATAL: database "archivedb" does not exist
My settings file looks like this:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'archivedb',
'USER': 'gary',
'PASSWORD': 'zzyyxx', # WARNING If they get this far I'm screwed anyway
'HOST': 'localhost',
'PORT': '5432',
}
}
My pgAdminIII Object Browser:
See attachment Spectacl.....
And SQL Pane for Gary:
> CREATE ROLE gary LOGIN
> ENCRYPTED PASSWORD 'md5772cde60e4a04dc0cb7268674810bf03'
> SUPERUSER INHERIT CREATEDB CREATEROLE REPLICATION;
The pg_hba.conf file at /etc/postgresql/9.6/main is:
# Database administrative login by Unix domain socket
local all postgres trust
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres peer
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5
What's happening here?
Any help will be sincerely appreciated.
Gary R.
--
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 django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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/fdaf6530-6b5d-8f63-06c1-d63cca2296b2%40verizon.net.
For more options, visit https://groups.google.com/d/optout.
