That means no PlayStation Store for PS3, PSP or PS Vita. PSN account registration and management will be inaccessible too. Online play possible if you sign in before switch off.
In-game trophies will still be collectible during so you won't miss out. The listed services above won't be available if you sign in before maintenance.