I guess we have to wait for maybe Massimo to look into this.
Kenneth
Hi Kenneth, Yes both the connection strings work in db.py which I too
find very puzzling. On Jul 23, 12:24 pm, Kenneth Lundström
<[email protected]> wrote:
It sounds like web2py is not able to open either the sqlite file or
postgres database. Have you tried to use both connection strings in a
model file to test that both works?
Kenneth
I am having a hard time migrating data from sqlite to postgres
This is the command that I use
./web2py.py -S testapp -M -N -R scripts/cpdb.py -A -f
sqlite://applications/testapp/databases/storage.sqlite -y 'sqlite://
applications/testapp/databases/storage.sqlite' -Y 'postgres://
puser:ppass@localhost/testdb'
It says
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2011
Version 1.97.1 (2011-06-26 19:25:44)
Database drivers available: SQLite3, pymysql, PostgreSQL
EXCEPTION: could not make a copy of the database
Failure to connect, tried 5 times:
unable to open database file
Any idea how to make this work?
