Restarting after a shut down w/o pulling the power cord?

[bomblord]

Feels and sounds like a 'newb' question to me but I legitimately have not found an answer. Is there no way to turn the pi back on after a clean shutdown w/o removing the power cable and plugging it back in I shut my pi down after I'm done with it and am worried about wear on the power connector re-connecting it every time. I also don't want to leave it idling either as that's just wasting power. Is additional hardware a requirement here?

[MikeCross]

Pull the mains plug out of the wall socket, or, if possible, switch off the mains socket.

I don't know which of these is a better solution than pulling out the mains cable from the Pi.

[knute]

Momentarily ground GPIO pin BCM 3.

[bomblord]

Momentarily ground GPIO pin BCM 3.

My Pi's in a flirc case though need to undo 4 screws to get inside

[LTolledo]

My solution is to plug the PSU to an extension cord with individually switched sockets.
something similar to but not exactly like:

SwitchedExtensionCords.jpg (21.67 KiB) Viewed 334 times

or this:

switched sockets.jpg (14.2 KiB) Viewed 334 times

[HawaiianPi]

...and am worried about wear on the power connector re-connecting it every time.

The USB connector is designed for thousands of plug-unplug cycles, so it's highly unlikely you will ever wear one out.

I also don't want to leave it idling either as that's just wasting power.

In that case you need to turn off power from the AC/mains to the PSU power brick (disconnecting power from the Pi itself will not stop the PSU from consuming a tiny amount of power if the power brick is still plugged in). Either unplug that, or use a switch (I use outlet "tap" switches similar to the ones LTolledo posted).