Re: Fresh Installation of 7.1.1 RPMs = no binding to a port

This is true, in Red Hat 7.1 with PostgreSQL RPMS 7.1.1 you have to MANUALLY
edit the /etc/rc.d/init.d/postgresql and change the line:

su -l postgres -c "LC_ALL=C /usr/bin/pg_ctl  -D $PGDATA -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null

for:

su -l -s /bin/sh postgres -c "LC_ALL=C /usr/bin/pg_ctl -o "-i"  -D $PGDATA -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null

when you do this you add the -i option so the postmaster now listens for
connection (default localhost). After that you should change pg_hba.conf to
add permissions to external hosts to connect.

Greetings,

Jorge Sarmiento



On Sunday 27 May 2001 11:18 am, Justin Clift wrote:
> Hi Neil,
>
> In the configuration file, did you give it the -i option?
>
> This tells it to accept TCP/IP connections as well.  Don't know your
> exact script, so you may have to use -o '-i' to get the -i to take
> effect.  You'll figure it out.
>
> :-)
>
> Regards and best wishes,
>
> Justin Clift
>
> Neil Mock wrote:
> > Hi,
> >
> > I just installed (not upgraded) Postgrseql 7.1.1 from
> > RPM's from the postgresl website.  I'm running RedHat
> > 7.1, and the startup script in init.d seems to work
> > fine, it says postgresql is running, etc.  I can
> > create databases and work with them, but for some
> > reason postgrseql is not binding to any port.  I have
> > set in the configuration file for it to bind to port
> > 5432 (which is the default I believe), but no luck.
> > Everything else seems to work fine.
> >
> > Any suggestions?
> >
> > Thanks,
> >
> > Neil
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Auctions - buy the things you want at great prices
> > http://auctions.yahoo.com/
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html