import json
import psycopg2
from psycopg2.extras import RealDictCursor
cursor = conn.cursor(cursor_factory=RealDictCursor)
objects = cursor.fetchall()
print json.dumps(objects, indent=2)
# Django
#JsonResponse({'objects': objects})
Source: https://www.peterbe.com/plog/from-postgres-to-json-strings
Today I added a new server to PostgreSQL's host-based authentication file (pg_hba.conf) on a very active PostgreSQL server. Restarting the PostgreSQL service would have lead to service disruption across multiple services. Thankfully the folks at PostgreSQL are one-step ahead of me on this one. There is an option …
GitLab was throwing me a 500 server error this morning after an upgrade via yum. To troubleshoot, I ran the self diagnose command from terminal:
# gitlab-rake gitlab:check
Which gave me the following error to fix:
All migrations up? ... no
Try fixing it:
sudo -u git -H bundle exec …
SELECT count(email),email FROM auth_user GROUP BY email HAVING count(email) > 1;