Alvaro Herrera-9 wrote > I saw one installation with "gsutil cp" in archive_command recently. > Ithad the CLOUDSDK_PYTHON environment variable set in the > archive_commanditself. 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 <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! -- View this message in context: http://www.postgresql-archive.org/archive-command-fails-but-works-outside-of-Postgres-tp5979040p5979093.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
