Re: Creating new database - SOLVED

Malcolm Warren <malcolm@xxxxxxxxxxxxxxxxx> · Wed, 18 Nov 2009 18:05:35 +0100

Dear All,

Thank you for your emails which were very helpful.

I've finally solved it.

template1 was full of data, presumably somehow from a badly-run dump
and restore.

So when I created the new database, that too was full of data from the
template.

I ran a clean pg_dump on template1 from my production database and
restored it on my test machine, and finally everything is normal.

Thanks again,

Malcolm

Joao Ferreira gmail ha scritto:

  On Wed, 2009-11-18 at 08:39 -0700, Scott Marlowe wrote:

    On Wed, Nov 18, 2009 at 8:12 AM, Joao Ferreira gmail
<joao.miguel.c.ferreira@xxxxxxxxx> wrote:

      I'dd suggest:

pgdumpall --clean > dump.sql

    I'd think he'd be much better off with pg_dump, not pg_dumpall.

yes, agree. sorry.

joao

    pg_dump srcdb | psql destdb

you can add -s as a pg_dump switch if all you want is the schema.