O Fabrice.Sznajderman@devoteam.com Ýãñáøå óôéò Jan 18, 2006 :

> Hello,
>
> Thanks a lot for your answer,
>
> for answer question :
>
> OS : Suze enterprise 9
> kernel 2.6
> I used this command psql -V to have this :
>
> psql (PostgreSQL) 7.2.3-RH
> contains support for: readline, history, multibyte
> Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
> Portions Copyright (c) 1996, Regents of the University of California
> Read the file COPYRIGHT or use the command \copyright to see the
> usage and distribution terms.

Separately from the context,
you need to upgrade, 7.2 is far too old.

Some questions (altho i dont run suse or linux):

Has psql ever run correctly in the past on your very machine as is now?
When you connect from the other host do a:
select version();

(just to see your backend version too, this info is needed if you want
to track down some suse package issue).

Then try to figure out, how the various PgSQL packages were installed.

(In my FreeBSD machines, I DO IT BY HAND AND ONLY BY HAND).

>
> That is strange , the Database works well. When I tried a remote psql from
> another computer, I can access to the DB.
>
> I don't understand that line of your email : % gdb <psql executable> <path
> to core>
> (gdb) where
>
> what is 'gdb'
>

The debugger.

> What is broken? the psql is down or postgres database?
>

psql apparently.

> Thanks in advance for your help.
>
> Fabrice
>
>
>
>
>
>
> Fabrice SZNAJDERMAN
>
> DSI : Application Rendez-Vous - CCM
> tel : 01 41 49 60 77
>
>
>
> Achilleus Mantzios <achill@matrix.gatewaynet.com>
> Envoyé par : pgsql-jdbc-owner@postgresql.org
> 18/01/2006 15:37
>
> A
> Fabrice.Sznajderman@devoteam.com
> cc
> pgsql-jdbc@postgresql.org
> Objet
> Re: [JDBC] [PPOSTGRES][PSQL] Segmentation fault
>
>
>
>
>
>
> O Fabrice.Sznajderman@devoteam.com Î*γÏ�αψε στις Jan 18, 2006 :
>
> > Hello,
> >
> > I have a problem when I start PSQL.
> > I used psql command to start . and I had this message :
> >
> > Segmentation fault
> >
> > I don't understand what happen.
> >
> > Have you an idea?
> Your system needs some care.
> Something is definately broken.
> What changes did you make to the system since the last time
> psql worked correctly? (if any)
> In any case smth like
>
> % gdb <psql executable> <path to core>
> (gdb) where
>
> is your friend.
>
> Please tell us also your OS RELEASE, PgSQL version, architecture.
>
> >
> > thanks in advance for helps!
> >
> >
> >
> >
> > Fabrice SZNAJDERMAN
> > +---------------------------------------------------------------------+
> > About Devoteam:
> >
> > Devoteam is an IT consulting group.
> > Combining consulting and technology solutions offers enables
> > Devoteam to provide its customers with independent advice and
> > effective solutions to align their information system's technical
> > infrastructure with their operational objectives.
> > The group achieved a turnover of 150 million euros in 2004
> > an operating margin of 5.8% and counts 1,800 employees through
> > ten European countries and the Middle East.
> > Listed on the Euronext Paris Nouveau Marche and part of the Nexteconomy,
> > IT CAC, IT CAC 50, SBF 250 index of Euronext Paris.
> > www.devoteam.com
> > +---------------------------------------------------------------------+
> >
>
>

--
-Achilleus


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> O Fabrice.Sznajderman@devoteam.com Ýãñáøå óôéò Jan 18, 2006 :
>> OS : Suze enterprise 9
>> kernel 2.6
>> I used this command psql -V to have this :
>>
>> psql (PostgreSQL) 7.2.3-RH

> ...Then try to figure out, how the various PgSQL packages were installed.

I'm wondering that too, since the version string suggests that this psql
came from one of Red Hat's customized builds. What's it doing on a SUSE
box? Is it even compatible with the system's libraries?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq