Thread: Unable to bootstrap standby server

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,