Thursday, February 23, 2012

Update VPN Peer's Name

Logon into the vpnttgdb database: 
[root@system ~]# export PGPASSWORD=vpnttgpass
[root@system ~]# psql vpnttgdb -h 127.0.0.1 -U vpnttg
psql (8.4.4)
Type "help" for help.

vpnttgdb=#
Update VPN peer's name: 
vpnttgdb=# UPDATE lantolanpeers SET peername = '<name>' WHERE peerid = '<peerid>';
UPDATE 1
vpnttgdb=#
Logout from the vpnttgdb database: 
vpnttgdb=# \q
 

Database Backup 

[root@system ~]# export PGPASSWORD=vpnttgpass
[root@system ~]# pg_dump vpnttgdb -h localhost -U vpnttg -f vpnttgdb.sql