[GENERAL] POstgreSQL Tablespace deletion issue

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

the 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 recipient

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

command to switch the slave to master. Now the error message shown is 'Duplicate key violation'. On selecting the next value of the serial key the value shown is different from the actual value. Ie the shown value is very much less than the number of records in the table. Thanks Regards, Vishnu

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

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, Vishnu S

[GENERAL] PostgreSQL server not starting.

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 confidential information. Any

Re: [ADMIN] [GENERAL] Data Not replicating

=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: [ADMIN] [GENERAL] Data

[GENERAL] Slony-I Doubt

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, Vishnu S

Re: [GENERAL] Data Not replicating

Hi, Yes. I have written a script file like the following. include preamble.sk; 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

[GENERAL] Data Not replicating

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 intended recipient. It may contain

[GENERAL] Slony-I cluster creation Help.

\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 image001.png

[GENERAL] Slony-I cluster creation Help.

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] PostgreSQL server not starting.

Regards, Vishnu S

Re: [GENERAL] PostgreSQL server not starting.

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

Re: [GENERAL] Slony-I installation Help

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:04 AM

Re: [GENERAL] Slony-I installation Help

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 From: Sachin Srivastava

[GENERAL] Slony-I installation Help

with the PostgreSQL 8.4 will be available. Please note that I am using Windows XP. Thanks Regards, Vishnu S