======Database query to alter LAN Forwarding rules for one server to go to another======

If a LAN forwarding destination server fails, you may wish to change the queued messages to go to the new server. (Note that, if planning ahead, it may be easier to use DNS host names as the targets in the rules, so you can simply change the IP address associated with the server host name instead)

As this database query updates the database, be sure to take care doing it as you can damage your VPOP3 installation if you do it incorrectly. Make sure you have a database backup before performing the query.

If you want an extra bit of safety, see the [[running database updates within a transaction]] article.

At a command prompt in the VPOP3 directory run

  psql
  
(The password is 'vpop3pass')

Then, type

  UPDATE messages.outgoingtargets SET target='<new server>' WHERE target='<old server>';
  
Where <new server> and <old server> are the IP address (and optional port number if not 25) of the new & old LAN forward target servers respectively. Don't include the <>.

eg

  UPDATE messages.outgoingtargets SET target='192.168.1.53' WHERE target='192.168.1.52:587';

If you have SMTP authentication on the new server, you can use

  UPDATE messages.outgoingtargets SET target='<new server>', username='<username>' password='<password>' WHERE target='<old server>';


N.B. VPOP3 does not need to be stopped while you do this