I'm trying to do python manage.py syncdb
on a Django installation, but I keep getting OperationalError: ERROR: pgbouncer cannot connect to server
. pgbouncer.log contains lines such as:
Troubleshooting steps for the most common problems with the Elite Dangerous launcher. How to fix common problems with the Elite Dangerous launcher Updated: Tuesday 13th November 2018. Making sure you're not launching the game as an administrator. The future of live TV with 60+ channels. No cable box required. Cancel anytime.
In case needed, ps -aef grep pgbouncer
yields:
Moreover, grep port /etc/pgbouncer/pgbouncer.ini
results in:
Lastly, the relevant parts of settings.py
contain:
I turned log_connections
to on
in postgresql.conf, restarted PG and tried again. Here's the relevant lines:
It seems the connection is going through, but the user
and database
name is postgres
. Those credentials aren't what I supplied in pgbouncer.ini
.
However, explicitly adding myuser
in the connection string described in pgbouncer.ini
leads to:
Everio media browser hd edition ver. 2017. Promotion code is only valid for 90 days from issued date.
Totally stumped.
It seems the mis-configuration emanated from this line in settings.py
:
I commented it and pgbouncer started working.
Though I'm not sure 'why'.
Maybe there's a collision on this port; Pgbouncer and PG coexist on a single server in my case. I've set them up over different VMs in the past without a hitch (and without needing to comment 'PORT': '6432',
)
Cummins® and all of the Cummins® engine models listed on this website are registered trademarks of Cummins. For example: • 7E1234 was produced in March 2007 • FZ1234 was produced in December 2015 • Current format (since June 2012): the engine serial number now has 7 characters (first character for the engine series, the second for the prodution year, and the third for the production month). For example: • 8CM1234 is a 07 Series engine produced in June 2012 Engine Series. Kubota tractor serial number lookup. Caterpillar® and all of the Caterpillar® engine models listed on this website are registered trademarks of Caterpillar, Inc.
Hassan BaigHassan Baig