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]
