Alvaro Herrera-9 wrote
I saw one installation with "gsutil cp" in archive_command recently. It
had the CLOUDSDK_PYTHON environment variable set in the archive_command
itself. Maybe that's a problem.
After all, this was the solution:
archive_command = 'CLOUDSDK_PYTHON=/usr/bin/python gsutil cp /storage/postgresql/9.6/main/pg_xlog/%p gs://my_bucket/'
as also hinted in
https://github.com/GoogleCloudPlatform/gsutil/issues/402
I still don't understand why the environments differ (the context of archive_command vs. "su postgres -" and executing it there) but I am happy it's working now.
Thank you!
