Skip site navigation (1) Skip section navigation (2)

Re: pg_dump is stuck

From: Joseph S <jks(at)selectacast(dot)net>
To: Nik <XLPizza(at)gmail(dot)com>
Subject: Re: pg_dump is stuck
Date: 2007-03-29 19:41:59
Message-ID: 460C1687.2090907@selectacast.net (view raw or flat)
Thread:
Lists: pgsql-general
Nik wrote:

> The reason I am running pg_dumpall is that I would like to create an
> exact copy of my database on another server. I cannot use create
> database with template command since there are connections to the
> original database. The dumpall method seems somewhat cumbersome since
> it generates only one file that is huge.
> 
> Is there another way I could do this that would be faster, more
> reliable, and elegant? Could I start archiving the logs for the
> original database and then do the pitr on another machine using that
> backup and logs?
> 

On the second machine

pg_dumpall -h first_machine | psql

Of course that is assuming the second machine is a unix clone.  I don't 
know if windows pipe works like unix or if it still works like the old 
dos pipe.

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2007-03-29 19:42:03
Subject: Re: Postgres Crash Running PLPGSQL Function on 8.2.3
Previous:From: Bruce MomjianDate: 2007-03-29 19:41:20
Subject: Re: COPY command details

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group