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 [email protected].
To post to this group, send email to [email protected].
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.
