[GENERAL] pg_dump and pg_restore problem

2009-05-01 Thread Michele Petrazzo - Unipex
Hi all, I had a big problem that made me crazy... I want to simple backup some tables from a my db and restore them to another. My db: table_two( id serial PRIMARY KEY, ... ) table_one ( id serial PRIMARY KEY, real_name text NOT NULL, username text NOT NULL, id_table_two i

Re: [GENERAL] pg_dump and pg_restore problem

2009-04-30 Thread Alan Hodgson
On Wednesday 29 April 2009, "Michele Petrazzo - Unipex" wrote: > The unique solution that I found it's that to export with pg_dump all my > tables except the table_three and, after, exporting only that and on the > other host and import that alone... > > It's this a normal behavior, a "missing fe

[GENERAL] pg_dump and pg_restore problem

2009-04-29 Thread Michele Petrazzo - Unipex
Hi all, I had a big problem that made me crazy... I want to simple backup some tables from a my db and restore them to another. My db: table_two( id serial PRIMARY KEY, ... ) table_one ( id serial PRIMARY KEY, real_name text NOT NULL, username text NOT NULL, id_table_two i