Skip to content

Instantly share code, notes, and snippets.

django.db.utils.OperationalError
OperationalError: could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" (fe80::1) and accepting
TCP/IP connections on port 5432?
fintech dougbinder$ python manage.py createsuperuser
[profile] heap size is 27.5 MB
Username: doug
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/Users/dougbinder/sites/env/fintech/lib/python2.7/site-packages/django/core/management/__init__.py", line 399, in execute_from_command_line
utility.execute()
File "/Users/dougbinder/sites/env/fintech/lib/python2.7/site-packages/django/core/management/__init__.py", line 392, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
python manage.py migrate
[profile] heap size is 27.9 MB
Running migrations for reversion:
- Nothing to migrate.
- Loading initial data for reversion.
Installed 0 object(s) from 0 fixture(s)
Running migrations for django_extensions:
- Nothing to migrate.
- Loading initial data for django_extensions.
Installed 0 object(s) from 0 fixture(s)
class CompanyGalleryView(RegisteredUserMixin, ListView):
def get_queryset(self):
limit = self.request.user.default_investment_permission
queryset = super(CompanyGalleryView, self).get_queryset()
data = []
data = queryset.filter(company__investment_oppurtunity__user_investment_status__user=self.request.user, company__investment_oppurtunity__user_investment_status__investment_permission__gte=400)
data += queryset.filter(company__investment_status="po")
data.exclude(company__investment_oppurtunity__user_investment_status__user=self.request.user, company__investment_oppurtunity__user_investment_status__investment_permission__lte=300)
@Bind
Bind / gist:e9f112928c4c3a59018f
Created October 13, 2014 19:53
final company gallery view queryset?
def get_queryset(self):
limit = self.request.user.default_investment_permission
queryset = super(CompanyGalleryView, self).get_queryset()
queryset = queryset.filter((Q(company__opportunities__interested_users__username=self.request.user.username) & Q(company__opportunities__userinvestmentstatus__investment_permission__gte=400)) | Q(company__permission_level__lte=limit))
queryset = queryset.exclude(Q(company__opportunities__interested_users__username=self.request.user.username) & Q(company__opportunities__userinvestmentstatus__investment_permission__lte=300))
return queryset
Verifying that +doug_binder is my openname (Bitcoin username). https://onename.io/doug_binder
(fintech)➜ fintech git:(feature/elasticsearch) ✗ fig up
Recreating fintech_search_1...
Recreating fintech_cache_1...
Recreating fintech_db_1...
Recreating fintech_web_1...
Attaching to fintech_search_1, fintech_cache_1, fintech_db_1, fintech_web_1
search_1 | [2015-01-13 22:00:28,226][INFO ][node ] [Farallah] version[1.4.1], pid[1], build[89d3241/2014-11-26T15:49:29Z]
search_1 | [2015-01-13 22:00:28,226][INFO ][node ] [Farallah] initializing ...
search_1 | [2015-01-13 22:00:28,232][INFO ][plugins ] [Farallah] loaded [], sites []
search_1 | [2015-01-13 22:00:32,021][INFO ][node ] [Farallah] initialized
(fintech)➜ fintech git:(feature/elasticsearch) ✗ heroku run ./manage.py rebuild_index --app fintech-development
Running `./manage.py rebuild_index` attached to terminal... up, run.5241
WARNING: This will irreparably remove EVERYTHING from your search index in connection 'default'.
Your choices after this are to restore from backups or rebuild via the `rebuild_index` command.
Are you sure you wish to continue? [y/N] y
Removing all documents from your index because you said so.
Failed to clear Elasticsearch index: ConnectionError([Errno 1] _ssl.c:510: error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol) caused by: SSLError([Errno 1] _ssl.c:510: error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol)
All documents removed.
Indexing 12 investment opportunities
@Bind
Bind / gist:92fe0bf52c380432ffe8
Created July 20, 2015 19:09
scratch pad for App Research
10 News Apps
CNN
YAHOO NEWS DIGEST
FLIPBOARD
NYT
MEDIUM
PINTEREST
BUZZFEED
GOOGLE NEWS
<body id=\"archivebody\" leftmargin=\"0\" marginwidth=\"0\" topmargin=\"0\" marginheight=\"0\" offset=\"0\" style=\"margin: 0;padding: 0;-ms-text-size-adjust: 100%;-webkit-text-size-adjust: 100%;background-color: #ffffff;height: 100% !important;width: 100% !important;\"> <div id=\"awesomewrap\"> <div id=\"awesomeshare\"> <div id=\"zclipwrap\"> <label for=\"shortURL\">Short URL</label> <span id=\"copyURL\" data-clipboard-target=\"shortURL\"> <input id=\"shortURL\" name=\"shorturl\" style=\"margin-top:6px;\" type=\"text\" value=\"http://eepurl.com/bye6pf\" class=\"av-text\"> <span>Copy</span> </span> <div id=\"zero_clipboard\"></div> </div> <ul id=\"awesomesocial\"> <li class=\"fbk\"> <a class=\"fbk-like\" id=\"campaign-fb-like-btn\" rel=\"socialproxy\" href=\"http://us3.campaign-archive.com/social-proxy/facebook-like?u=e0d9358567a14ab2f37440e8b&amp;id=a5849b376a&amp;url=http%3A%2F%2Fus3.campaign-archive.com%2F%3Fu%3De0d9358567a14ab2f37440e8b%26id%3Da5849b376a&amp;title=Curated%20News%20with%20Context\" title=\