Re: Django psycopg error

On Thursday 10 May 2012 11:05 PM, Mike Di Domenico wrote:
> I get no response/error:
> Python 2.6.5 (r265:79063, Apr 16 2010, 13:09:56)
> [GCC 4.4.3] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
>>>> import psycopg2
>>>>
> Thanks for your help,
> Mike
>
> On Thursday, May 10, 2012 1:25:29 PM UTC-4, Karl Sutt wrote:
>> Hello,
>>
>> Open up a Python shell and try
>> import psycopg2
>>
>> And let us know what happens.
>>
>> Karl Sutt
>>
>>
>> On Thu, May 10, 2012 at 5:17 PM, Mike Di Domenico<
>> didomenico.mikej@gmail.com> wrote:
>>
>>> Good afternoon,
>>> I am working on installing Django to work with a postgresql on ubuntu
>>> 10.04 server (32bit). I have postgresql-8.4 installed, Django version 1.5,
>>> python version 2.6.5, and I have the psycopg2 module installed (I think).
>>>
>>> I am getting the error "Error: No module named psycopg"
>>>
>>> I am doing the command "./manage.py syncdb" and in the settings.py file I
>>> have set DATABASE_ENGINE to 'django.db.backends.postgresql_psycopg2' and I
>>> have tried it with just 'postgresql_psycopg2', both I get the same error.
>>>
>>> I have checked to see if psycopg2 is installed by doing the following:
>>> # python
>>>>>> import psycopg2
>>>>>> print(help('modules'))
>>> Please wait a moment while I gather a list of all available modules...
>>>
>>> ANSI aptsources httplib select
>>> BaseHTTPServer array httplib2 serial
>>> Bastion ast ihooks sets
>>> CDROM asynchat imageop setuptools
>>> CGIHTTPServer asyncore imaplib sgmllib
>>> Canvas atexit imghdr sha
>>> CommandNotFound audiodev imp shelve
>>> ConfigParser audioop imputil shlex
>>> Cookie base64 inspect shutil
>>> DLFCN bdb io signal
>>> Dialog binascii itertools simplejson
>>> DistUpgrade binhex json site
>>> DocXMLRPCServer bisect keyword sitecustomize
>>> FSM bsddb landscape smart
>>> FileDialog bz2 launchpadlib smtpd
>>> FixTk cPickle lazr smtplib
>>> GnuPGInterface cProfile lib2to3 snack
>>> HTMLParser cStringIO linecache sndhdr
>>> IN calendar linuxaudiodev socket
>>> LanguageSelector cgi locale spwd
>>> MimeWriter cgitb logging sqlite3
>>> OpenSSL chunk lsb_release sre
>>> PAM cmath macpath sre_compile
>>> Queue cmd macurl2path sre_constants
>>> ScrolledText code mailbox sre_parse
>>> SimpleDialog codecs mailcap ssl
>>> SimpleHTTPServer codeop markupbase stat
>>> SimpleXMLRPCServer collections marshal statvfs
>>> SocketServer colorsys math string
>>> StringIO commands md5 stringold
>>> TYPES compileall mhlib stringprep
>>> Tix compiler mimetools strop
>>> Tkconstants computerjanitor mimetypes struct
>>> Tkdnd contextlib mimify subprocess
>>> Tkinter cookielib mmap sunau
>>> UpdateManager copy modulefinder sunaudio
>>> UserDict copy_reg multifile symbol
>>> UserList crypt multiprocessing symtable
>>> UserString csv mutex sys
>>> _LWPCookieJar ctypes netrc syslog
>>> _MozillaCookieJar curl new tabnanny
>>> __builtin__ curses nis tarfile
>>> __future__ datetime nntplib telnetlib
>>> _abcoll dbhash ntpath tempfile
>>> _ast dbm nturl2path termios
>>> _bisect dbus numbers test
>>> _bsddb dbus_bindings oauth textwrap
>>> _bytesio debconf opcode this
>>> _codecs decimal operator thread
>>> _codecs_cn difflib optparse threading
>>> _codecs_hk dircache os time
>>> _codecs_iso2022 dis os2emxpath timeit
>>> _codecs_jp distutils ossaudiodev tkColorChooser
>>> _codecs_kr django parser tkCommonDialog
>>> _codecs_tw dl pdb tkFileDialog
>>> _collections doctest pexpect tkFont
>>> _csv dsextras pickle tkMessageBox
>>> _ctypes dumbdbm pickletools tkSimpleDialog
>>> _ctypes_test dummy_thread pip toaiff
>>> _curses dummy_threading pipes token
>>> _curses_panel easy_install pkg_resources tokenize
>>> _dbus_bindings email pkgutil trace
>>> _dbus_glib_bindings encodings platform traceback
>>> _elementtree errno plistlib tty
>>> _fileio exceptions popen2 turtle
>>> _functools fcntl poplib twisted
>>> _hashlib fdpexpect posix types
>>> _heapq filecmp posixfile ufw
>>> _hotshot fileinput posixpath unicodedata
>>> _json fnmatch pprint unittest
>>> _locale formatter problem_report urllib
>>> _lsprof fpectl psycopg2 urllib2
>>> _multibytecodec fpformat pty urlparse
>>> _multiprocessing fractions pwd user
>>> _random ftplib pxssh uu
>>> _snack functools py_compile uuid
>>> _socket future_builtins pyclbr wadllib
>>> _sqlite3 gc pycurl warnings
>>> _sre gdbm pydoc wave
>>> _ssl genericpath pydoc_topics weakref
>>> _strptime getopt pyexpat webbrowser
>>> _struct getpass pygtk whichdb
>>> _symtable gettext quopri wsgiref
>>> _testcapi gio random xdrlib
>>> _threading_local glib re xml
>>> _warnings glob readline xmllib
>>> _weakref gobject repr xmlrpclib
>>> abc grp resource xxsubtype
>>> aifc gzip rexec zipfile
>>> anydbm hashlib rfc822 zipimport
>>> apport heapq rlcompleter zlib
>>> apport_python_hook hmac robotparser zope
>>> apt hotshot runpy
>>> apt_inst htmlentitydefs sched
>>> apt_pkg htmllib screen
>>>
>>> Enter any module name to get more help. Or, type "modules spam" to search
>>> for modules whose descriptions contain the word "spam".
>>>
>>> None
>>>
>>>
>>> Where am I going wrong/what am I missing that keeps giving me the error
>>> "Error: No module named psycopg"?
>>>
>>> Thanks,
>>> Mike
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "Django users" group.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msg/django-users/-/gNgL10vfE1sJ.
>>> To post to this group, send email to django-users@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> django-users+unsubscribe@googlegroups.com.
>>> For more options, visit this group at
>>> http://groups.google.com/group/django-users?hl=en.
>>>
>>
Hi!

Psycopg2 is a PostgreSQL database adapter for the Python programming
language.
Install "python-psycopg2" package.

The value for ENGINE in the settings.py should be
"django.db.backends.postgresql_psycopg2"

You can test your database configuration by typing the following commands.
Open the shell by typing "$ python manage.py shell"

>>> from django.db import connection
>>> cursor = connection.cursor()

If nothing happens, your database is configured properly.

Thanks.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.