On Wednesday 24 October 2007 10:39:23 smiley2211 wrote: > Does someone have a script that backups a database from one server and > restores it to another server??? I am NEW to Postgresql so I am starting > from scratch... $ pg_dump -h server1 database | psql -h server2 jan -- -------------------------------------------------------------- Jan de Visser jdevisser@xxxxxxxxxxxxxxxxxx Baruk Khazad! Khazad ai-menu! -------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend