Thread: Query regarding Infinite Cache
<div class="Section1"><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">Hi, </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">Should I buy license to install Infinite Cache? As of now I do not see a parametercalled </span></font><font face="Arial"><span style="font-family:Arial">edb_icache_warm_tables </span></font><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial; color:navy">in the</span></font><font face="Arial"><span style="font-family:Arial"> </span></font><font color="navy" face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial;color:navy">postgresql.conf as mentioned in ‘Breaking Scalability Barrier Infinite Cache.pdf’. Please guideme.</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">Thanks,</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:navy">Mamatha</span></font></div>
On Tue, 2011-07-19 at 06:03 +0000, Mamatha_Kagathi_Chan@DELL.com wrote: > [...] > Should I buy license to install Infinite Cache? As of now I do not > see a parameter callededb_icache_warm_tablesin thepostgresql.conf as > mentioned in ‘Breaking Scalability Barrier Infinite Cache.pdf’. Please > guide me. > This seems to be a "Postgres Plus Advanced Server" feature. You should ask on one of EDB's forum or mailing list. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
<div class="Section1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D">Hi,</span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D"> </span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D">I am basically an Oracle user and now I am exploring PostgreSQL. I have successfully configured the server.Now if I want to access that server from my machine, what is the process?? Is it like Oracle where I will have toinstall the client or the concept is entirely different? Please help me in setting up a client access on my machine(differentfrom server machine) using Psql for instance.</span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D"> </span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D">Thanks,</span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D">Mamatha</span></div>
On Thu, 2011-08-04 at 12:11 +0000, Mamatha_Kagathi_Chan@DELL.com wrote: > Hi, > > I am basically an Oracle user and now I am exploring PostgreSQL. I have successfully configured the server. Now if I wantto access that server from my machine, what is the process?? Is it like Oracle where I will have to install the clientor the concept is entirely different? Please help me in setting up a client access on my machine(different from servermachine) using Psql for instance. > You need to install a client, whatever it is: psql, pgadmin3, etc. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Hi Mamatha, On 4 August 2011 13:11, <Mamatha_Kagathi_Chan@dell.com> wrote: > I am basically an Oracle user and now I am exploring PostgreSQL. I have > successfully configured the server. Now if I want to access that server from > my machine, what is the process?? Is it like Oracle where I will have to > install the client or the concept is entirely different? Please help me in > setting up a client access on my machine(different from server machine) > using Psql for instance. These sorts of questions are generally better handled by the pgsql-general mailing list. However, you'll have to: 1) Make a pg_hba.conf entry for the machine you'll be connecting from. 2) Set listen_addresses to listen on some IP or '*', rather than just on localhost. 3) Possibly make a new firewall rule. I hope that helps -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services
Thanks Peter. It works . -----Original Message----- From: Peter Geoghegan [mailto:peter@2ndquadrant.com] Sent: Friday, August 05, 2011 4:54 PM To: Chan, Mamatha Kagathi Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Query regarding Infinite Cache Hi Mamatha, On 4 August 2011 13:11, <Mamatha_Kagathi_Chan@dell.com> wrote: > I am basically an Oracle user and now I am exploring PostgreSQL. I have > successfully configured the server. Now if I want to access that server from > my machine, what is the process?? Is it like Oracle where I will have to > install the client or the concept is entirely different? Please help me in > setting up a client access on my machine(different from server machine) > using Psql for instance. These sorts of questions are generally better handled by the pgsql-general mailing list. However, you'll have to: 1) Make a pg_hba.conf entry for the machine you'll be connecting from. 2) Set listen_addresses to listen on some IP or '*', rather than just on localhost. 3) Possibly make a new firewall rule. I hope that helps -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services