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

Using pg_dump when connecting via a service

· 52CE 我爱测

I connect to my postgres server using psql "service=subscription" . How do I use the service with pg_dump ? I tried to do the following: pg_dump -h "service=subscription" > /home/fogest/dump.out This however did not work. How sho…

问题原文

原帖链接 · ComputerLocus · CC BY-SA 3.0

I connect to my postgres server using psql "service=subscription". How do I use the service with pg_dump?

I tried to do the following: pg_dump -h "service=subscription" > /home/fogest/dump.out

This however did not work.

How should I be doing this?

Edit: The error when I do the following:

pg_dump -h "service=subscription" odyssey_prod > /u3/jhvisser/dump.out
pg_dump: [archiver (db)] connection to database "odyssey_prod" failed: could not translate host name "service=subscription" to address: Name or service not known

已采纳解答

原帖链接 · Craig Ringer · CC BY-SA 4.0

You can't use -h to specify a connection-string. It can only be an actual hostname or IP.

To connect to a service (or use any other connection string) just pass it as a non-switch argument:

pg_dump "service=subscription"

or (I know this is counter-intuitive) pass it as the database name:

pg_dump -d "service=subscription"

This works with any libpq client (psql, pg_restore, etc).

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

资料来源与适用范围

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

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

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