Happy Friday! Those flags are just default. Not need to add them. Sometimes I write out the default flags to be more specific, but that’s just a quirky thing I *sometimes* do.
Anthony > On Aug 25, 2023, at 12:29 PM, Ben Hancock <bhanc...@alm.com.invalid> wrote: > > [You don't often get email from bhanc...@alm.com.invalid. Learn why this is > important at https://aka.ms/LearnAboutSenderIdentification ] > > Anthony Joyce wrote: > >> When we back up we use the admin or superuser username of your >> Postgres database. Perhaps that would help the permission issue that >> you are running into? It is worth a shot > > Thanks Anthony -- you're right, that did work. I thought my user had > sufficient permissions (USAGE) on the schema, but apparently not. FWIW, > I was able to execute this as the Airflow user as well. > > In your sample script, you have: > >> pg_dump —username={insert admin username here} --no-password --format=custom >> \ >> >> --section=pre-data --section=data --section=post-data \ >> >> --verbose —file={location here}.backup ${db_name} 2>${tempout} > > Can you explain the need to pass the various `--section` flags? I'm > probably missing something, but from my read of the man page it seems > like passing all of these sections together would be the same as the > default behavior without the flags. > > Many thanks again! > > Ben > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@airflow.apache.org > For additional commands, e-mail: users-h...@airflow.apache.org >
