Обсуждение: Seed database for import
Hi
I am about to create my first postgres database with the aim of establishing some backup and recovery routines.
While I am OK with creating the basic database my question is:
Is there available any a postgres dump file that I can import into my database in order to populate it and so make my backup and recovery test more meaningful.
Mant thanks
Austen
Austen Birchall Senior Database Administrator
Met Office FitzRoy Road Exeter EX1 3PB United Kingdom
Tel: +44 (0)1392 884481 Fax: +44 (0)1392 885681
E-mail: austen.birchall@metoffice.gov.uk Website: http://www.metoffice.gov.uk
Hi
I am about to create my first postgres database with the aim of establishing some backup and recovery routines.
While I am OK with creating the basic database my question is:
Is there available any a postgres dump file that I can import into my database in order to populate it and so make my backup and recovery test more meaningful.
On Mon, May 9, 2011 at 2:31 AM, Birchall, Austen <austen.birchall@metoffice.gov.uk> wrote: > Is there available any a postgres dump file that I can import into my > database in order to populate it and so make my backup and recovery test > more meaningful. Its hard to guess what would be meaningful since we wont know how large your production data set will be. In fact, if your data is of sufficient size, you may need to a difference backup strategy. There are some data-sets available, but I expect that such samples are not of sufficient size to stress any backup/recovery tests that you might have. http://archives.postgresql.org/pgsql-general/2009-04/msg01106.php -- Regards, Richard Broersma Jr.