On Wed, 2003-10-29 at 11:46, 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??/
oldserver:~ pg_dumpall foo.dmp && scp foo.dmp newserver:.
oldserver:~ ssh newserver
news
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
-
