su postgres

su - postgres is the command that the official fedora documentation suggests, but I too get a password prompt. To get round that I followed this postgres forum email that uses the same command as the accepted answer here: sudo -u postgres psql . anck su namun real