I think in setup.py you need to tell it where pg_config is ???? /usr/local/pgsql/bin/pg_config
something like that if you didn't. On Fri, Oct 23, 2009 at 1:29 PM, Thadeus Burgess <thade...@thadeusb.com> wrote: > Could you help me with python-postgres installation? > > I installed postgresql, and postgresql-server, they are running, and I can > access postgre through phpPgAdmin. > > I tried installing psycog2 however I get the following traceback > > running build > running build_py > creating build > creating build/lib.linux-i686-2.6 > creating build/lib.linux-i686-2.6/psycopg2 > copying lib/tz.py -> build/lib.linux-i686-2.6/psycopg2 > copying lib/extensions.py -> build/lib.linux-i686-2.6/psycopg2 > copying lib/pool.py -> build/lib.linux-i686-2.6/psycopg2 > copying lib/__init__.py -> build/lib.linux-i686-2.6/psycopg2 > copying lib/psycopg1.py -> build/lib.linux-i686-2.6/psycopg2 > copying lib/extras.py -> build/lib.linux-i686-2.6/psycopg2 > copying lib/errorcodes.py -> build/lib.linux-i686-2.6/psycopg2 > running build_ext > error: No such file or directory > > -Thadeus > > > > > On Fri, Oct 23, 2009 at 1:23 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: >> >> This is just my biased opinion: >> 1) MySQL was fatser than postgresql when it had no transaction >> 2) MySQL has lots of quirks (like max length for text files, no >> multiple alter table in one transaction, and others) >> 3) MySQL was developed by SUN which was bought by Oracle and it is not >> clear what it future is. Some developers have left >> 4) I use postgresql so I have tested it better >> 5) There are very large postgresql databases I know of (like the .org >> domains database), I cannot say the same for mysql (but it may be my >> ignorance). >> 6) postgresql has autovacuum so you do not need to do much >> maintenance. >> >> On Oct 23, 12:56 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: >> > Why do you suggest postgresql? I have done alot of research into the >> > two, >> > and mysql seems to be the more effeciant of the two. >> > >> > From what I gather, mysql is created to be lightweight, and super fast. >> > Postgresql is created to be feature full and stable. >> > >> > However, dreamhost does not provide postgresql on their shared hosting, >> > so >> > for now I will have to use mysql. >> > >> > The site is a web app that tracks fish tanks on gaiaonline.com. >> > Basically, >> > gaia has this mini game called "Booty Grab" (here is more >> > infohttps://www.gaiaonlinehelp.com/ics/support/KBAnswer.asp?questionID=17), >> > that >> > glows at random times. The only way to find if their glowing, is to go >> > through pages and pages of forums... very boring, annoying, and cpu >> > intensive with all of the flash on one page.. >> > >> > Well... My app will contact gaia, ask it for information on a tank, such >> > as >> > when it will be open, and for how long, it stores this data in the >> > database, >> > and displays hyperlinks when pages are available. >> > >> > http://surrenderthebooty.thadeusb.com/ >> > >> > Your welcome to sign up if you would like to see the internals. >> > >> > When attempting to migrate over to mysql, I get an error about key >> > length >> > too long, refer to my other >> > post:http://groups.google.com/group/web2py/browse_thread/thread/27d781db1f... >> > >> > On Thu, Oct 22, 2009 at 8:14 PM, mdipierro <mdipie...@cs.depaul.edu> >> > wrote: >> > >> > > Move to postgresql not mysql ;-). If I may, what is the site? I am >> > > curious. >> > >> > > On Oct 22, 7:56 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: >> > > > It seems as if now, I am not recieving any 503 errors. This must be >> > > > due >> > > to >> > > > the ammount of growth the site recieved in such a short period of >> > > > time, >> > > not >> > > > to mention i'm running it in a shared hosting environment, there is >> > > nothing >> > > > I can do except get a dedicated server, or perhaps figure a way to >> > > > limit >> > > the >> > > > requests based on a random timer. For some odd reason, get requests >> > > > load >> > > > faster, but this could just be a fluke in the environment. >> > >> > > > I have been browsing through error tickets, and it seems that since >> > > > my >> > > > database (sqlite) grew from only 100 tracked items to 1460 tracked >> > > > items >> > > in >> > > > a little over a few hours, every ticket recieved is about migration >> > > > EOFErrors. I will try exporting everything to csv, switching over to >> > > mysql, >> > > > and reimporting. Perhaps this will fix some of the performance >> > > > issues, >> > > and >> > > > the EOF errors.. >> > >> > > > S'Traceback (most recent call last):\n File "gluon/restricted.py", >> > > > line 184, in restricted\n exec ccode in environment\n >> > > > File "/home/.idiosyncrasy/thadeusb/ >> > > > thadeusb.com/surrenderthebooty/applications/init/models/db.py", >> > > > line 42, in <module>\n auth.define_tables() >> > > > # creates all needed tables\n >> > > > File "gluon/tools.py", line 601, in define_tables\n >> > > > self.settings.table_permission_name, migrate))\n >> > > > File "gluon/sql.py", line 1130, in define_table\n >> > > > query = t._create(migrate=migrate)\n >> > > > File "gluon/sql.py", line 1501, in _create\n >> > > > sql_fields_old = cPickle.load(tfile)\nEOFError\n' >> > >> > > > -Thadeus >> > >> > > > On Thu, Oct 22, 2009 at 3:29 PM, Thadeus Burgess >> > > > <thade...@thadeusb.com >> > > >wrote: >> > >> > > > > I can post code later tonight when I get home, I can't even make >> > > > > any >> > > > > changes to code until then since it is a personal project. >> > >> > > > > I will try using a GET request instead, since no data is being >> > > > > passed >> > > > > through post anyways. >> > >> > > > > It is an apache thing, its just odd I only get it when using ajax. >> > > > > It >> > > did >> > > > > not start happening until today when the site received a major >> > > > > influx >> > > of new >> > > > > content to track. >> > >> > > > > There is no way for me to increase threads or processes since this >> > > > > site >> > > is >> > > > > on shared hosting :( >> > >> > > > > -Thadeus >> > >> > > > > On Thu, Oct 22, 2009 at 3:09 PM, mdipierro >> > > > > <mdipie...@cs.depaul.edu >> > > >wrote: >> > >> > > > >> 2py never returns 503. Are you using apache? It may be running >> > > > >> out >> > > > >> of threads or proc >> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
