Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2012
    Posts
    2

    Unanswered: Postgresql can not start automatically

    Hey all
    one of my server was somthing wrong recently,postgresql can not start automatically when server reboot,everytime i must manually start postgresql,using:/etc/init.d/postgresql-8.3 start. but other servers all be done.all settings of postgresql are same!there are my settings of postgres and ssl.


    ERROR LOG:

    This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. You can either reduce the request size or reconfigure the kernel with larger SHMMAX. To reduce the request size (currently 35807232 bytes), reduce PostgreSQL's shared_buffers parameter (currently 3072) and/or its max_connections parameter (currently 303).
    If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising the request size or reconfiguring SHMMIN is called for.
    The PostgreSQL documentation contains more information about shared memory configuration.
    2012-04-19 19:03:50 CST LOG: could not load root certificate file "root.crt": no SSL error reported
    2012-04-19 19:03:50 CST DETAIL: Will not verify client certificates.
    2012-04-19 19:03:50 CST FATAL: could not create shared memory segment: Invalid argument
    2012-04-19 19:03:50 CST DETAIL: Failed system call was shmget(key=5432001, size=35807232, 03600).


    Postgresql:

    pg_hba.conf------------------------------------------------->
    # Database administrative login by UNIX sockets
    local all postgres ident sameuser

    # TYPE DATABASE USER CIDR-ADDRESS METHOD

    # "local" is for Unix domain socket connections only
    local all all ident sameuser
    # IPv4 local connections:
    host all all 127.0.0.1/32 trust
    host all all 172.16.0.0/16 trust
    # IPv6 local connections:
    host all all ::1/128 md5
    <-------------------------------------------------------------
    postgreqsl.conf

    ssl=true

    rc.local
    /etc/init.d/postgresql-8.3 start

  2. #2
    Join Date
    Jun 2010
    Posts
    17
    Could you please share below output:

    -bash-3.2$ cd /proc/sys/kernel/
    -bash-3.2$ more sem

    --Raghu

  3. #3
    Join Date
    Apr 2012
    Posts
    2
    yeah~you are right
    i already solved this problem,the shmmax is 256M,so the Postgresql can not start automatically.now i adjusted to 1G,the server work OK!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •