See below:
On Sunday, January 5, 2014 12:32:26 PM UTC-8, mweissen wrote:
>
>
> I want to change from sqlite to postgresql.
>
> At first I have installed postgresql and prepared everything as described
> in the book. Next I have built a sample application
> with a line like
>
> db1 = DAL("postgres://web2py:web2py123@localhost:5432/securedb")
>
> Works fine!
>
> Now I have tried cpdb ( I have broken the lines for better readablity):
>
> root@test:/home/www-data/web2py# python scripts/cpdb.py
> -f applications/postgesql_test/databases
> -y sqlite://storage.sqlite
> -Y postgres://web2py:web2py123@localhost:5432/securedb
> -d gluon/
> -t False
>
> The result is an error message:
>
> EXCEPTION: could not make a copy of the database
> Failure to connect, tried 5 times:
> Traceback (most recent call last):
> File "gluon/dal.py", line 7766, in __init__
> self._adapter = ADAPTERS[self._dbname](**kwargs)
> File "gluon/dal.py", line 2756, in __init__
> if do_connect: self.find_driver(adapter_args,uri)
> File "gluon/dal.py", line 795, in find_driver
> raise RuntimeError("no driver available %s" % str(self.drivers))
> RuntimeError: no driver available ('psycopg2', 'pg8000')
>
> Next try - a copy from sqlite to sqlite
>
> root@test:/home/www-data/web2py# python scripts/cpdb.py
> -f applications/postgresql_test/databases
> -y sqlite://storage.sqlite
> -Y sqlite://storage2.sqlite
> -F applications/postgresql_test/databases
> -d gluon/ -t False
>
> creating tables...
> exporting data...
> importing data...
> done!
>
> Ok, no problem - cpdb works.
> And now the interactive version:
>
> root@test:/home/www-data/web2py# python scripts/cpdb.py
> -f applications/postgresql_test/databases
> -y sqlite://storage.sqlite
> -Y postgres://web2py:web2py123@localhost:5432/securedb
> -d gluon/ -t False -i
>
> >>> t=DAL("postgres://web2yp:web2py123@localhost:5432/securedb",
> folder=None)
> sorry, can not do that!
> Failure to connect, tried 5 times:
> Traceback (most recent call last):
> File "gluon/dal.py", line 7766, in __init__
> self._adapter = ADAPTERS[self._dbname](**kwargs)
> File "gluon/dal.py", line 2756, in __init__
> if do_connect: self.find_driver(adapter_args,uri)
> File "gluon/dal.py", line 795, in find_driver
> raise RuntimeError("no driver available %s" % str(self.drivers))
> RuntimeError: no driver available ('psycopg2', 'pg8000')
>
>
> I have tried DAL calls like DAL("postgres:psycopg2:") and
> DAL("postgres:pg8000:") - similar results.
>
>
Did you copy the driver into the working directory? Recent versions of
web2py ship with the handlers in a subdirectory (web2py/handlers), so they
don't clobber any changes you made the last time you set them up.
/dps
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
