Re: postgresql with tcp/ip conection

[Filipi Vianna <filipi@em.pucrs.br>]

cenapad wrote:

> Does anybody  know how to configure /etc/init.d/postgresql to accept 
> TCP/IP conections?
> In redhat was simpler (just modify the line was started with "su -l 
> postgres"). But in debian, filhe is completely different .
> I know that a flag -i should be added, but i dont know where.

There is how I do it on Slackware:

/bin/su - postgres -c "/opt/pgsql/bin/postmaster -i -S -D/opt/pgsql/data 
-N 128 -B 256 >> /opt/pgsql/server.log 2>&1 </dev/null &"


Where /opt/pgsql/data is my data directory...
The other options should be found in postmaster docs...

I hope the same works on debian.
On MacOs I use sudo not su, it's more secure.

C-ya,
--
Filipi Vianna
Laboratório de Mecânica Computacional (DEMM)
Faculdade de Engenharia - PUC-RS
telefone: (51) 3320-3500 ramal: 4053