Обсуждение: BUG #1372: Service won't start with tcpip_socket = true

Поиск
Список
Период
Сортировка

BUG #1372: Service won't start with tcpip_socket = true

От
"Graham Robson"
Дата:
The following bug has been logged online:

Bug reference:      1372
Logged by:          Graham Robson
Email address:      graham.robson@coherencedesign.co.uk
PostgreSQL version: 8.0
Operating system:   Windows XP SP2
Description:        Service won't start with tcpip_socket = true
Details:

Trying to setup TCP/IP access over my network. The supplied postgresql.conf
has no commented reference to the setting tcpip_socket = true.

Adding this in stops the service from starting i.e. this reference directly
stops the service from starting.

An appropriate entry defining the IP_ADDRESS in the pg_hba.conf

Re: BUG #1372: Service won't start with tcpip_socket = true

От
"Magnus Hagander"
Дата:
> The following bug has been logged online:
>=20
> Bug reference:      1372
> Logged by:          Graham Robson
> Email address:      graham.robson@coherencedesign.co.uk
> PostgreSQL version: 8.0
> Operating system:   Windows XP SP2
> Description:        Service won't start with tcpip_socket =3D true
> Details:=20
>=20
> Trying to setup TCP/IP access over my network. The supplied=20
> postgresql.conf has no commented reference to the setting=20
> tcpip_socket =3D true.
>=20
> Adding this in stops the service from starting i.e. this=20
> reference directly stops the service from starting.
>=20
> An appropriate entry defining the IP_ADDRESS in the pg_hba.conf

Please check your postgresql logs. If they contain an error about shared
memory witgh "Invalid argument", you have hit a known bug in <=3D RC3
versions. This is (supposed to be) fixed in RC3.

If you're installing from the MSI, there is no MSI installer for RC3 yet
(sorry about that), but we expect to put one out in the next couple of
days. If you're gonig from source, try to just upgrade your version.
Finally, if you're going from the MSI, there is an *ugly* workaronud
downloadable from http://www.hagander.net/pgsql/postgres_shmem.zip.
Replace your postgres.exe from this file, and then copy postgres.exe
over postmaster.exe (they should be identical). I wouldn't recommend
this solution for long, but if you're still in a testing environment it
might be worth a try while waiting for RC3.

//Magnus

Re: BUG #1372: Service won't start with tcpip_socket = true

От
Kris Jurka
Дата:
On Tue, 4 Jan 2005, Graham Robson wrote:

>
> The following bug has been logged online:
>
> Bug reference:      1372
> Logged by:          Graham Robson
> Email address:      graham.robson@coherencedesign.co.uk
> PostgreSQL version: 8.0
> Operating system:   Windows XP SP2
> Description:        Service won't start with tcpip_socket = true
> Details:
>
> Trying to setup TCP/IP access over my network. The supplied postgresql.conf
> has no commented reference to the setting tcpip_socket = true.
>
> Adding this in stops the service from starting i.e. this reference directly
> stops the service from starting.
>

8.0 has replaced the tcpip_socket flag with the listen_addresses setting
which specifies which addresses to listen on.

Kris Jurka