Saturday, July 21, 2012

Re: Newbie -- issue with psycoppg2

On Sat, 21 Jul 2012 03:57:33 -0700 (PDT), Quincy Kwende
<quincykwende@gmail.com> declaimed the following in
gmane.comp.python.django.user:

>
> Hello,
>
> I get the bug on the attached file. I don't know how to create a database
> using PostgreSQL.

At this stage, you need to read PostgreSQL documentation; in
particular, how to administer a relational database server (accessing
the server from command line, creating user accounts, etc.) -- none of
your problems are Python/Django related.

Unfortunately all my PostgreSQL books date back to a decade or more
ago. Running PostgreSQL (v7.1.2 - 7.1.4) on Windows at that time
required installing Cygwin. Google shows that there are now native
installers for version 9.1.4 which are supposed to include a GUI
administration interface.

And as a note: Windows command lines do support cut&paste of text --
screen dumps (binary files) are frowned upon in most text-based groups.

"import psycopg2"
Failed as that is a Python statement to load the Python db-api
adapter that allows Python to access PostgreSQL

"dbshell"
Failed as that appears to be specific to mongoDB (or Nokia Symbian
systems).

"python manage.py syncdb"
Appears to have failed because you didn't configure the Django
configuration with a valid PostgreSQL user/password


Unless you really need to use PostgreSQL, I'd suggest configuring
for simple SQLite3 (which is included in current Python installs --
though you may want to download the stand-alone package just to get the
command line tool for it [or find the Firefox plug-in that gives you a
simple graphical tool]).



--
Wulfraed Dennis Lee Bieber AF6VN
wlfraed@ix.netcom.com HTTP://wlfraed.home.netcom.com/

--
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.

No comments:

Post a Comment