pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRESTORE multiple DBs concurrently
2+ messages / 2 participants
[nested] [flat]
* RESTORE multiple DBs concurrently
@ 2013-09-06 15:52 Roberto Grandi <roberto.grandi@trovaprezzi.it>
0 siblings, 1 reply; 2+ messages in thread
From: Roberto Grandi @ 2013-09-06 15:52 UTC (permalink / raw)
To: pgsql-performance
Dear All,
I'm dealing with restore 3 DB at the same time. Previously this task was sequential but we need to make shorter as possible our daily maintenance window.
Is this possible from your point of view to restore on the same server more than 1 DB at time? I havwn't found any clear answer on the web.
Many thanks in advance.
BR
Roberto
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: RESTORE multiple DBs concurrently
@ 2013-09-07 09:46 Michael Paquier <michael.paquier@gmail.com>
parent: Roberto Grandi <roberto.grandi@trovaprezzi.it>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Paquier @ 2013-09-07 09:46 UTC (permalink / raw)
To: Roberto Grandi <roberto.grandi@trovaprezzi.it>; +Cc: pgsql-performance
On Sat, Sep 7, 2013 at 12:52 AM, Roberto Grandi
<roberto.grandi@trovaprezzi.it> wrote:
> Is this possible from your point of view to restore on the same server more than 1 DB at time?
Yes, it is possible: simply run multiple instances of pg_restore in
parallel and just don't blow up your disk(s) I/O.
Also, why not restoring one database at the same time and accelerating
a single restore with parallel jobs? If your dump format is compatible
with this option, use -j when running pg_restore to define a number of
concurrent jobs. More info here:
http://www.postgresql.org/docs/9.2/interactive/app-pgrestore.html
This might be useful as well in your case.
--
Michael
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2013-09-07 09:46 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-09-06 15:52 RESTORE multiple DBs concurrently Roberto Grandi <roberto.grandi@trovaprezzi.it>
2013-09-07 09:46 ` Michael Paquier <michael.paquier@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox