[GENERAL] pg_dump/pg_restore schema and data separately and foreign key constraints

2009-05-12 Thread Vasiliy Vasin
I have database on production server that backups every day. Database is not big ~ 10mb. But I added several tables that takes big capacity and I don't want to backup data from them. So, I backup my database in two files: schema and data: pg_dump -s -E utf-8 -f ${filename.schema} -F custom -n pu

Re: [GENERAL] pg_dump/pg_restore schema and data separately and foreign key constraints

2009-05-12 Thread Vasiliy Vasin
In the end, decided to make easier: make a complete dump except tables that I don't want to backup, then just dump schema of these tables. So I have 2 files: schema+data for all except table1 and table2, schema only for table1 and table2. It's a strangely that pg_restore is still no option to che