大网数据广告活动
服务器运维问答

Change postgres password using remote ssh

· 52CE 我爱测

I'm running a postgres database on a Google Cloud instance that we drop and recreate daily as part of our nightly build. Currently this is being done manually and I want to automate it. gcloud compute ssh --zone europe-west2-c po…

问题原文

原帖链接 · Jan Vladimir Mostert · CC BY-SA 3.0

I'm running a postgres database on a Google Cloud instance that we drop and recreate daily as part of our nightly build. Currently this is being done manually and I want to automate it.

gcloud compute ssh --zone europe-west2-c postgres@postgresql-dev -- "dropdb mydb"
gcloud compute ssh --zone europe-west2-c postgres@postgresql-dev -- "createdb mydb"
gcloud compute ssh --zone europe-west2-c postgres@postgresql-dev -- "psql postgres -c 'GRANT ALL PRIVILEGES ON DATABASE mydb to myuser;' "

This works fine to drop and recreate the database, the problem comes in when I have to re-setup the password ...

gcloud compute ssh --zone europe-west2-c postgres@postgresql-dev -- "psql postgres -c 'ALTER USER myuser WITH PASSWORD 'passwordhere' ; "

gcloud command is already using the double quotes, psql postgres -c is already using the single quotes, what quotes should I be using to put the password in quotes?

I've tried escaping the quotes, but it doesn't work:

WITH PASSWORD \'passwordhere\' 

ERROR: syntax error at or near "\" LINE 1: ALTER USER myuser WITH PASSWORD \passwordhere'

or

WITH PASSWORD \"passwordhere\" 

bash: -c: line 0: unexpected EOF while looking for matching `'' bash: -c: line 1: syntax error: unexpected end of file

How do I escape those quotes?

已采纳解答

原帖链接 · Jan Vladimir Mostert · CC BY-SA 3.0

this seems to work:

gcloud compute ssh --zone europe-west2-c postgres@postgresql-dev -- "psql postgres -c 'ALTER USER myuser WITH PASSWORD '\''passwordhere'\'' '; "

-

WITH PASSWORD '\''passwordhere'\'' 

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2018-03-11)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。