On 13 June 2012 10:55, Paolo <[email protected]> wrote:
> Hi all,
> I am getting several errors switching from sqlite to postgres
>
Are you starting out on PostgreSQL with an empty database?
> my connection string for sqlite was:
> db = DAL('sqlite://storage.sqlite', migrate=True)
> while for postgres is:
> db = DAL('postgres://web2py:web2py@**localhost:5432/mydb', migrate=True)
>
> so far, I got tickets saying
> ProgrammingError: relation "auth_user" already exists
>
>
Which means that DAL could not create the table 'auth_user' because there
was one already.
If you start with an empty database, drop all the app-related-tables in
Postgresql and remove all the files in
/web2py/applications/your_app/database
Otherwise if all the tables already in the PostgreSQL-database, try
starting your database connection with 'migrate = False' or specify the
migrate option per table.
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
