[ADMIN] pg_restore does not restore all tables

2009-12-01 Thread Baubak Gandomi
Hello, I have a problem restoring a database. I have made a dump of a schema, with no error messages. When I restore my dump I do not get any error messages either. But when I look into my schema I see that I have less tables than before. I don't even know how to debug this problem ! Best r

Re: [ADMIN] pg_restore does not restore all tables

2009-12-01 Thread Ian Lea
You could start by saying what version of postgres, on what OS, and posting your backup and restore commands with any output, error or otherwise, that they produce. -- Ian. On Tue, Dec 1, 2009 at 4:48 PM, Baubak Gandomi wrote: > Hello, > > > > I have a problem restoring a database. I have mad

[ADMIN] Restore SQL_ASCII backup...

2009-12-01 Thread Brian Myers
Hi all, I'm trying to restore an old backup (7.1.4) into a new PG database (8.4). There are errors with some of the RI and sequences, but those are easy to fix. The problem is that one table in the DB has TEXT fields in it and these seem to be sensitive to the DB encoding. The default in the da

[ADMIN] Postgres Dump out of order

2009-12-01 Thread Helio Campos Mello de Andrade
Hi guys, - I'm having a problem when i want to make a backup of my system. - Postgres generated dump was created out of "foreing key" order and when i try to recreate my database structures, data and functions. Does someone have this same issue? Someone knows of some app that do the job? Regard