Search Postgresql Archives

Re: PG 9.3 Switch streaming to wal shipping

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Crap!  Is this a problem?!

I switched back to cp, all was going well, here are some logs:

Sep 29 16:07:10 webserv postgres[17735]: [590-1] ,,2014-09-29 16:07:10.888 CDT,: LOG: restored log file "00000002000000B900000023" from archive Sep 29 16:07:13 webserv postgres[17734]: [3-1] ,,2014-09-29 16:07:13.971 CDT,: LOG: received fast shutdown request Sep 29 16:07:13 webserv postgres[17734]: [4-1] ,,2014-09-29 16:07:13.971 CDT,: LOG: aborting any active transactions Sep 29 16:07:13 webserv postgres[17739]: [2-1] ,,2014-09-29 16:07:13.995 CDT,: LOG: shutting down Sep 29 16:07:13 webserv postgres[17739]: [3-1] ,,2014-09-29 16:07:13.995 CDT,: LOG: database system is shut down

So it was at 00000002000000B900000023.

I switched recovery.conf to:

restore_command = '/usr/local/pg93/bin/pg_standby -d /pub/archive %f %p 2>>/tmp/standby.log'

and restart PG.  PG log shows:
Sep 29 16:08:56 webserv postgres[19054]: [2-1] ,,2014-09-29 16:08:56.002 CDT,: LOG: database system was shut down in recovery at 2014-09-29 16:07:13 CDT Sep 29 16:08:56 webserv postgres[19054]: [3-1] ,,2014-09-29 16:08:56.002 CDT,: LOG: entering standby mode Sep 29 16:08:56 webserv postgres[19054]: [4-1] ,,2014-09-29 16:08:56.017 CDT,: LOG: restored log file "00000002.history" from archive Sep 29 16:08:56 webserv postgres[19054]: [5-1] ,,2014-09-29 16:08:56.042 CDT,: LOG: restored log file "00000002000000B900000015" from archive

I was at 23! Did it really replay 15? How bad is that? /tmp/standby.log makes no sense at all:

Trigger file:         <not set>
Waiting for WAL file: 00000002.history
WAL file path:        /pub/archive/00000002.history
Restoring to:         pg_xlog/RECOVERYHISTORY
Sleep interval:       5 seconds
Max wait interval:    0 forever
Command for restore: cp "/pub/archive/00000002.history" "pg_xlog/RECOVERYHISTORY"
Keep archive history: no cleanup required
running restore:      OK
Trigger file:         <not set>
Waiting for WAL file: 00000002000000B900000015
WAL file path:        /pub/archive/00000002000000B900000015
Restoring to:         pg_xlog/RECOVERYXLOG
Sleep interval:       5 seconds
Max wait interval:    0 forever
Command for restore: cp "/pub/archive/00000002000000B900000015" "pg_xlog/RECOVERYXLOG"
Keep archive history: no cleanup required
running restore:      OK
Trigger file:         <not set>
Waiting for WAL file: 00000002000000B900000006
WAL file path:        /pub/archive/00000002000000B900000006
Restoring to:         pg_xlog/RECOVERYXLOG
Sleep interval:       5 seconds
Max wait interval:    0 forever
Command for restore: cp "/pub/archive/00000002000000B900000006" "pg_xlog/RECOVERYXLOG"
Keep archive history: no cleanup required
WAL file not present yet.
WAL file not present yet.
WAL file not present yet.


Why did it jump from 15 back to 6? Why did it even start at 15? Am I hosed at this point? I really don't want to make another base backup.

-Andy




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux