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,