Unable to bootstrap standby server
От | Stuart Nadin |
---|---|
Тема | Unable to bootstrap standby server |
Дата | |
Msg-id | D4A0D931EFEC2A42B19ADBD8ADE714184872C9D9@CIS-LEA-EXC-P.cisilion.com обсуждение исходный текст |
Список | 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
В списке pgsql-novice по дате отправления: