Can your sim die after being resurrected?

Even in sims 4 on ps4? With all the potions and plants they want you to use?

Your Sim can die again, even if they've taken the Potion of Immortality (which prevents death from Old Age). But a lot depends on how you play and how they died. 

For instance, I play with Aging On, so I've resurrected Elder sims with the death flower, after they die of old age. They will usually die from old age again about 24 hours later. If you're playing with Aging On, and resurrecting by giving Grim a death flower, they will keep dying of old age. The time they have left after resurrection starts to get smaller and smaller. I've resurrected an elder in this way for several days just to try to get an aspiration finished and let me tell you - it becomes a pain! It starts out that they get about 24 hours, then the time between deaths gets shorter and shorter until it's happening every few hours. 

But, if your sim dies from something else - say, an emotional death - and they're not dying of old age, then it's totally worth it to resurrect them. They won't keep dying of the same thing, but they still run the risk of dying by the same means or another means sometime in their lifetime. I had a Young Adult sim who died of hysteria (Death by Laughter). I gave Grim a death flower while he was trying to take the sim, and the sim resurrected and lived the rest of his life, eventually dying of old age. But he did eventually die.

If you're talking about bringing back a ghost who has already died (by having them drink Ambrosia or read the Book of Life) - then the same rules apply. They'll stop being a ghost, and reset to the beginning of their life stage. But they'll still be able to die from any of the death types, and if aging is on, they'll eventually die of old age.

You can find some more detailed info in Carl's guide on Death, Dying and Resurrection.