Date: Sat, 12 Jan 2008 20:48:45 +0100 From: Peter Schuller <peter.schuller@infidyne.com> To: freebsd-questions@freebsd.org, Albert.Shih@obspm.fr Subject: Re: How backup huge pgsql ? Message-ID: <200801122048.54367.peter.schuller@infidyne.com> In-Reply-To: <20080110221058.GA81742@pcjas.obspm.fr> References: <20080110221058.GA81742@pcjas.obspm.fr>
next in thread | previous in thread | raw e-mail | index | archive | help
[-- Attachment #1 --] > I want to known how can I make backup of huge postgresql database (huge > mean ~ 2To). > > I can stop the access of the database during N>>1 hours. > > Any idea about this ? pg_dump should work as usual. No need to stop database access since read-only access won't block anything else and it won't be blocked by other processes. That said, pg_dump:ing a database that is 2 terrabytes in size is going to take some significant time. If you want to maintain frequent backups you may want to look into using point in time recovery and WAL archiving. See: http://www.postgresql.org/docs/8.2/static/continuous-archiving.html Also the very long transaction used for the backup will prevent vacuuming from freeing tuples for the duration of the backup. If you have tables that rely on very frequent vacuuming for performance, those may be affected. -- / Peter Schuller PGP userID: 0xE9758B7D or 'Peter Schuller <peter.schuller@infidyne.com>' Key retrieval: Send an E-Mail to getpgpkey@scode.org E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org [-- Attachment #2 --] -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQBHiRmmDNor2+l1i30RApeRAJ9FVb4Fg+5+GvD+974fvF6v+vWGmwCgwGJh 1CfrDVkHjkhbTdqDiJboE60= =HXqH -----END PGP SIGNATURE-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200801122048.54367.peter.schuller>