Hi! 1. I believe one pg-install=one pg-server 2. I think that pg listens only one port until you set another one and restart server
Why do you think you have to have another pg-server? One pg-server can services many databases - just use different names for DAL, i.e. db=DAL() db1=DAL() to connect May be you don't even need another database! If all db-tables are located in one schema you can just create another one and copy tables to it. pg supports safe mode schema-per-user/role - see pgdoc On Friday, January 29, 2016 at 12:51:02 AM UTC+3, Jordan Myers wrote: > > Hello everyone, > I've developed an application that uses postgresql as its backend and I > want to make a copy of the application on the same server (running on the > same instance of web2py) to be used as the deployed version while I > continue work on the development version. I used web2py to package and then > reload the application under a new name "deploy." and now I'm trying to set > up the deploy database. > > I tried setting up another postgresql server, but it doesn't seem to let > me listen on two different ports (which I assume I would need because I > want to access two different database spaces at the same time). So I > decided to just try a completely different database like MSSQL, but it kept > complaining about an unknown data source and unknown server and after a > week of trying to debug it I'm ready to give up. I've run into a similar > issue with FireBird > > Does anyone have any recommendations for a painless way of setting up a > second database server, or some insight into my problems with > postgresql/MSSQL/FireBird? The only requirement is that it is a relational > database that can handle concurrent read-writes (and is supported by > web2py). > > Thanks, > -Vladimir > -- 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.