server closed the connectio unexpectedly

Started by Nonameover 23 years ago3 messagesgeneral
Jump to latest
#1Noname
zurron@vesta.tmf.bg.ac.yu

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: server closed the connectio unexpectedly

<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

#3Noname
zurron@vesta.tmf.bg.ac.yu
In reply to: Tom Lane (#2)
Re: server closed the connectio unexpectedly

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:

Show quoted text

<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