Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: pg_standby ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 9 Topic 15509 of 16941
Post > Topic >>

Re: pg_standby / WAL archive-restore through system

by alvherre@[EMAIL PROTECTED] (Alvaro Herrera) May 13, 2008 at 11:31 AM

someone wrote:

>>> Can I shutdown Server B (backup/recovery postmaster) simply by  
>>> killing the postmaster and restart it back in recovery mode to  
>>> continue re-syncing where it left off?  Or does stopping Server B  
>>> while in recovery mode require any manual re-sync steps before it can 
>>> resume recovery?
>>
>> I think you'll need to redo the whole process : restore the full data  
>> backup, create the recovery.conf file, etc.

No, you don't.  The server can continue replaying files.

-- 
Alvaro Herrera                               
http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 sup****t

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




 9 Posts in Topic:
pg_standby / WAL archive-restore through system restarts
d.wall@[EMAIL PROTECTED]   2008-05-12 08:51:58 
Re: pg_standby / WAL archive-restore through system restarts
guillaume@[EMAIL PROTECTE  2008-05-13 14:37:26 
Re: pg_standby / WAL archive-restore through system restarts
d.wall@[EMAIL PROTECTED]   2008-05-13 08:27:47 
Re: pg_standby / WAL archive-restore through system
alvherre@[EMAIL PROTECTED  2008-05-13 11:31:58 
Re: pg_standby / WAL archive-restore through system restarts
guillaume@[EMAIL PROTECTE  2008-05-13 18:48:38 
Re: pg_standby / WAL archive-restore through system restarts
tgl@[EMAIL PROTECTED] (T  2008-05-13 11:54:37 
Re: pg_standby / WAL archive-restore through system restarts
d.wall@[EMAIL PROTECTED]   2008-05-13 09:13:33 
Re: pg_standby / WAL archive-restore through system restarts
tgl@[EMAIL PROTECTED] (T  2008-05-13 12:18:35 
Re: pg_standby / WAL archive-restore through
xzilla@[EMAIL PROTECTED]   2008-05-13 14:23:27 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 12:41:20 CDT 2008.