Thread: server closed the connectio unexpectedly

Hi, I'm new in postgres, so I don't know alot, only the basics

I created a data base and create one user and when I want give privileges
this error apears

test_ip=# GRANT SELECT ON tb_allowed_ip TO zurron;
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#


I'm running red hat 8.0, postgres version 7.2.2

thanks for any help

<zurron@vesta.tmf.bg.ac.yu> writes:
> I created a data base and create one user and when I want give privileges
> this error apears

> test_ip=# GRANT SELECT ON tb_allowed_ip TO zurron;
> server closed the connection unexpectedly

That's fairly surprising.  What shows up in the postmaster's log file
(stderr or syslog output) when this happens?  Is there a core dump from
the backend process, and if so can you get a stack trace from it?

            regards, tom lane

Only ones show this  output:
 core dump from the backend process

but the rest of the times it's the same
 server closed the connection unexpectedly

thanks,
 Fabian


On Mon, 23 Dec 2002, Tom Lane wrote:

> <zurron@vesta.tmf.bg.ac.yu> writes:
> > I created a data base and create one user and when I want give privileges
> > this error apears
>
> > test_ip=# GRANT SELECT ON tb_allowed_ip TO zurron;
> > server closed the connection unexpectedly
>
> That's fairly surprising.  What shows up in the postmaster's log file
> (stderr or syslog output) when this happens?  Is there a core dump from
> the backend process, and if so can you get a stack trace from it?
>
>             regards, tom lane
>