Recovery issue

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

 



Hi L:sters,

We're at postgresql 8.2.5.  I'm running PITR backups on our production server
and copying the resulting tarball and the WAL logs to our reporting server.
I restart the reporting server and begin re-playing logs.  Everything
works fine for about 3 days until a network outage creates a gap in the
WAL log copies.  The reporting server interprets this as the end of the
logs and comes up in ready mode.

I need to begin recovery at that point and continue to replay logs.
I asked this question last week with no clue how to proceed.
Now I throw an idea out to the group.  Can I take a full file copy on
the reporting server and continue to play logs at the point the last
recovery terminated?

Procedure in summary:

 1.  Start archive logging on the reporting server.
     (Since no updates are occurring on this server there
      should be no logs archived. but I need to start archive
      logging to enable pg_start_backup)
 2.  select pg_start_backup('new_backup')
 3   tar -czvf (the data cluster)
 4.  select pg_stop_backup();
 5.  stop the server. Remove the data cluster
 6.  tar xvf the backup -replenish the data cluster
 7   remove postmaster.pid, (pg_xlogs already removed from backup)
 8.   restart the server using recovery.conf to start copying the
     accumulated archive logs from the production server

Possible?  Or  pipe dream?

Any ideas welcome.  Thank you,

Mark Steben
Database Administrator
AutoRevenue



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux