Re: [PERFORM] pg_dump and pg_restore

2010-05-23 Thread Jayadevan M
-performance@postgresql.org Date: 22/05/2010 16:59 Subject:Re: [PERFORM] pg_dump and pg_restore On Mon, May 17, 2010 at 1:04 AM, Jayadevan M wrote: > Hello all, > I was testing how much time a pg_dump backup would take to get restored. > Initially, I tried it with psql (on

Re: [PERFORM] pg_dump and pg_restore

2010-05-22 Thread Peter Koczan
On Mon, May 17, 2010 at 12:04 AM, Jayadevan M wrote: > Hello all, > I was testing how much time a pg_dump backup would take to get restored. > Initially, I tried it with psql (on a backup taken with pg_dumpall). It took > me about one hour. I felt that I should target for a recovery time of 15 > m

Re: [PERFORM] pg_dump and pg_restore

2010-05-22 Thread Robert Haas
On Mon, May 17, 2010 at 1:04 AM, Jayadevan M wrote: > Hello all, > I was testing how much time a pg_dump backup would take to get restored. > Initially, I tried it with psql (on a backup taken with pg_dumpall). It took > me about one hour. I felt that I should target for a recovery time of 15 > mi

[PERFORM] pg_dump and pg_restore

2010-05-16 Thread Jayadevan M
Hello all, I was testing how much time a pg_dump backup would take to get restored. Initially, I tried it with psql (on a backup taken with pg_dumpall). It took me about one hour. I felt that I should target for a recovery time of 15 minutes to half an hour. So I went through the blogs/documenta