Re: [HACKERS] [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-19 Thread Alvaro Herrera
Jesse Denardo escribió: > Alvaro, > > I applied the patch and tried upgrading again, and everything seemed to > work as expected. We are now up and running the beta! Pushed, thanks. -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Se

Re: [HACKERS] [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Jesse Denardo
Alvaro, I applied the patch and tried upgrading again, and everything seemed to work as expected. We are now up and running the beta! -- Jesse Denardo On Fri, Aug 2, 2013 at 10:25 PM, Alvaro Herrera wrote: > Andres Freund escribió: > > On 2013-08-02 18:17:43 -0400, Alvaro Herrera wrote: > > >

Re: [HACKERS] [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Andres Freund
On 2013-08-02 22:25:36 -0400, Alvaro Herrera wrote: > Andres Freund escribió: > > On 2013-08-02 18:17:43 -0400, Alvaro Herrera wrote: > > > Alvaro Herrera escribió: > > > > > > > As it turns out, I have a patched slru.c that adds a new function to > > > > verify whether a page exists on disk. I c

Re: [HACKERS] [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Bruce Momjian
On Fri, Aug 2, 2013 at 11:20:37PM -0400, Jesse Denardo wrote: > Alvaro, > > I applied the patch and tried upgrading again, and everything seemed to work > as > expected. We are now up and running the beta! Yeah, great, thanks everyone! -- Bruce Momjian http://momjian.us Enterpris

Re: [HACKERS] [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Alvaro Herrera
Andres Freund escribió: > On 2013-08-02 18:17:43 -0400, Alvaro Herrera wrote: > > Alvaro Herrera escribió: > > > > > As it turns out, I have a patched slru.c that adds a new function to > > > verify whether a page exists on disk. I created this for the commit > > > timestamp module, for the BDR b

Re: [HACKERS] [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Andres Freund
On 2013-08-02 18:17:43 -0400, Alvaro Herrera wrote: > Alvaro Herrera escribió: > > > As it turns out, I have a patched slru.c that adds a new function to > > verify whether a page exists on disk. I created this for the commit > > timestamp module, for the BDR branch, but I think it's what we need

Re: [HACKERS] [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Alvaro Herrera
Alvaro Herrera escribió: > As it turns out, I have a patched slru.c that adds a new function to > verify whether a page exists on disk. I created this for the commit > timestamp module, for the BDR branch, but I think it's what we need > here. Here's a patch that should fix the problem. Jesse,

Re: [HACKERS] [BUGS] 9.3beta2: Failure to pg_upgrade

2013-07-31 Thread Alvaro Herrera
Jesse Denardo escribió: > $ 9.2_dev/bin/pg_controldata data > Latest checkpoint's NextMultiXactId: 2982 > Latest checkpoint's NextMultiOffset: 6479 So what's happening here is that the MultiXact 2982 lives in a SLRU page that doesn't exist. pg_upgrade didn't copy the pg_multixact files from t