Re: [GENERAL] Strange dump/restore effect

2012-09-24 Thread Paul Ramsey
Try just loading the 1.5 dump directly into the 2.0 database without the filtering step. It will be immensely noisy with lots of errors and warnings, but with luck you should find your data is there waiting for you when it's done. P On Sun, Sep 23, 2012 at 2:37 PM, Gražvydas Valeika

[GENERAL] Strange dump/restore effect

2012-09-23 Thread Gražvydas Valeika
Hi all, I just migrated to 9.2 and observing stange thing. While restoring 9.2 database to another server's empty database I'm getting several errors while restoring views: pg_restore: creating RULE _RETURN pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)]

Re: [GENERAL] Strange dump/restore effect

2012-09-23 Thread Gražvydas Valeika
On Mon, Sep 24, 2012 at 12:44 AM, Paul Ramsey pram...@opengeo.org wrote: Try just loading the 1.5 dump directly into the 2.0 database without the filtering step. It will be immensely noisy with lots of errors and warnings, but with luck you should find your data is there waiting for you when

Re: [GENERAL] Strange dump/restore effect

2012-09-23 Thread Tom Lane
=?UTF-8?Q?Gra=C5=BEvydas_Valeika?= gvale...@gmail.com writes: I just migrated to 9.2 and observing stange thing. While restoring 9.2 database to another server's empty database I'm getting several errors while restoring views: pg_restore: creating RULE _RETURN pg_restore: [archiver (db)]