Unable to bootstrap standby server

From: Stuart Nadin <snadin(at)Cisilion(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Unable to bootstrap standby server
Date: 2014-09-03 15:15:27
Message-ID: D4A0D931EFEC2A42B19ADBD8ADE714184872C9D9@CIS-LEA-EXC-P.cisilion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello.

I'm trying to setup an HA installation using PostgreSQL v9.3. The operating system is Windows Server 2008 R2. I've configured the primary server to archive the WAL files to a directory on the standby server. I've made a Base Backup of the primary and copied it to the Standby server. I've created a recovery.conf file as shown below:

standby_mode = 'on'
restore_command = 'copy c:\pg_archive\%f %p'
archive_cleanup_command = 'pg_archivecleanup c:\pg_archive %r'

The postgresql-x64-9.3 service will not start. Pg_log contains the following:

2014-09-03 16:00:18 BST LOG: database system was shut down in recovery at 2014-09-03 15:59:32 BST
2014-09-03 16:00:18 BST LOG: entering standby mode
2014-09-03 16:00:18 BST FATAL: the database system is starting up
2014-09-03 16:00:19 BST FATAL: the database system is starting up
2014-09-03 16:00:19 BST FATAL: the database system is starting up
2014-09-03 16:00:19 BST FATAL: the database system is starting up

The Windows Event Log shows the following errors:

2014-09-03 15:56:29 BST WARNING: could not create listen socket for "*"
2014-09-03 15:56:29 BST FATAL: could not create any TCP/IP sockets

Has anyone managed to get this to work on Windows?

Regards,

Stuart Nadin

Browse pgsql-novice by date

  From Date Subject
Next Message Luiz Matsumura 2014-09-03 23:07:40 Re: Join three tables and specify criteria... I know this should be easy!
Previous Message mkohls 2014-09-03 12:44:41 Re: C partition management