On Tue, Oct 28, 2008 at 12:23 PM, Ron Johnson <[EMAIL PROTECTED]> wrote:
> On 10/27/08 22:36, Star Liu wrote:
>>
>> On Tue, Oct 28, 2008 at 10:58 AM, Ron Johnson <[EMAIL PROTECTED]>
>> wrote:
>>>
>>> On 10/27/08 21:07, Star Liu wrote:
>>>>
>>>> I installed postgresql server in my machine, but i does not start
>>>> automatically at startup time, so i need to mannually type these
>>>> commands to start it everytime when i restart system
>>>>
>>>> Desktop:~# su postgres
>>>> Desktop:/root$ cd ~
>>>> Desktop:~$ postgres -D ~/data >~/log/logfile 2>&1 &
>>>>
>>>> i tried to add this command line into /etc/X11/Xsession.d/95StarHabit:
>>>
>>> Why the heck would you put it in an X script??????????
>>
>> I do not know, I just put all the things I want to do at system
>> startup into this file
>
> Stuff like that goes in /etc/init.d/ or /etc/rc.local.
>
>>>> su -c "postgres -D /var/lib/postgresql/data >
>>>> /var/lib/postgresql/log/logfile 2>&1 &" postgres
>>>> but it doesn't work
>>>>
>>>> how can i make these commands automatically executed at system startup?
>>>> thanks
>>>
>>> How did you install PostgreSQL? If thru a Debian package, then Debian
>>> will
>>> handle all this for you.
>>
>> Yes, i installed it thru debian package, but it doesn't start up at
>> system startup, so i need to start it by myself, is there anyway to
>> automate it? thanks
>
> There *must* be a relevant /etc/init.d/postgre* file.
yes, there is a /etc/init.d/postgresql-8.3, its content is:
-----------------------------------------------------------------------------------------
[ -r /usr/share/postgresql-common/init.d-functions ] || exit 0
. /usr/share/postgresql-common/init.d-functions
VERSION=8.3
case "$1" in
start)
start $VERSION
;;
stop)
stop "$VERSION"
;;
restart)
restart "$VERSION"
;;
force-reload | reload)
reload $VERSION
;;
status)
status $VERSION
;;
autovac-start)
autovac_start $VERSION
;;
autovac-stop)
autovac_stop $VERSION
;;
autovac-restart)
autovac_restart $VERSION
;;
*)
echo "Usage: $0
{start|stop|restart|reload|force-reload|status|autovac-start|autovac-stop|autovac-restart}"
exit 1
;;
esac
exit 0
-----------------------------------------------------------------------------------------
so should i add the following line into this file?
su -c "postgres -D /var/lib/postgresql/data >
/var/lib/postgresql/log/logfile 2>&1 &" postgres
thanks
> --
> Ron Johnson, Jr.
> Jefferson LA USA
>
> Help a man when he is in trouble and he will remember you when
> he is in trouble again.
>
>
> --
> To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject
> of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
>
>
--
I'm a debian user and a web
developer(XML+XSLT+AJAX+XHTML＋CSS+PostgreSQL+MONO C#) in City of
Shanghai, China.
Welcome to add my IMs! (msn) [EMAIL PROTECTED] (xmpp) [EMAIL PROTECTED]
HomePage http://starliu dot 9966 dot com [It's only available when my
personal machine is running, on which it's hosted.]
