dbTalk Databases Forums  

Connection terminated

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Connection terminated in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Carla
 
Posts: n/a

Default Connection terminated - 04-27-2004 , 06:06 PM






Hi
I am running postgres locally. All was working well.
I can start postgres using the command line which says:
Quote:
postgres successfully started.
but when I type in the command
Quote:
psql -U nameOfUser
psql: server closed the connection unexpectedly
This problem means the server terminated abnormally
before or while processing the request.

I have checked In postmaster.log which says:
DEBUG: database system is ready
I have checked PGDATA, PGHOME and PGHOST which all have the correct path.
I have checked postgres in the current processes running,ans that psql is on
it path.
Why can I no longer run psql?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.620 / Virus Database: 399 - Release Date: 11/03/2004


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match



Reply With Quote
  #2  
Old   
joseph speigle
 
Posts: n/a

Default Re: Connection terminated - 04-27-2004 , 06:10 PM






hi
can you connect as the user who started the postmaster, or maybe as postgres user, without password? try not specifiying the user, just do 'psql -d template1' as postgres

On Tue, Apr 27, 2004 at 04:06:04PM -0700, Carla wrote:
Quote:
Hi
I am running postgres locally. All was working well.
I can start postgres using the command line which says:
postgres successfully started.

but when I type in the command
psql -U nameOfUser
psql: server closed the connection unexpectedly
This problem means the server terminated abnormally
before or while processing the request.

I have checked In postmaster.log which says:
DEBUG: database system is ready
I have checked PGDATA, PGHOME and PGHOST which all have the correct path.
I have checked postgres in the current processes running,ans that psql is on
it path.
Why can I no longer run psql?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.620 / Virus Database: 399 - Release Date: 11/03/2004


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
--
joe speigle
www.sirfsup.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.