참고 https://supabase.com/docs/guides/platform/migrating-and-upgrading-projects#migrate-storage-objects
// storage_restore.js const { createClient } = require("@supabase/supabase-js"); const fs = require("fs"); const PROJECT_URL = "http://localhost:8100"; const PROJECT_SERVICE_KEY = "service_role_key"; (async () => { console.log("started at: ", new Date().toISOString()); const supabaseRestClient = createClient(PROJECT_URL, PROJECT_SERVICE_KEY, { db: { schema: "storage" }, }); const supabaseClient = createClient(PROJECT_URL, PROJECT_SERVICE_KEY); // make sure you update max_rows in postgrest settings if you have a lot of objects or paginate here const { data: objects, error } = await supabaseRestClient .from("objects") .select(); // .eq("bucket_id", "manuals"); if (error) { console.log("error getting objects from old bucket"); throw error; } for (const objectData of objects) { console.log(`moving ${objectData.id}`); try { const data = fs.readFileSync( `./storage/stub/stub/${objectData.bucket_id}/${objectData.name}/${objectData.version}` ); const { _, error: uploadObjectError } = await supabaseClient.storage .from(objectData.bucket_id) .upload(objectData.name, data, { upsert: true, contentType: objectData.metadata.mimetype, cacheControl: objectData.metadata.cacheControl, }); if (uploadObjectError) { throw uploadObjectError; } } catch (err) { console.log("error moving ", objectData); console.log(err); } } console.log("finished at: ", new Date().toISOString()); })(); 이 파일을 supabase studio 컨테이너로 이동시킨다.
docker cp storage_restore.js container_id:/app/ 기존 폴더에서 supabase studio 컨테이너로 파일을 이동시킨다.
docker cp storage container_id:/app/ 컨테이너 안으로 진입해서 스크립트를 실행한다
docker exec -it container_id bash cd app node store_restore.js 
Top comments (0)