>> but #1 was focused on backing up MyDatabase that resides on
>> /hda1/pgdata, and restore it as MyDatabase2 on /hda2/pgdata.
>Do you already have the backup you want to restore? If so, how was
>it made, exactly?
Yes.
I used pg_dump to make the backup.