There's a similar phrase originating from the North of England - 'raining stair-rods'. No one has gone to the effort of speculating that this is from mythic reports of stairs being carried into the air in storms and falling on gullible peasants. It's just a rather expressive phrase giving a graphic impression of heavy rain - as is 'raining cats and dogs'.