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?
