[GENERAL] Streaming replication failed to start scenarios

Hi all, I have been testing streaming replication in windows with postgres 9.1.1. For few scenario's I haven't found a solution. Please advice me. 1. Precautions before promoting standby server to primary manually considering the dead primary server ?? 2. How could we ensure the standby has rece

Re: [GENERAL] Streaming replication failed to start scenarios

Hey Laurenz Albe, Thank you for the quick reply.. > 3. When the dead primary is switchedto standby the streaming is not > happening due to current_wal_location is ahead in the standby server is > ahead of wal_sent_location. In this case how can I start streaming without > taking a fresh base

Re: [GENERAL] Streaming replication failed to start scenarios

Hi Laurenz Albe, I have tested using cygwin rsync in windows 2008 R2, just after restart the server. for 10 GB it took nearly 5 minutes to sync, for 50 GB it took nearly 30 minutes, -- too long Though there were no big changes. My requirement is something less than 5 minutes. I am doing high av

Re: [GENERAL] Streaming replication failed to start scenarios

Well.. There should be a standby server ready to server as a primary if the current primary goes down right ?? But the dead primary is yet in the mode of configuring stage or probably failed to be a standby server. In my high availability cluster there are only two servers. --Reddy. -- Vie

Re: [GENERAL] Streaming replication failed to start scenarios

Hi Laurenz Albe, Correct me If am wrong in doing the high availability for postgresql with two servers win windows postgres 9.1 S1 -Primary S2 -Standby S1 -dead, S2- becomes primary S1-comes back and This should be turned to a new standby --Am I wrong ??--This step is most time taking one, Whi

[GENERAL] PSQL 9.1 Streaming Replication Windows 2008 64 bit Servers

Hi all, I am very new to psql wanted to implement streaming replication on Windows 2008 64 bit Servers installed with PSQL 9.1. Unfortunately the standby server not even showing anything in the log regarding the replication as below: standby log: 2012-02-27 19:30:23 MYT LOG: database system was

Re: [GENERAL] PSQL 9.1 Streaming Replication Windows 2008 64 bit Servers

Hi Adrian, Thanks for the reply streaming is working after placing the recovery.conf in standby data folder. I add an extra configuration in the recovery.conf : archive_cleanup_command='pg_archivecleanup 10.1.18.16\\DB_Stream_Share\\ %r' The standby server log file says error as below : 2

[GENERAL] archive_cleanup_command recovery.conf Standby server error

Streaming replication in the standby has successfully started (windows 2008 server) but, the configuration in the recovery.conf : archive_cleanup_command='pg_archivecleanup 10.1.18.16\\DB_Stream_Share\\ %r' standby server log file says error as below : 2012-02-28 10:59:01 MYT FATAL: the d

Re: [GENERAL] archive_cleanup_command recovery.conf Standby server error

Hi Adrian, The pg_archivecleanup.exe is already installed with postgresql 9.1, it is under bin folder. I tried manually to run the command pg_archivecleanup.exe 10.1.18.16\\DB_Stream_Share\\ %r -- it didnt recognize the path pg_archivecleanup.exe \\10.1.18.16\DB_Stream_Share\ %r --it didnt rec

Re: [GENERAL] archive_cleanup_command recovery.conf Standby server error

Dear Dhaval, I tried as you told as below archive_cleanup_command='c:\\Program files\\postgresql\\9.1\\pg_archivecleanup.exe 10.1.18.16\\DB_Stream_Share\\ %r' this didnt work gave a error in the log file. -- View this message in context: http://postgresql.1045698.n5.nabble.com/archive-cle

Re: [GENERAL] archive_cleanup_command recovery.conf Standby server error

1. I tried with below command in recovery.conf with the exe pointing to the location where it is present. Result: 2012-02-29 19:56:49 MYT WARNING: archive_cleanup_command ""D:\Program Files (x86)\PostgreSQL\9.1\data\pg_archivecleanup.exe" -d \\NOBE-HGG-SRV-04\DB_Stream_Share\ %r": return code 1 '

[GENERAL] Lost data Folder, but have WAL files--- How to recover the database ?? Windows

Hi All, Recently i was doing streaming replication, I lost the data folder on both the servers and left with WAL archives (some how). Can any one tell me how to recover database with WAL archives. Thanks in advance. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Lost-

[GENERAL] HotStandby --Advice needed

Configured server1 to be primary archiving on and server2 as standby with base backup(only first time) to replicate from primary. If Primary(server1) is down standby(server2) is configured as primary and starts archiving to the same WAL archive. If the previous primary(Server1) comes up it will

Re: [GENERAL] HotStandby --Advice needed

Adding to the previous question Should recovery in the standby using restore_command is done only with base_backup which was taken for the first time or It can be at any point of time on standby is recovered using restore_command ?? -- View this message in context: http://postgresql.1045

Re: [GENERAL] How to avoid base backup in automated failover

Hey Amitkapila, Thank you for the quick reply. How can implement this patch in windows, because I am using windows 9.1.1 postgreSQL application ?? ___ If you reply to this email, your message will be added to the discussion below: http://postgresq