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