Thread

  1. I would preffer that postgresql start with the flag -i

    gustavo Berns <webmaster@aaadir.com> — 2002-04-13T21:35:00Z

    Gustavo Berns wrote:
    
    I would like very much that when the server start also the postmaster start
    with the -i.
    I did look on the file  - /etc/rc.d/init.d/postgresql  - but, I don't know
    where to add the flag -i.
    Rather than try an error, I would prefer to added the -i right first time.
    Any body there has done this? If so I would be very happy to know how.
    
    
    
    
    
  2. Re: I would preffer that postgresql start with the flag -i

    Lamar Owen <lamar.owen@wgcr.org> — 2002-04-15T14:25:50Z

    On Saturday 13 April 2002 05:35 pm, gustavo Berns wrote:
    > Gustavo Berns wrote:
    
    > I would like very much that when the server start also the postmaster start
    > with the -i.
    > I did look on the file  - /etc/rc.d/init.d/postgresql  - but, I don't know
    > where to add the flag -i.
    > Rather than try an error, I would prefer to added the -i right first time.
    > Any body there has done this? If so I would be very happy to know how.
    
    Edit /var/lib/pgsql/data/postgresql.conf, uncomment the line with 
    tcpip_socket, and change the value to true.  Restart.  Adding -i in the 
    startup script is unnecessary.
    -- 
    Lamar Owen
    WGCR Internet Radio
    1 Peter 4:11
    
    
  3. Re: I would preffer that postgresql start with the flag -i

    Doug McNaught <doug@wireboard.com> — 2002-04-15T14:27:34Z

    "gustavo Berns" <webmaster@aaadir.com> writes:
    
    > Gustavo Berns wrote:
    > 
    > I would like very much that when the server start also the postmaster start
    > with the -i.
    > I did look on the file  - /etc/rc.d/init.d/postgresql  - but, I don't know
    > where to add the flag -i.
    > Rather than try an error, I would prefer to added the -i right first time.
    > Any body there has done this? If so I would be very happy to know how.
    
    Edit $DATADIR/postgresql.conf and set tcpip_socket to 'true'.
    
    -Doug
    -- 
    Doug McNaught       Wireboard Industries      http://www.wireboard.com/
    
          Custom software development, systems and network consulting.
          Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...
    
    
  4. Re: I would preffer that postgresql start with the flag

    ajimenez@servidor.unam.mx <ajimenez@servidor.unam.mx> — 2002-04-15T15:05:03Z

    Dear Gustavo:
    
    I am using Redhat 7.2, I modified postgresql like this in function
    start()
    
            # Check for postmaster already running...
            pid=`pidof -s postmaster`
            if [ $pid ]
            then
                    echo $"Postmaster already running."
            else             #all systems go -- remove any stale lock files
                  rm -f /tmp/.s.PGSQL.* > /dev/null
                  echo -n "$PSQL_START"
             su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -o "-i" -D $PGDATA
    
    its working fine ...
    
    regards,
    
    Alejandro Jimenez H.
    ajimenez@servidor.unam.mx
    
    On Sat, 13 Apr 2002, gustavo Berns wrote:
    
    > Gustavo Berns wrote:
    >
    > I would like very much that when the server start also the postmaster start
    > with the -i.
    > I did look on the file  - /etc/rc.d/init.d/postgresql  - but, I don't know
    > where to add the flag -i.
    > Rather than try an error, I would prefer to added the -i right first time.
    > Any body there has done this? If so I would be very happy to know how.
    >
    >
    >
    >
    > ---------------------------(end of broadcast)---------------------------
    > TIP 4: Don't 'kill -9' the postmaster
    >