[GENERAL] POstgreSQL Tablespace deletion issue

2011-10-18 Thread Vishnu S.
PostgreSQL is installed.) Is there any chances for failing the crash recovery? Is there any chance for deleting the table space files, if the crash recovery is failed ? How can we avoid this ? Thanks & Regards, Vishnu S * Confidentiality Statement/Disclaimer *

[GENERAL] Tablespace files deleted during continuous run

2011-10-13 Thread Vishnu S.
tables in the tablespace in certain interval. Is there any problem related to this? Can you tell me the reason for this? Thanks & Regards, Vishnu S * Confidentiality Statement/Disclaimer * This message and any attachments is intended for the sole use of the intended recip

[GENERAL] Serial key mismatch in master and slave, while using slony

2010-12-18 Thread Vishnu S.
& Regards, Vishnu S * Confidentiality Statement/Disclaimer * This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not

[GENERAL] How to Rejoin a Node after failover [Postgre SQL replication using Slony-I]

2010-10-20 Thread Vishnu S.
machine and Master B slave machine. Please help me to create scripts for this. I have tried without dropping the node too. But it also not working. Please tell me how to rejoin a dropped node into the replication set after failover. Thanks & Regards, Vish

[GENERAL] PostgreSQL server not starting.

2010-10-14 Thread Vishnu S.
lave and the Promote Node 1 to Master. Please help to create the script file for this. Thanks & Regards, Vishnu S * Confidentiality Statement/Disclaimer * This message and any attachments is intended for the sole use of the intended recipient. It may contain confi

[GENERAL] Slony-I Doubt

2010-10-06 Thread Vishnu S.
Hi, I have some doubts. Whether Replication will work if Master database server and slave database server are on the same machine? Is the communication is via services ? Is it required that both Master and Slave must have same slony service name? Thanks & Regards, Vish

Re: [ADMIN] [GENERAL] Data Not replicating

2010-10-05 Thread Vishnu S.
port=5433 user=postgres password=* dbname=slave11'; Thanks & Regards, Vishnu S -Original Message- From: Devrim GÜNDÜZ [mailto:dev...@gunduz.org] Sent: Tuesday, October 05, 2010 5:52 PM To: Vishnu S. Cc: pgsql-ad...@postgresql.org; pgsql-general@postgresql.org Subject: Re: [A

Re: [GENERAL] Data Not replicating

2010-10-05 Thread Vishnu S.
Hi, Yes. I have written a script file like the following. include ; init cluster (id=1, comment='hostname=10.2.26.53 port=5432'); Thanks & Regards, Vishnu S -Original Message- From: Devrim GÜNDÜZ [mailto:dev...@gunduz.org] Sent: Tuesday, October 05, 2010 10:59 AM To

[GENERAL] Data Not replicating

2010-10-04 Thread Vishnu S.
e_id LOG: could not receive data from client: No connection could be made because the target machine actively refused it. What is the wrong ? Thanks and Regards, Vishnu S * Confidentiality Statement/Disclaimer * This message and any attachments is intended for the sole use of the intende

[GENERAL] Slony-I cluster creation Help.

2010-10-01 Thread Vishnu S.
Hi, I have trying to create a new Slony-Cluster using pgAdmin. When I clicked the OK button the following Error message is shown. The configured Slony-I path is C:\Program Files\PostgreSQL\8.4\share ( where the slony script files are present.) Thanks & Regards, Vishnu S <>

[GENERAL] Slony-I cluster creation Help.

2010-10-01 Thread Vishnu S.
is C:\Program Files\PostgreSQL\8.4\share ( where the slony script files are present.) The slony is installed using stack builder. The working platform is Windows Xp Using PostgreSQL version 8.4 Thanks & Regards, Vishnu S <>

Re: [GENERAL] PostgreSQL server not starting.

2010-09-30 Thread Vishnu S.
Hi, On starting the server using pg_ctl command the following message is shown. server starting C:\Program Files\PostgreSQL\8.4\bin>2010-09-30 14:36:07 ISTLOG: could not create file "postmaster.opts": Permission denied. Thanks & Regards, Vishnu S

[GENERAL] PostgreSQL server not starting.

2010-09-30 Thread Vishnu S.
Thanks & Regards, Vishnu S

Re: [GENERAL] Slony-I installation Help

2010-09-28 Thread Vishnu S.
Hi, Yes. Both matches with that specified in the Tools-> options in IE (which is the same we used for configuring in stack builder). Thanks & Regards, Vishnu S From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com] Sent: Wednesday, September 29, 2010 11:0

Re: [GENERAL] Slony-I installation Help

2010-09-28 Thread Vishnu S.
Hi, Yes, using some proxy. The XML file mentioned in the URL can be opened in browser. Even after setting the proxy values mentioned in the IE (Tools->Internet Options ->Connections->LAN settings), the same message box is shown. Thanks & Regards, Vishnu S

[GENERAL] Slony-I installation Help

2010-09-27 Thread Vishnu S.
Slony-I, compatible with the PostgreSQL 8.4 will be available. Please note that I am using Windows XP. Thanks & Regards, Vishnu S

[GENERAL] How to limit database size

2005-08-23 Thread Vishnu
Hi, How can I limit the maximum space uses by Posgres database ??. So that it should not use total disk space available on system. Thanks in advance, Vishnu ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an