从新人角度看PostgreSQL [英] PostgreSQL from a newcomers perspective
问题描述
PostgreSQL的新功能..不是数据库..或者一般的Linux ..
让我们相信你的倡导，并决定安装和
与PostgreSQL发挥作用，发现它的功能以及如何使用它们。
安装顺利。我决定阅读长版..在某些时候
我被告知创建一个用户postgres。
我没有找到这个用户的推荐设置，如果它需要一个shell
和用户homedir应该在哪里..我的意思是......我可以理解
PostgreSQL需要与MySQL类似的东西..如果它确实..
然后我希望它在docs-> installation->长版本中。
这里我发现自己落后于Linux无法通过PHP连接的盒子..解决了
那个也是..在PHP.net上找到更快的解决方案然后在
postgresql.org ..甚至搜索对于postgresql.org上的postmaster -i（以及其他关键字我可以想到）..没有结果.. FWIW ..搜索
关键字postmaster确实出现了app_postmaster页面..
长话短说，为了让事情变得新手需要搜索一下
很多（最喜欢的谷歌）并且没有'''找到
入门部分的所有信息......或者他/她看起来的第一个地方：在postgresql.org找到的文件
..我是很确定信息是否存在，但
的方式并不总是合乎逻辑的......恕我直言:-)
我不是假设是勺子喂，但更清晰/可访问的手册
当然有帮助..
如果有一个表显示MySQL中使用的命令会很好
（mysql）和PostgreSQL（psql）中使用相同结果的命令..
只需我的EUR 0,02
B.
---------------------------（广播结束）------- --------------------
提示6：您是否搜索了我们的列表档案？
http://archives.postgresql.org
New to PostgreSQL.. not to databases.. or Linux in general..
Let''s asume I got convinced by your advocacy and decided to install and
play a bit with PostgreSQL to discover it''s features and how I can use them.
Installation went fine. I decided to read the long version.. at some point
I was told to create a user postgres.
I didn''t find recommended settings for this user like if it needs a shell
and where the users homedir is supposed to be.. I mean.. I can understand
that PostgreSQL would require something simular to MySQL.. if it does..
then I would expect it to be in the docs->installation->long version.
Here I find myself behind a Linux box that can''t connect via PHP.. solved
that one too.. Found the solution quicker on PHP.net then on
postgresql.org.. even searched for postmaster -i (and other keywords I
could think of) on postgresql.org.. no results.. FWIW.. seaching for the
keyword postmaster did turn up the app_postmaster page..
Long story short, in order to get things going a newcomer needs to search a
lot (preferrable Google) and doesn''t find all the information in the
getting started section... or at the first place he/she looks: the docs
found at postgresql.org.. I''m quite sure the information is there but the
way to it is not always logical.... IMHO :-)
I''m not assuming to be spoon fed but a more clear/accessible manual would
certainly help..
Would be nice if there was a table showing the commands used in MySQL
(mysql) and the commands with the same result used in PostgreSQL (psql)..
Just my EUR 0,02
B.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
推荐答案
B. van Ouwerkerk写道：
B. van Ouwerkerk writes:
安装顺利。我决定阅读长版..在某些时候
我被告知要创建一个用户postgres。
我没有找到这个用户的推荐设置，如果它需要一个shell
用户homedir应该在哪里..我的意思是......我可以理解，PostgreSQL需要与MySQL类似的东西..如果它确实..
然后我会期望它在docs> installation->长版本。
同意，可以添加。
在这里，我发现自己背后的Linux盒子无法通过PHP连接..解决了
那个也是..在PHP.net上找到解决方案然后在postgresql.org上更快...甚至在postgresql.org上搜索了postmaster -i（和其他我认为的关键词）..没有结果.. FWIW ..关闭
关键字postmaster确实打开了app_postmaster页面..
Installation went fine. I decided to read the long version.. at some point
I was told to create a user postgres.
I didn''t find recommended settings for this user like if it needs a shell
and where the users homedir is supposed to be.. I mean.. I can understand
that PostgreSQL would require something simular to MySQL.. if it does..
then I would expect it to be in the docs->installation->long version.
Agreed, that could be added.
Here I find myself behind a Linux box that can''t connect via PHP.. solved
that one too.. Found the solution quicker on PHP.net then on
postgresql.org.. even searched for postmaster -i (and other keywords I
could think of) on postgresql.org.. no results.. FWIW.. seaching for the
keyword postmaster did turn up the app_postmaster page..
你想告诉我们你要做什么吗？因为使用标准的
安装我可以通过PHP连接就好了。
-
Peter Eisentraut pe ***** @ gmx.net
-------------- -------------（广播结束）---------------------------
提示6：您是否搜索了我们的列表档案？
http：/ /archives.postgresql.org
Would you care to tell us what you had to do? Because using the standard
installation I can connect via PHP just fine.
--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
在这里我发现自己落后一个无法通过PHP连接的Linux盒子......也解决了那个问题......在PHP.net上找到解决方案然后在postgresql.org上更快..甚至搜索了postmaster -i（和在postgresql.org上我可以想到的其他关键词..没有结果.. FWIW ..关于
关键字postmaster的搜索确实打开了app_postmaster页面..
Here I find myself behind a Linux box that can''t connect via PHP.. solved
that one too.. Found the solution quicker on PHP.net then on
postgresql.org.. even searched for postmaster -i (and other keywords I
could think of) on postgresql.org.. no results.. FWIW.. seaching for the
keyword postmaster did turn up the app_postmaster page..
<你愿意告诉我们你要做什么吗？因为使用标准的
安装我可以通过PHP连接就好了。
Would you care to tell us what you had to do? Because using the standard
installation I can connect via PHP just fine.
我无法修改postgresql.conf或启动PostgreSQL
with --i
如果你知道的话很明显..但如果你是新的那就不行......
B.
---------------------------（播出结束）------------ ---------------
提示3：如果通过Usenet发布/阅读，请发送适当的
subscribe-nomail命令 ma*******@postgresql.org ，以便您的
消息可以干净地进入邮件列表
I couldn''t without modifying either postgresql.conf or start PostgreSQL
with --i
Obvious if you know it.. but not if you''re new..
B.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly
B. van Ouwerkerk写道：
B. van Ouwerkerk writes:
您是否愿意告诉我们您必须做什么？因为使用标准的
安装我可以通过PHP连接就好了。
Would you care to tell us what you had to do? Because using the standard
installation I can connect via PHP just fine.
我无法修改postgresql.conf或启动PostgreSQL
- 我
I couldn''t without modifying either postgresql.conf or start PostgreSQL
with --i
必定有问题。 PHP应该能够通过
Unix域套接字连接。
-
Peter Eisentraut pe ***** @ gmx.net
--------------- ------------（广播结束）---------------------------
提示3：如果通过Usenet发布/阅读，请发送适当的
subscribe-nomail命令到 ma*******@postgresql.org ，以便您的
消息可以干净地通过邮件列表
There must be something wrong. PHP should be able to connect via
Unix-domain sockets.
--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly
这篇关于从新人角度看PostgreSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
