想要改进这个问题吗? 更新了问题 ,因此堆积溢流的回答是
Closed 11 years ago.
有人能把未经编辑的 pg_hba.conf 文件的正本张贴在 ubuntu 上的 postgresql, 9.1。 我搞砸了, 找不到原件, 也无法重新安装 。 谢谢您。
事实上,你唯一能接收到这个文件的方法是 当别人在机器上运行 < 坚固> inittdb 坚固 > 并通过电子邮件或某种主机将文件发送给您时。
官方的`强势'/强势方式是(文件说):
客户端验证由配置文件控制, 传统上名为 pg_ hba. conf, 并存储在数据库群集数据目录中。 当数据目录由 initdb strong > 初始化时, 将安装一个 < 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?
$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 ...
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 ...
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 ...
Does anybody know if it is possible to move some (not all) users from one ASP.NET membership database to another? (for the purposes of migrating some users to another database on another machine, but ...
Is it because of size? By the way, what is the limit of the size?
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 ...
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 ...
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 ...