Re: How to automatically start postmastrer with TCP/IP support (-i option) ???

Paulo Parola writes:

> I am trying to configure PostgreSQL 7.1 over RedHat 7.0 (according to
> Lamar Owen the RPM's for 7.1 were built on RedHat 6.2 and not 7.0 -
> does that implies any possible problems?).

Always rebuild from the source RPM. Never trust binary RPMs unless you
have the exact same OS.

> 1) How should I make so that PostgreSQL is automatically started
> accepting TCP/IP connections like I did by hand with the command above
> ( nohup /usr/bin/postmaster -i -D /var/lib/pgsql/data </dev/null
> >>server.log 2>>1 &) ??? Which file should I edit to add option '-i'
> for accepting TCP/IP connections?

In $PGDATA/postgresql.conf, add a line 'tcpip_socket = on'.

> Apparently, in shell script '/etc/rc.d/init.d/postgresql' the line
> that starts the postmaster reads 'su -l postgres -c "/usr/bin/pg_ctl
> -D $PGDATA -p /usr/bin/postmaster start >/dev/null 2>&1" < /dev/null',
> is that right?

No. It discards the log output.

> 2) With which user shall I connect to the database? User "apache" or
> maybe user "nobody" ? Should I create a user 'apache' in PostgreSQL?

Doesn't matter, but you have to make a user in PostgreSQL. System users
are not automatically PostgreSQL users.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/