This is not possible, you have to dump and restore everything.

Using the rights commands, this is not difficult. The only thing is that your database will be unavailable during the restore.