Hello.
I am new to Postgresql and I am having a problem with starting it in FreeBSD at boot time.
(Also, my user account is pgsql not postgresql)
Presently, I have this command in my /etc/rc.conf file:
su pgsql -c "/usr/local/bin/postmaster -D /usr/local/pgsql/data"
Postgresql does start at bootup and the ports are listening (5432). However, every 5-10 minutes a message pops up on the console screen:
su: in prompt_echo_off(): tcgetattr(): Inappropriate ioctl for device
su: BAD SU operator to pgsql on tty
and then a message appears in mail:
>From operator(at)zeus(dot)cablerocket(dot)net Sun May 15 15:00:00 2005
Return-Path: <operator(at)zeus(dot)cablerocket(dot)net>
Received: from zeus.cablerocket.net (localhost [127.0.0.1])
by zeus.cablerocket.net (8.13.1/8.13.1) with ESMTP id j4FJ00pQ000676
for <operator(at)zeus(dot)cablerocket(dot)net>; Sun, 15 May 2005 15:00:00 -0400 (EDT)
(envelope-from operator(at)zeus(dot)cablerocket(dot)net)
Received: (from operator(at)localhost)
by zeus.cablerocket.net (8.13.1/8.13.1/Submit) id j4FJ00is000660;
Sun, 15 May 2005 15:00:00 -0400 (EDT)
(envelope-from operator)
Date: Sun, 15 May 2005 15:00:00 -0400 (EDT)
Message-Id: <200505151900(dot)j4FJ00is000660(at)zeus(dot)cablerocket(dot)net>
From: operator(at)zeus(dot)cablerocket(dot)net (Cron Daemon)
To: operator(at)zeus(dot)cablerocket(dot)net
Subject: Cron <operator(at)zeus> /usr/libexec/save-entropy
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin>
X-Cron-Env: <HOME=/>
X-Cron-Env: <LOGNAME=operator>
X-Cron-Env: <USER=operator>
Status: RO
su: Sorry
Now. If I issue the command myself (after the system starts up) then I do not get the messages. So I am assuming I am doing something wrong.
I hope someone can help with this one.
Thanks!
Buddy