I'm trying to create an adhoc backup feature inside an application using PHP.
I could perform a pg_dump using the shell, but is there SQL statements that could do the same thing without having to use PHP to go to shell and then having to change users to root, postgres, etc. just to make a dump? I'm hoping to minimize security risks.