English 中文(简体)
pg_hba. conf 文件 [已关闭]
原标题:pg_hba.conf file [closed]
Closed. This question is off-topic. It is not currently accepting answers.

想要改进这个问题吗? 更新了问题 ,因此堆积溢流的回答是

Closed 11 years ago.

有人能把未经编辑的 pg_hba.conf 文件的正本张贴在 ubuntu 上的 postgresql, 9.1。 我搞砸了, 找不到原件, 也无法重新安装 。 谢谢您。

最佳回答

事实上,你唯一能接收到这个文件的方法是 当别人在机器上运行 < 坚固> inittdb 并通过电子邮件或某种主机将文件发送给您时。

官方的`强势'/强势方式是(文件说):

客户端验证由配置文件控制, 传统上名为 pg_ hba. conf, 并存储在数据库群集数据目录中。 当数据目录由 initdb 初始化时, 将安装一个 < strong> default pg_ hba. conf 文件。 但是, 可以将认证配置文件放在别处; 见 hba_ file 配置参数 。

UPDATE: Is this pg_hba.conf (pastebin.com) what you was looking for? It s the file I received right now when installed a PostgreSQL 9.1 on Debian 6.

问题回答

我手头没有Ubuntu(Ubuntu),但在多数情况下,有三个规则(其余的只是评论 ) 。 在大多数分布上,方法被设定为确定。

# TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     ident
# IPv4 local connections:
host    all             all             127.0.0.1/32            ident
# IPv6 local connections:
host    all             all             ::1/128                 ident

您不能再次运行 Initdb 来创建一个新的数据库群集吗? 新的数据库群集将拥有一个新的 pg_ hba. conf?





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签