Re: [BUGS] BUG #8465: major dump/reload problem

2013-09-23 Thread Ján Máté
Hi Keikki, it is clear what causes this problem, but pg_upgradecluster is an operation which simply MUST work (if you have several hundred of user databases, it is not an option to check all of them for this kind of error before the cluster upgrade). Database upgrade is performed by the server

Re: [BUGS] BUG #8465: major dump/reload problem

2013-09-23 Thread Heikki Linnakangas
On 21.09.2013 20:16, jan.m...@inf-it.com wrote: today I tried to upgrade from 9.2 to 9.3 (pg_upgradecluster 9.2 main) and the upgrade of one of my databases failed with the following error: "ERROR: new row for relation ... violates check constraint ...". I created an example to reproduce this bu

[BUGS] BUG #8465: major dump/reload problem

2013-09-22 Thread jan . mate
The following bug has been logged on the website: Bug reference: 8465 Logged by: Jan Mate Email address: jan.m...@inf-it.com PostgreSQL version: 9.3.0 Operating system: all Description: Hi PostgreSQL team, today I tried to upgrade from 9.2 to 9.3 (pg_upgradecluste