Re: PostgreSQL

From: Steve Wampler (swampler_at_noao.edu)
Date: 05/04/04

  • Next message: John Nichel: "Re: Old farts and new Linux"
    To: For users of Fedora Core releases <fedora-list@redhat.com>
    Date: Tue, 04 May 2004 10:28:21 -0700
    
    

    On Tue, 2004-05-04 at 10:22, gm wrote:
    > I have postgresql server running on my system however when the system
    > restarts I always have to run postmaster –D postgresSQL is there a
    > command to get this to run automatically so I don’t have to do this
    > over and over again.

    How did you install postgresql? If you did so in any of
    the normal ways you have a service initialization script:
    /etc/init.d/postgresql

    To see if you do (as root):

    -> chkconfig --list postgresql
    postgresql 0:off 1:off 2:off 3:on 4:on 5:on 6:off

    (You'll get an error if that script is missing!)
    In your case, I imagine that run-levels 3, 4, and 5 will all
    be "off". To turn them on:

    -> chkconfig --level 345 postgresql on

    Now postgresql will be started automatically on boot.

    Incidently, running postmaster directly is not the best way
    to start postgresql - use the "service" script instead:

    First - *STOP* the current postgresql (however you do that).

    Then to start it up manually:

    -> service postgresql start

    And to stop it manually:

    -> service postgresql stop

    to check whether it's running or not:

    -> service postgresql status

    Good luck!

    -- 
    Steve Wampler -- swampler@noao.edu
    The gods that smiled on your birth are now laughing out loud.
    -- 
    fedora-list mailing list
    fedora-list@redhat.com
    To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
    

  • Next message: John Nichel: "Re: Old farts and new Linux"

    Relevant Pages

    • Re: SELinux question
      ... but not the manual "service postgresql start" after bootup. ... (Maybe different contexts are applied to the logged-in root ...
      (Fedora)
    • Re: SELinux question
      ... but not the manual "service postgresql start" after bootup. ... (Maybe different contexts are applied to the logged-in root ... Running the initscript should be exactly the same as the boot ...
      (Fedora)
    • Postgresql 101
      ... I've installed the all the postgresql rpms on my RHL 9 machine and ... I've run the command "service postgresql start". ... The postgresql doc say that you have to run the initdb command but ... Do the createdb and createuser programs do anything other than output ...
      (RedHat)
    • Re: TCL/TK, PostgreSQL and pgaccess (on X11)
      ... | I'm quite new to postgreSQL, pgaccess and TCL/TK... ... | changed the pgaccess bash script to read wish8.4. ... as I have to learn PostgreSQL for work, | which I start in two weeks time. ...
      (comp.lang.tcl)
    • [Full-Disclosure] [ GLSA 200410-16 ] PostgreSQL: Insecure temporary file use in make_oidjoins_check
      ... The make_oidjoins_check script, part of the PostgreSQL package, is ... overwrite arbitrary files with the rights of the user running the ... PostgreSQL is an open source database based on the POSTGRES database ... Security is a primary focus of Gentoo Linux and ensuring the ...
      (Full-Disclosure)