Skip site navigation (1) Skip section navigation (2)

error while starting database

From: "Nitin Saxena" <nitinmca05(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: error while starting database
Date: 2007-08-17 14:31:27
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
I am using postgres 7.0 on linux platform.
My java application was running fine ,but i got this message

Connection refused. Check that the hostname and port is correct, and that
the postmaster is r
unning with the -i flag, which enables TCP/IP networking.
at org.postgresql.Connection.openConnection(
at org.postgresql.Driver.connect(
at java.sql.DriverManager.getConnection(
at java.sql.DriverManager.getConnection(
at SendGrpSmpp.readSMPPtable(

When i am connecting as su via su - postgres
at bash: when i give psql Database Name

It is giving error:

psql: connectDBStart() -- connect() failed: No such file or directory
        Is the postmaster running at 'localhost'
        and accepting connections on Unix socket '5432'?

when i am  using pg_ctl status command:

it   gives output:  pg_ctl: postmaster is running (pid: 776)
options are:
-p 5432
-D /var/lib/pgsql/data
-B 64
-b /usr/bin/postgres
-N 32

when i am using pg_ctl stop  it gives

/usr/bin/pg_ctl: kill: (776) - No such pid
postmaster successfully shut down.

when i am using pg_ctl restart it gives

bash-2.04$ pg_ctl restart
/usr/bin/pg_ctl: kill: (776) - No such pid
Waiting for postmaster shutting
postmaster does not shut down

when i am giving pg_ctl start:

pg_ctl: It seems another postmaster is running. Try to start postmaster
FATAL: StreamServerPort: bind() failed: No such file or directory
        Is another postmaster already running on that port?
        If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
pg_ctl: Cannot start postmaster. Is another postmaster is running?
bash-2.04$ /usr/bin/postmaster: cannot create UNIX stream port.

Expecting your kind help on urgent.

NItin Saxena


pgsql-bugs by date

Next:From: Douglas ToltzmanDate: 2007-08-17 14:48:42
Subject: Re: error while starting database
Previous:From: tomasDate: 2007-08-17 12:11:45
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group