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.

Reply via email to