Обсуждение: Fw: Bug in postgresql 8.1

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

Fw: Bug in postgresql 8.1

От
prem tolani
Дата:
Below error occurs only when i restart postgre 8.1 service when applicaion =
is running. Otherwise it works fine, but while application is running and i=
 restart postgre 8.1 service. Application crashes. Please refer to below em=
ail.

Regards,
Prem

--- On Sun, 18/3/12, prem tolani <premtolani@yahoo.com> wrote:

> From: prem tolani <premtolani@yahoo.com>
> Subject: Bug in postgresql 8.1
> To: pgsql-bugs@postgresql.org
> Date: Sunday, 18 March, 2012, 10:41 AM
> Please refer to below mail and help,
> i need urgent help.
>=20
> Thanks in advance.
>=20
> Regards,
> Prem
>=20
>=20
>=20
> > I get below error message> >=20
> >=20
> > PG "FATAL:=EF=BF=BD could not reattach to shared memory
> > > (key=3D5432001, addr=3D02100000): Invalid
> > > > argument.
> > >=20
> >=20
> > This messages occurs in windows 7 eventviewer log.
> > Application log / postgresql log do not show anything.
> It is
> > custom application made in java. When application is
> running and i restart postgresql service, the application
> crashes. What could be probable reason and solution to this
> ?=20
> >=20
> > If you need more info do let me know.
> >=20
> > Regards,
> > Prem
> >=20
> >=20
> >=20
> > --- On Sun, 18/3/12, Adrian Klaver <adrian.klaver@gmail.com>
> > wrote:
> >=20
> > > From: Adrian Klaver <adrian.klaver@gmail.com>
> > > Subject: Re: [GENERAL] One more query
> > > To: "prem tolani" <premtolani@yahoo.com>
> > > Cc: pgsql-general@postgresql.org
> > > Date: Sunday, 18 March, 2012, 2:09 AM
> > > On 03/17/2012 12:04 AM, prem tolani
> > > wrote:
> > > > Hi Tom,
> > > >=20
> > > > I am using one postgresql 8.1, when my
> application
> > in
> > > java is running and i restart the postgresql 8.1
> > service, my
> > > application crashes. Can you please tell me what
> could
> > the
> > > probable fix for this ? I am using windows 7(32
> bit).
> > This
> > > does not happen on windows xp. can u please tell
> me
> > what
> > > could be the probable reason for that ?
> > >=20
> > > This is going to need a lot more information to
> get an
> > > answer:)
> > >=20
> > > Are any error messages shown?
> > >=20
> > > What is the application ?
> > > =C2=A0=C2=A0=C2=A0Is it custom or a known application?
> > >=20
> > > What do the logs say?
> > > =C2=A0=C2=A0=C2=A0Postgres
> > > =C2=A0=C2=A0=C2=A0Application
> > > =C2=A0=C2=A0=C2=A0Windows
> > >=20
> > > >=20
> > > > regards,
> > > > Prem
> > > >=20
> > >=20
> > >=20
> > > -- Adrian Klaver
> > > adrian.klaver@gmail.com
> > >
> >
>

Re: Fw: Bug in postgresql 8.1

От
Jaime Casanova
Дата:
On Sun, Mar 18, 2012 at 12:13 AM, prem tolani <premtolani@yahoo.com> wrote:
> Below error occurs only when i restart postgre 8.1 service when applicaio=
n is running. Otherwise it works fine, but while
> application is running and i restart postgre 8.1 service. Application cra=
shes. Please refer to below email.
>

postgres 8.1 is not currently supported (since November 2010,
http://www.postgresql.org/support/versioning), so is likely that if
something was done in postgres to support win7 it hasn't reach 8.1

the best "fix" you can get is to migrate to a newer supported version
as soon as possible.

--=20
Jaime Casanova=A0 =A0 =A0 =A0=A0 www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n

Re: Bug in postgresql 8.1

От
Dave Page
Дата:
On Sunday, March 18, 2012, Jaime Casanova <jaime@2ndquadrant.com> wrote:
> On Sun, Mar 18, 2012 at 12:13 AM, prem tolani <premtolani@yahoo.com>
wrote:
>> Below error occurs only when i restart postgre 8.1 service when
applicaion is running. Otherwise it works fine, but while
>> application is running and i restart postgre 8.1 service. Application
crashes. Please refer to below email.
>>
>
> postgres 8.1 is not currently supported (since November 2010,
> http://www.postgresql.org/support/versioning), so is likely that if
> something was done in postgres to support win7 it hasn't reach 8.1

It hasn't been supported on Windows for *much* longer.

> the best "fix" you can get is to migrate to a newer supported version
> as soon as possible.

+1. Windows 7 will never be a supported platform for 8.1, even if it was
still supported in general.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: Bug in postgresql 8.1

От
Jaime Casanova
Дата:
On Sun, Mar 18, 2012 at 8:11 AM, Dave Page <dpage@pgadmin.org> wrote:
>
>
> On Sunday, March 18, 2012, Jaime Casanova <jaime@2ndquadrant.com> wrote:
>> On Sun, Mar 18, 2012 at 12:13 AM, prem tolani <premtolani@yahoo.com>
>> wrote:
>>> Below error occurs only when i restart postgre 8.1 service when
>>> applicaion is running. Otherwise it works fine, but while
>>> application is running and i restart postgre 8.1 service. Application
>>> crashes. Please refer to below email.
>>>
>>
>> postgres 8.1 is not currently supported (since November 2010,
>> http://www.postgresql.org/support/versioning), so is likely that if
>> something was done in postgres to support win7 it hasn't reach 8.1
>
> It hasn't been supported on Windows for *much* longer.
>

true. i forgot that, support for 8.1 on windows was dropped on 2008
with release of 8.1.11, and it was because of very serious problems.
so, not being able to start the database is the less serious of your
problems.

http://www.postgresql.org/about/news/865

--=20
Jaime Casanova=A0 =A0 =A0 =A0=A0 www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n