我刚刚在我的Mac(lion)上安装了电梯,当时我使用<条码>psql 姿态gres(或任何其他数据库),自动对我进行标识。
不管怎样,即便是用<密码<<>/代码>在psql上改动过错。 听起来,这只是让我不给我一个密码。
该网站还显示我的用户名称(与我的mac oslogin号相同的用户名称)为所有人。
是否有办法确保更多的东西?
Postgresql is most likely configured to trust anyone. This is configured int the file pg_hba.conf which is located in the data directory of postgresql. I do not know where homebrew places the data dir. However if you issue the following command in a terminal:
ps aux | grep postmaster
您将做出如下回应:
postgres 63 0,0 0,1 2472288 4888 ?? Ss 12:19pm 0:00.85 /Library/PostgreSQL/9.0/bin/postmaster -D/Library/PostgreSQL/9.0/data
之后的部分是数据目录的位置。 你们也许必须重新定位,使之适合。
开放Pg_hba。
sudo vi <datadir>/pg_hba.conf
档案载有(关于我所看到的所有设施)描述环境的公平评论范围。 实际环境是档案的底线。 我怀疑其中一条或多条线是信任的。 将这些改动改为5级,以核实密码。
我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。
On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...
I ll take the simplest of the SQL functions as an example: CREATE OR REPLACE FUNCTION skater_name_match(INTEGER,VARCHAR) RETURNS BOOL AS $$ SELECT $1 IN (SELECT skaters_skater.competitor_ptr_id ...
I m 在当地网络上运行几台机器,在Salgresql8.3处撰写一份申请。
I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.
Hey, I have 2 tables in PostgreSql: 1 - documents: id, title 2 - updates: id, document_id, date and some data: documents: | 1 | Test Title | updates: | 1 | 1 | 2006-01-01 | | 2 | 1 | 2007-01-01 |...
I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...
I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...