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 wrote: > Hi

Re: [GENERAL] Strange dump/restore effect

2012-09-23 Thread Tom Lane
=?UTF-8?Q?Gra=C5=BEvydas_Valeika?= 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)] Error while PROC

Re: [GENERAL] Strange dump/restore effect

2012-09-23 Thread Gražvydas Valeika
On Mon, Sep 24, 2012 at 12:44 AM, Paul Ramsey 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 it's done. > > I

[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)] Error