Power has to reset with each restart

contact a local acura dealership as they should be able to confirm if you have the right code for your vehicle

bleed the air out of the cooling system. You cannot get all the air out have a radiator shop use a pressure bleeder for the job.

Apparently, you have no power at the 12 volt battery/memory wire at the radio harness of the vehicle. This wire is white with blue in color.
Also, based upon your description, you have connected the battery/memory wire and the accessory wire of the radio to the 12 volt accessory (switched) wire of the vehicle. This wire is white with red in color.
Check the radio/ stereo fuse of the car. You may have blown the fuse during your installation.
You have no memory at the radio because when you turn off the key, you lose all power to the radio.
Also, I mentioned the wire colors just in case you used an aftermarket radio wiring harness. Make sure that the yellow from the Pioneer unit is going to the battery power source and, the red of the Pioneer is going to the switched power source.

There's a "P" before the 6000UB right? This is the only installation manual i could find, i'm pretty sure it's the one u need. Now for the wires that connect to the car, you need to go down to either wal mart or any audio installation shop and get the installation kit for your 2002 Acura TL. It has to be vehicle specific or else it won't work, but you need this in order for a smooth installation. All you have to do is match up the same color wires and connect. Good luck...just copy and paste the link below
http://www.pioneerelectronics.com/StaticFiles/PUSA/Files/DEH-P6000UB_InstallationManual1205.pdf

There is a connector but it is not like the connector used in the newer 1996 OBD2 cars, your year uses OBD1, here is how you check for codes in this car.

Acura OBD1 Codes Retrieval
Acura vehicles 1986-95 obd1 code retrieval
There are a few different ways to retrieve the codes for "check engine light" for Acura vehicles. One method is to use a led light (sometimes 2 led lights) on the computer or controller box itself. If it has 2 led lights, the color is red and amber. The red is used for flashing the codes whereas the amber is used for adjustment. If you have only a single led light indicator, then that is used for flashing the code.
The controller box can be found by lifting the carpet of the passenger side front foot well or floorboard. You can see the led lights without removing the controller. On other models, you can find the controller under the driver or passenger front seat.
The second way to get the code is using a jumper wire on the diagnostic connector located on the kick panel at the front passenger side. You then watch the codes being flashed at the dash panel after you turn the key on. To read the code being flashed is easy. Example: Code 23 is 2 long flashes followed by 3 short flashes. A longer pause separates the next code that follows.
Here are Acura vehicles 1986-95 general codes:
Code 0 Electronic control unit (ecu)
Code 1 02 (oxygen) sensor
Code 3 and 5 map sensor
Code 4 Crank angle sensor
Code 6 Coolant temperature sensor
Code 7 Throttle angle sensor
Code 8 Crank angle sensor (TDC)
Code 9 Crank angle sensor (CLY)
Code 10 Intake air temperature sensor
Code 12 EGR system fault
Code 13 Atmospheric pressure sensor
Code 14 Electronic air control valve
Code 15 Ignition output signal
Code 16 Fuel injector fault
Code 17 Vehicle speed sensor
Code 21 Spool solenoid valve
Code 22 Valve timing oil pressure switch fault
Code 23 Knock sensor
Code 41 Oxygen sensor heater fault
Code 43 Fuel supply system

uhh smell ur amp if it smells like something burnt you might wonna new amp for ur system i had that prob. to with a kicker amp 2400 watts and it was the amp was horrid

THERE IS NO FUEL PUMP RESET BUTTON ON YOUR VEHICLE.PULLING YOUR BATTERY CABLE WILL DO NOTHING BUT MAKE YOU HAVE TO RE -INSTALL YOUR ANTI-THEFT RADIO CODE,TO AHVE A RADIO AGAIN.AND RESET YOUR CLOCKS. CPUBUGS IS TAKING A GUESS WITHOUT KNOWING ANYTHING ABOUT AN ACURA. IF YOU ARE HAVING FUEL ISSUES THE CAR HAS A PGMFI MAIN RELAY UP UNDER DRIVERS DASH AREA(BASICALLY WHAT WOULD BE AN OLD SCHOOL FUEL CUT RELAY)THAT TEND TO GO BAD ON THESE CARS.IT WILL BE A 2"X2"X3" GREY/BLACK SINGLE CONNECTOR BOX DIRECTLY UP UNDER DRIVERS DASH AREA.MOUNTED ON A METAL ONE BOLT BRACKET.THIS IS WHERE I WOULD START IF NO FUEL SITUATION. GOOD LUCK ,JOEL

Have you checked your codes to see what the car is asking for?Most times a vehicle computer will do a fuel tank vacuum/pressure check when decelerating.

Check your cooling fan or the temperature relay.  The reason it doesn't overheat on the freeway is because there is sufficient airflow to cool the motor down without the need for the fan.

Did you use a harness to connect the wires?
Could be the power line (red) is connect to the ACC (Accessory) orange line, so every time you switch off the vehicle the power to the stereo is interrupted.