On Wed, 29 Oct 2003, Edwin Quijada wrote: > > > > Hi!! > I wanna take a whole database running in a box1 pg7.3.4 and moving to > another box2 with 7.3.4 too. > There is a fast way to do that?? > Which??/
The way I do it is: pg_dumpall -h source_machine |psql -h dest_machine ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster