Re: [GENERAL] Multi tenancy : schema vs databases

2016-10-01 Thread Rakesh Kumar
>do you run a separate instance of the app for each tenant, or is there one app >that identifies the >tenant and handles them accordingly ? Each tenant will have different app server. there will be persistent connection for each tenant. -- Sent via pgsql-general mailing list

Re: [GENERAL] Multi tenancy : schema vs databases

2016-10-01 Thread Melvin Davidson
On Sat, Oct 1, 2016 at 4:52 PM, John R Pierce wrote: > On 10/1/2016 12:52 PM, Rakesh Kumar wrote: > > Do your clients authenticate directly to the database, or to the app server? > > thru app server. > > > do you run a separate instance of the app for each tenant, or is

Re: [GENERAL] Multi tenancy : schema vs databases

2016-10-01 Thread John R Pierce
On 10/1/2016 12:52 PM, Rakesh Kumar wrote: Do your clients authenticate directly to the database, or to the app server? thru app server. do you run a separate instance of the app for each tenant, or is there one app that identifies the tenant and handles them accordingly ? -- john r

Re: [GENERAL] Multi tenancy : schema vs databases

2016-10-01 Thread John R Pierce
On 10/1/2016 11:39 AM, Jeff Janes wrote: As others have said, different databases makes connection pooling less efficient, which could be very important to you, or could be irrelevant. 1000 apps running at once each with their own DB and 10s of connections == 10s of 1000s of database

Re: [GENERAL] Multi tenancy : schema vs databases

2016-10-01 Thread Rakesh Kumar
>Are you restoring because your whole system failed, or because one client did >something >wrong and needs just their data rolled back? Chances of restoring just for one client will probably be 99% of use cases. > Do your clients authenticate directly to the database, or to the app server?

Re: [GENERAL] Multi tenancy : schema vs databases

2016-10-01 Thread Jeff Janes
On Thu, Sep 29, 2016 at 12:18 PM, Rakesh Kumar wrote: > > Hi > > I would like to know which technique is better for supporting > multi-tenancy= > applications, going upto hundreds or even thousands of tenants. > > 1 - One database with difference schemas (one schema

Re: [GENERAL] postgres failed to start from services manager on windows 2008 r2

2016-10-01 Thread Thomas Kellerer
PHANIKUMAR G schrieb am 01.10.2016 um 17:30: We then tried to start the service with the following changes. a. we changed the "Log on as" type to "This account" b. changed the account name to ".\" c. And entered the password for this account and saved. After that we are able to

Re: [GENERAL] postgres failed to start from services manager on windows 2008 r2

2016-10-01 Thread PHANIKUMAR G
Hi, Please help me on this issue, postgresql is failing to start from Windows services manager. Below is the scenario we performed. Verified services manager that postgresql service was registered and failed to start. We tried to start the service manually and observed the following. a.