| From: | Ron Jr <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: backup another server |
| Date: | 2003-10-29 18:30:28 |
| Message-ID: | 1067452228.3359.13.camel@haggis |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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. ron(dot)l(dot)johnson(at)cox(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2003-10-29 18:31:51 | Re: [GENERAL] pgAdmin vs SQL Server Enterprise Manager |
| Previous Message | Patrick Hatcher | 2003-10-29 17:56:55 | dump schema schema only? |