Обсуждение: I would preffer that postgresql start with the flag -i

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.

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
>

"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...

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