Posts that require approval are approved when a Mod or Editor approves them, or rejects them should they see the need. It will be approved/rejected when a Mod/Editor comes on, and I realize it can seem like a long time and gets annoying, patience is key.
All you need is one upvote on Pokebase and your posts will no longer need to be approved. Except for answering really old posts which requires 200. Answering old posts is usually discouraged.