By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

backup another server

P: n/a

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??/

*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*-------------------------------------------------------*

__________________________________________________ _______________
Fretting that your Hotmail account may expire because you forgot to sign in
enough? Get Hotmail Extra Storage today!
http://join.msn.com/?PAGE=features/es
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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. ro***********@cox.net
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.