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: ef956e030708170731u55d6d17cvf1056fa1068b014f@mail.gmail.com (view raw or flat)
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(Connection.java:123)
at org.postgresql.Driver.connect(Driver.java:116)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at SendGrpSmpp.readSMPPtable(SendGrpSmpp.java:219)
at SendGrpSmpp.run(SendGrpSmpp.java:96)


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:
/usr/bin/postmaster
-p 5432
-D /var/lib/pgsql/data
-B 64
-b /usr/bin/postgres
-i
-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
down...............................................................pg_ctl:
postmaster does not shut down


when i am giving pg_ctl start:

pg_ctl: It seems another postmaster is running. Try to start postmaster
anyway.
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.


Regards--
NItin Saxena

Responses

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-2014 The PostgreSQL Global Development Group