Thread: Error in the connection to the server

On 04/15/2015 01:35 PM, Ravi Kiran wrote:
> Hi,
>
> I have installed postgresql-9.4.0 version.
>
> I have started the server from eclipse indigo version using Run
> configurations.

Have no idea what that means.

Some detail on exactly how you are making the connection would be
helpful including:

1) Is the client on the same machine as the server?

2) What OS or OSes are we talking about?

3) What is the client using for connecting, though I going to assume
JDBC, correct?

4) What is the connection string?



>
> There is a table in my database whose name is "b". whenever I give a
> query which is related to this table I get the error *"The connection to
> the server was lost. Attempting reset: Failed." *Even for the drop
> command it is giving the same error.

So what happens if you psql to connect to the database and run the query?

Is there anything in the Postgres logs around the connection drop that
relates?


> But it is working fine for the rest of the queries which are not related
> to the table b.
> Please help me in resolving this error.
>
> Thank you.
>
> --
> Regards,
>
> K.Ravikiran
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On Thu, 16 Apr 2015 02:05:34 +0530
Ravi Kiran <ravi.kolanpaka@gmail.com> wrote:
>
> I have installed postgresql-9.4.0 version.
>
> I have started the server from eclipse indigo version using Run
> configurations.
>
> There is a table in my database whose name is "b". whenever I give a query
> which is related to this table I get the error *"The connection to the
> server was lost. Attempting reset: Failed." *Even for the drop command it
> is giving the same error.
> But it is working fine for the rest of the queries which are not related to
> the table b.
> Please help me in resolving this error.

Find the postgresql.conf, read through it to understand where
PostgreSQL is logging, then go look at the PostgreSQL logs.
There's a 90% chance that there will be a detailed message in
the logs that will help you quickly resolve the problem. If not,
you can increase the log verbosity.


--
PT <wmoran@potentialtech.com>