Обсуждение: Query regarding Infinite Cache
Hi,
Should I buy license to install Infinite Cache? As of now I do not see a parameter called edb_icache_warm_tables in the postgresql.conf as mentioned in ‘Breaking Scalability Barrier Infinite Cache.pdf’. Please guide me.
Thanks,
Mamatha
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
Hi,
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.
Thanks,
Mamatha
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