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 <[email protected]> wrote: > > [You don't often get email from [email protected]. 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: [email protected] > For additional commands, e-mail: [email protected] >
