Finally, I managed to run Postgresql in Linux FriendlyARM environment. It seems
that Postgresql server starts to work, however, it prints out some WARNING
info. during the start. The error info. is as follows:
LOG: could not resolve "localhost": Temporary failure in name resolution
LOG: disabling statistics collector for lack of working socket
WARNING: autovacuum not started because of misconfiguration
HINT: Enable the "track_counts" option.
So the above log indicates that autovacuum failed to start mainly due to the
problem that "localhost" cannot be resolved as 127.0.0.1? But I can ping
localhost from command line without any problem. My /etc/hosts file reads as:
127.0.0.1 localhost.localdomain localhost
In addition, options "autovacuum" and "track_counts" are turned on by default
in postgresql.conf file. But in database, with command "show autovacuum", its
value is shown as "on" while with command "show track_counts", its value is
shown as "off".
Could anyone provide some hints about how to handle this kind of problem?
Kind regards,
Gerry
Xiang Gan <xiang...@santaitech.com> writes:
> OK. So a stupid question, whether there is any possibility to run Postgresql
> as root? (I know this is forbidden generally. But what I find out is that in
> Linux FriendlyArm environment, root could create socket while non-root user
> does not have such privilege)
So, it's not so much FriendlyArm as StupidAndUselessArm? What sort of nut
would think that all network services should run as root?
The short answer to your question is that if you're so inclined, you
can easily find and dike out the no-root check in the server source
code. But the Postgres project never has and never will publish a
version with that check removed or compromised in any way, and we will
not provide support if you have any problems running the server that way.
We do not believe it's advisable to run network-accessible services
as root.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
