Thread: 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

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.