Saturday, March 05, 2011

Postgres Backup CentOS

#su postgres

$ pg_dump -Ft mydb > db.tar
$ pg_restore -d newdb db.tar


References:
[1]http://linux.die.net/man/1/pg_dump
[2]http://linux.die.net/man/1/pg_restore
By at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Ubuntu Forware port 80

  #!/bin/bash iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 80 -j REDIRECT --to-port 8069 iptables -t nat -A PREROUTING -i eth0 -p tc...