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
