[HACKERS] pg_restore exclude schema from being droped option

2007-01-26 Thread Kostis Mentzelos
Hi list, I am using pg_dump and pg_restore to backup and restore a database but there is something that I believe is missing from the restore process: an option in pg_restore to exclude a schema from being dropped when -c option is defined. And here is why: Suppose that I have a database

Re: [HACKERS] pg_restore exclude schema from being droped option

2007-01-26 Thread Tom Lane
Kostis Mentzelos [EMAIL PROTECTED] writes: Now, to backup the database I choose to create 2 scripts, BackupData.sh to backup all small tables and BackupHist.sh to backup history tables. When I call pg_restore -c to restore data tables, pg_restore report a failure because it is trying to