Use this website to calculate pressures and pipe sizing. It uses Barlow's formula's which are principally directed at fluid dynamics, but works fine when calculating ballistic equivalents especially with black powder.
htt p://www.engineersedge.com/calculators/pipe_bust_calc.htm
There are a number of other references on the net which will help you through bore, projectile / weight calculations to determine maximum pressures + your added safety factor. I helped a friend build a BP mountain howitzer last year using high pressure pipe and a welded and pinned breech plug. It was the perfect diameter for a tomato-paste can full of concrete.
Here is my golf-ball cannon I built many years ago using similar construction;
![]()
![]()
That thing is so many levels of win that I have no idea where to start patting you on the back.