Re: server closed the connection unexpectedly

It seems that postgresql crashed recently, tried to restart
automatically, and has not succesfully restarted.

You will need to stop the postmaster daemon manually, probably delete
the postmaster.pid file, and restart the postmaster daemon.

Chances are that anyone trying to query the database is not able to....

HTH

On Fri, 2004-07-16 at 21:05, Clodoaldo Pinto Neto wrote:
> Hi all,
>
> Errors running a psql batch that has worked for weeks without a
> problem:
> $ uname -a
> Linux s1 2.6.6-1.435.2.3 #1 Thu Jul 1 08:25:29 EDT 2004 i686 athlon
> i386 GNU/Linux
> $ rpm -q postgresql
> postgresql-7.4.2-1
> $ psql KakaoStats
> Bem-vindo ao psql 7.4.2, o terminal iterativo do PostgreSQL.
>
>
> select insert_usuarios_producao();
> psql:/KakaoStats/scripts/sql/kakaoStats.sql:92: server closed the
> connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> psql:/KakaoStats/scripts/sql/kakaoStats.sql:92: connection to server
> was lost
>
> select deleta_antigos()
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> vacuum KakaoStats
> psql: FATAL: the database system is starting up
>
> These commands are some of the last of a script which runs normaly
> until then.
>
> Regards
> Clodoaldo Pinto
>
>
>
>
>
>
>
> _______________________________________________________
> Yahoo! Mail agora com 100MB, anti-spam e antivrus grtis!
> http://br.info.mail.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org