pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedGetting 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>
2005-08-15 00:25 ` Re: Getting an error in connection refused Tom Lane <tgl@sss.pgh.pa.us>
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-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>
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