pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Getting an error in connection refused
3+ messages / 3 participants
[nested] [flat]

* Getting an error in connection refused
@ 2005-08-11 17:19  Shilpa Tisgaonkar <shilpa.tisgaonkar@opensystemsinc.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Shilpa Tisgaonkar @ 2005-08-11 17:19 UTC (permalink / raw)
  To: pgsql-admin; +Cc: shilpatisgaonkar@yahoo.com

Hi,

 

I'm trying to connect to databasewhich has been already created. But
when I use following command  

 

psql -Utest1  -hlocalhost -p5432 -W testone

 

I'm getting  the following error

 

psql: could not connect to server: Connection refused

        Is the server running on host "localhost" and accepting

        TCP/IP connections on port 5432?

 

Can anybody please tell me how to solve this problem

 

 

Thanks and Regards

 

 

Shilpa

 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Getting an error in connection refused
@ 2005-08-15 00:25  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Shilpa Tisgaonkar <shilpa.tisgaonkar@opensystemsinc.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2005-08-15 00:25 UTC (permalink / raw)
  To: Shilpa Tisgaonkar <shilpa.tisgaonkar@opensystemsinc.com>; +Cc: pgsql-admin; shilpatisgaonkar@yahoo.com

"Shilpa Tisgaonkar" <shilpa.tisgaonkar@opensystemsinc.com> writes:
> I'm getting  the following error

> psql: could not connect to server: Connection refused
>         Is the server running on host "localhost" and accepting
>         TCP/IP connections on port 5432?

Looks like the postmaster hasn't been started.  See the PG documentation...

			regards, tom lane
 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Getting an error in connection refused
@ 2005-08-15 00:57  Siddharth Rath (sirath) <sirath@cisco.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Siddharth Rath (sirath) @ 2005-08-15 00:57 UTC (permalink / raw)
  To: Shilpa Tisgaonkar <shilpa.tisgaonkar@opensystemsinc.com>; +Cc: pgsql-admin; shilpatisgaonkar@yahoo.com; Tom Lane <tgl@sss.pgh.pa.us>

It may happen that the earlier postmaster-process didn't get killed
properly . I'd this issue some time back.

Try doing a "ps -A" and see if the postmaster is still showing up in the
process list.  If it is, then the db was not truly shutdown. So kill the
process and try again. If you wont get the postmaster then do a 

netstat -plunta | grep 5432

And see if the process is binding to 0 0.0.0.0 . If its binding to 0
0.0.0.0 then probably your sysadmin can help you out.

Thanx
Sidd


-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Sunday, August 14, 2005 5:25 PM
To: Shilpa Tisgaonkar
Cc: pgsql-admin@postgresql.org; shilpatisgaonkar@yahoo.com
Subject: Re: [ADMIN] Getting an error in connection refused 

"Shilpa Tisgaonkar" <shilpa.tisgaonkar@opensystemsinc.com> writes:
> I'm getting  the following error

> psql: could not connect to server: Connection refused
>         Is the server running on host "localhost" and accepting
>         TCP/IP connections on port 5432?

Looks like the postmaster hasn't been started.  See the PG
documentation...

			regards, tom lane
 

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-08-15 00:57 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-11 17:19 Getting an error in connection refused Shilpa Tisgaonkar <shilpa.tisgaonkar@opensystemsinc.com>
2005-08-15 00:25 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-08-15 00:57 Re: Getting an error in connection refused Siddharth Rath (sirath) <sirath@cisco.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox