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
newserver:~ pg_restore foo.dmp
--
-----------------------------------------------------------------
Ron Johnson, Jr. [EMAIL PROTECTED]
Jefferson, LA USA
LUKE: Is Perl better than Python?
YODA: No... no... no. Quicker, easier, more seductive.
LUKE: But how will I know why Python is better than Perl?
YODA: You will know. When your code you try to read six months
from now.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
