Actually it as a root user because all application connect to the server by root, the other software is made with python & pscopg2.
I try to connect by psql from the server that as web2py and it worked, also create a model with this script: https://github.com/phektus/cvstash/blob/master/scripts/extract_pgsql_models.py and it try to connect endlessly. Thank for your replay. On 8 September 2013 21:56, Dragan Matic <perakojotgen...@gmail.com> wrote: > Postgres probably doesn't have 'root' as user. Its root user is > 'postgres'. > > After that check if your address is allowed to connect to postgres server > in pg_hba.conf and if server is listening on your network > ('listen_addresses' setting in postgresql.conf). It could also be a > firewall issue, check is port 5432 is open. > > On Sunday, September 8, 2013 5:47:38 PM UTC+2, Sartglider wrote: >> >> Hi, >> I'm really new to web2py - less than 24 hours - >> Trying to follow this example http://web2py.com/books/** >> default/chapter/29/03/**overview#Say-hello<http://web2py.com/books/default/chapter/29/03/overview#Say-hello> >> it worked fine with sqlite, so I try to connect to a postgresql database >> in another server: >> the model is this one: >> db = DAL("postgres://root:<**password>@192.168.0.98/teste") >> >> db.define_table('equipments', >> Field('eq_id', unique=True), >> Field('eq_model'), >> Field('eq_aka'), >> format = '%(title)s') >> >> db.equipments.eq_id.requires = IS_NOT_IN_DB(db, db.equipments.eq_model) >> db.equipments.eq_model.**requires = IS_IN_DB(db, db.equipments.eq_id, >> '%(title)s') >> >> db.equipments.eq_id.writable = False >> >> but I get no errors just the browser trying to connect. >> >> Thank you in advance for your help. >> >> >> Postgresq server: debian 6 & postgresql 8.4 >> web2Py server: debian 7, python 2.7 >> >> -- > > --- > 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/groups/opt_out. > -- --- 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/groups/opt_out.