On Tue, Oct 28, 2008 at 3:26 PM, Jeff D <[EMAIL PROTECTED]> wrote: > On Tue, 28 Oct 2008, 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 >> >> >> 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 >> > > Are you sure its not starting and just listening on the localhost > interface? This is how it comes configured by default. If you want it to > listen on a different interface you have to edit > /etc/postgresql/8.3/main/postgresql.conf to reflect that and restart it > through /etc/init.d/postgresql-8.3 restart . my /etc/postgresql folder has nothing inside, did i miss some process for postgresql server? thanks
> jeff > > > > -- > 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.]