Can you create an issue for this? http://support.herouk.com
-- Richard Schneeman http://heroku.com @schneems Sent from the road On Monday, June 4, 2012 at 5:30 PM, Kallin Nagelberg wrote: > Hey everyone, > > I have two apps on Heroku, both with Ronin databases. One is production and > works, the 2nd is staging which I'm trying to get going by pulling in a > production backup. > I have successfully created the backup on production and gotten it's public > URL, and then used that URL to restore into the staging app's database. The > command says it executes fine, but the logs say otherwise. The command is > like: > > heroku pgbackups:restore DATABASE "some URL" --app my-app-1234 > > and in the logs I see msgs like: > > 2012-06-04T22:09:42+00:00 app[postgres]: [5-1] ud3otvib1qnvbo [MAROON] LOG: > duration: 493.029 ms statement: ALTER TABLE ONLY public.referral DROP > CONSTRAINT fkd4ee7b9d375d7727; > 2012-06-04T22:09:42+00:00 app[postgres]: [5-2] #011 > 2012-06-04T22:09:42+00:00 app[postgres]: [6-1] ud3otvib1qnvbo [MAROON] ERROR: > must be owner of schema public > 2012-06-04T22:09:42+00:00 app[postgres]: [6-2] ud3otvib1qnvbo [MAROON] > STATEMENT: DROP SCHEMA public; > 2012-06-04T22:09:42+00:00 app[postgres]: [6-3] #011 > 2012-06-04T22:09:42+00:00 app[postgres]: [7-1] ud3otvib1qnvbo [MAROON] ERROR: > schema "public" already exists > 2012-06-04T22:09:42+00:00 app[postgres]: [7-2] ud3otvib1qnvbo [MAROON] > STATEMENT: CREATE SCHEMA public; > 2012-06-04T22:09:42+00:00 app[postgres]: [7-3] #011 > 2012-06-04T22:09:42+00:00 app[postgres]: [7-4] #011 > 2012-06-04T22:09:42+00:00 app[postgres]: [7-5] #011 > 2012-06-04T22:09:42+00:00 app[postgres]: [8-1] ud3otvib1qnvbo [MAROON] ERROR: > must be owner of schema public > 2012-06-04T22:09:42+00:00 app[postgres]: [8-2] ud3otvib1qnvbo [MAROON] > STATEMENT: COMMENT ON SCHEMA public IS 'standard public schema'; > > > > So the restore isn't working. I've been digging but can't figure out what I > might be doing wrong. Any ideas? > > -- > You received this message because you are subscribed to the Google > Groups "Heroku" group. > > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en_US?hl=en -- You received this message because you are subscribed to the Google Groups "Heroku" group. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/heroku?hl=en_US?hl=en
