Since Peertube uses a Postgres database, we can log in and manually do bulk changes to videos. Things like updating a channel ID, Category, or Privacy can all be easily changed and it is easy to do bulk changes.<\/p>\n\n\n\n
Login as the peertube user via ssh<\/p>\n\n\n\n
ssh peertube@peertube-ip<\/pre>\n\n\n\nConnect to postgres<\/p>\n\n\n\n
psql peertube_prod<\/pre>\n\n\n\nView videos<\/p>\n\n\n\n
select * from video;<\/pre>\n\n\n\nThere is a bit much information, lets clean it up a bit<\/p>\n\n\n\n
select name,category,id,\"channelId\" from video;<\/pre>\n\n\n\nView all the channels. The id field is the channelId that is used in the above video table.<\/p>\n\n\n\n
select id,name from \"videoChannel\";<\/pre>\n\n\n\n<\/p>\n\n\n\n
Change video channel<\/strong><\/p>\n\n\n\n
update video set \"channelId\" = 100 where id = 123;<\/pre>\n\n\n\nReplace 100 with the actual channelId and 123 with the id of the video. Can use the above commands to find that info.<\/p>\n\n\n\n
Change Privacy Settings<\/strong><\/p>\n\n\n\n
The privacy settings are what determine if a video is Public, Private etc.<\/p>\n\n\n\n
The following command can update the privacy setting for a video<\/p>\n\n\n\n
update video set privacy = 3 where id = 101;<\/pre>\n\n\n\nThere are 4 privacy settings. Change 3 to one of the following.<\/p>\n\n\n\n
1 = Public
2 = Unlisted
3 = Private
4 = Internal<\/p>\n\n\n\nChange 101 to the video id you want to change.<\/p>\n\n\n\n
You can change the privacy settings for all videos in a channel with something like the following<\/p>\n\n\n\n
update video set privacy = 4 where \"channelId\" = 100;<\/pre>\n","protected":false},"excerpt":{"rendered":"Since Peertube uses a Postgres database, we can log in and manually do bulk changes to videos. Things like updating a channel ID, Category, or Privacy can all be easily changed and it is easy to do bulk changes. Access … Continue reading