Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    6

    Unanswered: Warm Standby - log file questions

    I am a newbie tasked with setting up a warm standby server. I have questions about log file content.

    Here is my restore command:
    restore_command = 'pg_standby -d /opt/novell/idm/Postgres/data/archives %f %p %r 2>>standby.log'

    When I restart the server, the screen displays:
    waiting for server to start............................................. ..................could not start server
    PostgreSQL 8.4 did not start in a timely fashion, please see /opt/novell/idm/Postgres/data/pg_log/startup.log for details

    The startup log reads:
    2012-01-21 23:37:53 CST LOG: could not create IPv6 socket: Address family not supported by protocol

    ps aux shows:
    postgres 11764 0.0 0.1 84476 5092 ? S Jan21 0:00 /opt/novell/idm/Postgres/bin/postgres -D /opt/novell/idm/Postgres/data
    postgres 11771 0.0 0.0 47276 1284 ? Ss Jan21 0:00 postgres: logger process
    postgres 11775 0.0 0.0 84476 1408 ? Ss Jan21 0:00 postgres: startup process waiting for 000000020000000000000002
    postgres 11817 0.0 0.0 43904 1604 ? S Jan21 0:00 pg_standby /opt/novell/idm/Postgres/data/archives 000000020000000000000002 pg_xlog/RECOVERYXLOG 000000000000000000000000

    postgresql-date.log shows:
    2012-01-22 00:21:23 CST FATAL: the database system is starting up

    I understand the presence of recovery.conf prevents normal startup. Are these entries normal in the presence of recovery.conf?

  2. #2
    Join Date
    Jan 2012
    Posts
    6

    warm standby

    The solution is working now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •