Mark Lubratt <[EMAIL PROTECTED]> writes: > I'd like to create a user for my pg_dump backup process. I'd like that > user to have only the privileges required to run pg_dump.
You're wasting your time. pg_dump should generally be run by the database superuser. Anything less creates problems with being unable to dump stuff that doesn't belong to it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend