I have now copied my app from local sqlite to hosting (virtual server) postgres, at local I will move to postgres too. Here are my hints:
pg_lsclusters: will show if postgres run and at which port connectionstring in private/appconfig.ini: postgres://user:password@localhost:port/database after copy and in case of any starting problem: delete content of sessions folder after copy set ownership correctly: chown -R www-data:www-data applications/ (web2py folder selected) if app/appadmin will start, but it crashes when working with some table (tables aren't created), delete (move away) content of databases/ folder (where probably are old, maybe sqlite definitions). To manage postgres at hosting, /etc/postgresql/9.4/main/postgresql.conf: add: listen_addresses = '*' # more IP restrictions are welcome /etc/postgresql/9.4/main/pg_hba.conf, add: host all all * md5 # more user restrictions are welcome service postgresql restart in remote PgAdmin3 add SSH tunneling (your ssh access settings) # move ssh from port 22 to different one (700-900?) could be good idea against attack Dne neděle 6. ledna 2013 17:43:53 UTC+1 GeeksRule napsal(a): > > > I switched to Postgres recently and things were working fine. > I had to make some major changes, hence deleted the old database & created > a brand new one. > > I accessed a function that inserts new records in a table -> "newsMaster" > But in the logs I see this : > > [error] Trying to insert title : xxxxxxxxxxxxx > > [error] oops: relation "newsmaster" does not exist > > [error] LINE 1: INSERT INTO NewsMaster(name,favorite... > > [error] ^ > > [error] > > [error] Trying to insert title : 'xxxxxxxxxxxxxxxx > > [error] oops: current transaction is aborted, commands ignored until end > of transaction block > > I didn't have to do anything different when I switched to Postgres, it > just created the tables from scratch.. > Am I missing something ? > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.