[GENERAL] pgpool HA not working

2011-07-24 Thread Sanjay Rao
):Started squarepant FAILED Failed actions: pgpool_monitor_3 (node=squarepant, call=1874, rc=7, status=complete): not running Thanks & Regards Sanjay

[GENERAL] Standby server does not start with base backup

2011-06-18 Thread Sanjay Rao
ion files of standby server. Please help me if anybody have any such experience or know the exact cause of the issue. Regards, Sanjay # PostgreSQL Client Authentication Configuration File # === # # Refer to the "Client Authentication" sec

Re: [GENERAL] streaming replication trigger file

2011-06-16 Thread Sanjay Rao
16504, the standby's identifier is 5618757422882348667. Does anybody have any idea ? Regards, Sanjay Rao On 6/16/2011 2:50 PM, Sanjay Rao wrote: Hi Rumman, Can you send me link to "how to create postgres replication on windows." I tried few hours as per following link, but not

Re: [GENERAL] streaming replication trigger file

2011-06-16 Thread Sanjay Rao
help would be appreciated. Regards, Sanjay Rao On 6/16/2011 2:01 PM, AI Rumman wrote: Hi all, I am a bit confused regarding streaming replication. I have two server: A and B. I set up replication successfully. But when the master A goes down, B are not acting as master. My recovery.conf

Re: [GENERAL] postgres server on windows with high availability and failover safe

2011-06-10 Thread Sanjay Rao
HI John, I would not mind to go for linux. Is there any guide to setup failover safe postgres servers on linux/windows ? I found few, but noe of them is complete/descriptive. Regards, Sanjay Rao On 6/9/2011 11:30 PM, John R Pierce wrote: On 06/09/11 2:45 AM, Sanjay Rao wrote: Hi, If

[GENERAL] how to add a replication connection entry in pg_hba.con file

2011-06-09 Thread Sanjay Rao
tgres", SSL off -Sanjay Rao -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] postgres server on windows with high availability and failover safe

2011-06-09 Thread Sanjay Rao
Hi, If anybody have setup this thing earlier or have any idea about how to setup this, Please let me know. I am newbie in setting up database servers . Regards, Sanjay Rao -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Stock Market Price Data & postgreSQL? HELLPPP Please

2009-08-19 Thread Sanjay Arora
On Thu, Aug 20, 2009 at 4:23 AM, Tom Lane wrote: > It does sound like you are doing pretty much exactly what we were > doing.  One thing to think about is that the real-time case is actually > much slower and easier to deal with than back-testing.  When you are > back-testing, you'd like to test a

Re: [GENERAL] Stock Market Price Data & postgreSQL? HELLPPP Please

2009-08-19 Thread Sanjay Arora
Thanks Tom For this reply and many earlier ones that have guided me around postgres ;-) On Thu, Aug 20, 2009 at 3:34 AM, Tom Lane wrote: > Sanjay Arora writes: >  It might be worth managing your > tick data using DBMS entries that represent, say, monthly tick data > files.  Act

Re: [GENERAL] Stock Market Price Data & postgreSQL? HELLPPP Please

2009-08-19 Thread Sanjay Arora
r major scientific applications like real time data acquisition & analysis & etc. So why is this sort of application not supported in postgres natively? First time, I've come across a db application that I cannot handle with postgres in my 9 years of using postgres.. Best regards. Sanjay. --

Re: [GENERAL] Stock Market Price Data & postgreSQL? HELLPPP Please

2009-08-19 Thread Sanjay Arora
sic amount of work you'd like to > do, then build off that. > I'll get back on this by tomorrow. Thanks. With best regards. Sanjay. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Stock Market Price Data & postgreSQL? HELLPPP Please

2009-08-19 Thread Sanjay Arora
eSQL solution, can't spend more than few hundred dollars for thisso please...HELLLPPP ;-) With best regards. Sanjay. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-18 Thread Sanjay Arora
Thanks Stuart I will try Ubuntu image at Amazon cloud. Seems..they are looking for testers too. Not much of tester, but will be able to at least post to list if something fails ;-) Will try centos after that. With best regards. Sanjay Arora. On Tue, Mar 17, 2009 at 12:10 PM, Stuart Bishop wrote

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-03 Thread Sanjay Arora
I found today that postgres EnterpriseDB supports Amazon EC2. On a shoestring budget EnterpriseDB is just as much an option as Oracle ;-( So, question is what makes EnterpriseDB more suitable for the cloud than plain vanilla postgreSQL? Anyone? With best regards. Sanjay. On Tue, Mar 3, 2009

[GENERAL] postgreSQL & amazon ec2 cloud

2009-03-02 Thread Sanjay Arora
Hello all Is it possible to host postgreSQL on Amazon's cloud? What are the issues involved? With best regards. Sanjay.

Re: [GENERAL] Creating indices on foreign keys

2007-08-29 Thread Sanjay
assume I am correct: http://groups.google.co.in/group/pgsql.general/browse_thread/thread/516db5b5f36c82d0 thanks Sanjay ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail comma

[GENERAL] Creating indices on foreign keys

2007-08-29 Thread Sanjay
Hi All, I think PostgreSQL does not create indexes on foreign keys of a table, and I have to do so explicitly. That means, wherever I am using master- detail table, I have to create explicit indexes on the foreign key in the detail table. Am I wrong? thanks Sanjay

Re: [GENERAL] EXPLAIN ANALYZE not considering primary and unique indices!

2007-08-29 Thread Sanjay
Thanks a lot everybody! I got it clear. I was wrongly thinking that PostgreSQL might not be creating the indices by default. regards Sanjay ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

[GENERAL] EXPLAIN ANALYZE not considering primary and unique indices!

2007-08-27 Thread Sanjay
the primary key. Needing help. thanks Sanjay ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Attn. PostgreSQL.org webmasters: Site Link not working

2006-02-21 Thread Sanjay Arora
Page: http://www.postgresql.org/docs/faqs.FAQ.htmlSection 2.3 GUI Tools Link http://techdocs.postgresql.org/guides/GUITools Proxy ErrorThe proxy server received an invalid response from an upstream server.The proxy server could not handle the request GET /guides/GUITools.Reason: Could not connect t

[GENERAL] RPM for whitebox linux - RH ES3 Clone

2005-03-08 Thread Sanjay Arora
Hi Can someone please tell me if & where rpm files for pgsql 8.1 for RH-ES3/whitbox linux can be found? Or do I have to compile? With best Rgds. Sanjay. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister com

[GENERAL] Confused about SHMMAX

2001-06-25 Thread Sanjay Bhatia
Hi, Can someone please tell me how to figure the optimal value of SHMMAX? I have not been able to find this information in the docs. Thanks, sb ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscrib

[GENERAL] Re: VACUUM and 24/7 database operation

2001-01-23 Thread Sanjay Arora
t any good like PG? Will provide failover too..rather than using Oracle. With best regards. Sanjay. At 05:53 PM 1/23/01 , Tom Lane wrote: >[EMAIL PROTECTED] writes: >> - Is 2 minutes a standard time for vacuuming a 500.000 rows table ? >> - Can it be reduced ? >> - In a far futur