Re: [GENERAL] Single postgres for Multiple application
Thomas, Thank for your response may put this way. Hello all, Good day. I have the following scenario. System 1: Database: postgresql 8.4 application server: tomcat 6 System 2: Database: Postgresql 8.4 Application Server: Tomcat 6: These system to be able to exchange data. Then I would like to install it to use one postgresql 8.4 and one tomcat 6.all these run on the same machine but different system. Is it possible? Please any help appreciated huu On Sat, Mar 10, 2012 at 12:06 PM, Thomas Kellerer wrote: > Twaha Daudi wrote on 10.03.2012 10:32: > > Hello all, Good day. I have installed postgres 8.4 on ubuntu 11.10 >> desktop.My interest is to test three web-based application.One is >> drupal7.the other two still working on it.There should be possibility >> of data transaction between them.The two web based will work with >> tomcat instances(port:8080) while drupal7 normal Apache 2.0. Is it >> possible? How can configure to achieve that?.any idea or tutorial >> link appreciated. >> >> or the most important are those two application which use tomcat. >> thank you huu >> >> As you say "there should be possibility of data transaction between > them", you can't use databases to separate the individual application. > > You will need to setup schemas and corresponding users to achieve this: > > First you need to create three different users. > Then for each user create one schema and make the corresponding user the > owner of the schema. > > Set the user's search path such that their "own" schema is the only one in > the list (or at least the first one). > That way the application users don't have to prefix all tables. > > Something like this: > > create user u1 password 'welcome'; > create user u2 password 'welcome'; > create user u3 password 'welcome'; > > create schema s1 authorization u1; > create schema s2 authorization u2; > create schema s3 authorization u3; > > alter user u1 set search_path to s1; > alter user u2 set search_path to s2; > alter user u3 set search_path to s3; > > commit; > > For those tables that need to be used by more than one user (i.e. > application) grant the necessary privileges to the other users. > > Regards > Thomas > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> >
[GENERAL] Single postgres for Multiple application
Hello all, Good day. I have installed postgres 8.4 on ubuntu 11.10 desktop.My interest is to test three web-based application.One is drupal7.the other two still working on it.There should be possibility of data transaction between them.The two web based will work with tomcat instances(port:8080) while drupal7 normal Apache 2.0. Is it possible? How can configure to achieve that?.any idea or tutorial link appreciated. or the most important are those two application which use tomcat. thank you huu
[GENERAL] Postgresql as main database
Hello all, Good day, I would like to make Postgresql 8.4 as main database for running three(software) and possible exchanging data.Is it possible? if yes what is the implication in terms of performance? regards huu
Re: [GENERAL] Installing postgresql on windows 7
Ashesh, Yes, I have read and write permission.Please an idea? Twaha On Tue, Nov 22, 2011 at 9:37 AM, Ashesh Vashi wrote: > On Tue, Nov 22, 2011 at 1:05 PM, Twaha Daudi wrote: > >> Hello Ashesh, >> here is the output of the command: >> C:\>echo %TEMP% >> C:\Users\User\AppData\Local\Temp >> >> It looks like the variable is set properly and still there is problem >> Any help? >> >> >> On Tue, Nov 22, 2011 at 7:13 AM, Ashesh Vashi < >> ashesh.va...@enterprisedb.com> wrote: >> >>> >>> On Tue, Nov 22, 2011 at 3:36 AM, Twaha Daudi wrote: >>> >>>> Hello all, >>>> I have tried to install windows 7 on 64bit Acer machine.Both postgresql >>>> 8.4 and 9.0 giving error; >>>> "An error cocured executing the Microsoft VC++ runtime installer >>>> "error for 8.4.while for 9.0 giving me error "Unable to write inside TEMP >>>> enveronment variable? >>>> >>> Looks like your TEMP environment variable is not properly set. >>> Can you please tell me what is the output of this command: "echo %TEMP%"? >>> >>> If it is not properly set, please set it to >>> "%USERPROFILE%\AppData\Local\Temp". >>> Then try to run the installer. >>> >> Do you have read/write permission in that directory? > > -- > > Thanks & Regards, > > Ashesh Vashi > EnterpriseDB INDIA: Enterprise PostgreSQL > Company<http://www.enterprisedb.com/> > > > > *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi> > > >> >>> -- >>> Thanks & Regards, >>> >>> Ashesh Vashi >>> EnterpriseDB INDIA: Enterprise PostgreSQL >>> Company<http://www.enterprisedb.com> >>> >>> >>>> I have tried to check for WSH which is enabled,run as administrator >>>> without success. >>>> What could be the problem? >>>> thanks in advance >>>> huu >>>> >>> >>> >> >
Fwd: [GENERAL] Installing postgresql on windows 7
-- Forwarded message -- From: Twaha Daudi Date: Tue, Nov 22, 2011 at 9:35 AM Subject: Re: [GENERAL] Installing postgresql on windows 7 To: Ashesh Vashi Hello Ashesh, here is the output of the command: C:\>echo %TEMP% C:\Users\User\AppData\Local\Temp It looks like the variable is set properly and still there is problem Any help? On Tue, Nov 22, 2011 at 7:13 AM, Ashesh Vashi wrote: > > On Tue, Nov 22, 2011 at 3:36 AM, Twaha Daudi wrote: > >> Hello all, >> I have tried to install windows 7 on 64bit Acer machine.Both postgresql >> 8.4 and 9.0 giving error; >> "An error cocured executing the Microsoft VC++ runtime installer "error >> for 8.4.while for 9.0 giving me error "Unable to write inside TEMP >> enveronment variable? >> > Looks like your TEMP environment variable is not properly set. > Can you please tell me what is the output of this command: "echo %TEMP%"? > > If it is not properly set, please set it to > "%USERPROFILE%\AppData\Local\Temp". > Then try to run the installer. > > -- > Thanks & Regards, > > Ashesh Vashi > EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com> > > >> I have tried to check for WSH which is enabled,run as administrator >> without success. >> What could be the problem? >> thanks in advance >> huu >> > >
[GENERAL] Installing postgresql on windows 7
Hello all, I have tried to install windows 7 on 64bit Acer machine.Both postgresql 8.4 and 9.0 giving error; "An error cocured executing the Microsoft VC++ runtime installer "error for 8.4.while for 9.0 giving me error "Unable to write inside TEMP enveronment variable? I have tried to check for WSH which is enabled,run as administrator without success. What could be the problem? thanks in advance huu
[GENERAL] PostgresSQL 8.4 to 9.0 on Windows 7
Hello all, Iam newbie here and have been trying to install postgresSQL 8.4 to 9.0 on windows 7 home premium (64).I would like to talk with tomcat 6.0.33.Sometimes it works but it does not communicate to tomcat.What could be the problem? thanks in advance cheers