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.
Any ideas?
Regards, Martin
--
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.
