Thread: New ODBC psqlodbc-07_01_0004.zip

I have downloaded and installed this on a W2000 box but am getting a error
about TCP/IP, does the Redhat precompiled binary not accept TCP/IP
connections? How do I stop Postmaster since Redhat so conveniently auto
starts it for at boot?

Thanks,

Keith

Keith Todd wrote:
>
> I have downloaded and installed this on a W2000 box but am getting a error
> about TCP/IP, does the Redhat precompiled binary not accept TCP/IP
> connections? How do I stop Postmaster since Redhat so conveniently auto
> starts it for at boot?
>

Try 'ps axw | grep postmaster'.
If there isn't an -i option you would have to change
the postmaster startup option.
Anyway see ftp://ftp.postgresql.org/pub/odbc/faq.html.

regards,
Hiroshi Inoue

> I have downloaded and installed this on a W2000 box but am
> getting a error
> about TCP/IP, does the Redhat precompiled binary not accept TCP/IP
> connections?

No. Edit /var/lib/pgsql/hba.conf. In addition you might edit the
following script
to set the -i option Hiroshi mentioned...

> How do I stop Postmaster since Redhat so
> conveniently auto starts it for at boot?

Use the /etc/rc.d/init.d/postgresql script with start, stop or restart
option
like this:

  # /etc/rc.d/init.d/postgresql stop

I hope the distribution you use has the same locations and file names.

Tibor Laszlo
ltibor@mail.tiszanet.hu