If it is true that listing /tmp (ls -a /tmp) returns no such file or
directory, then that may be the problem. You should have a world-
writable /tmp folder, as Tom already pointed out. Also, an update to
a more stable version of PostgreSQL is still highly recommended.
On Aug 17, 2007, at 11:12 PM, Nitin Saxena wrote:
Hi
All the command such as gives following output;
1: :ls -a/tmp: No such file or directory
2 : "rm -f/tmp/.s.PGSQL.5432"
bash: rm -f/tmp/.s.PGSQL.5432: No such file or directory
3:"ps -ax|grep postgres"
bash: ps -ax|grep postgres: command not found
Does PID in postmaster.pid file is automatically created when we
start the database.
When i am giving command pg_ctl status at root, It is giving error
message as
pg_ctl: No database directory or environment variable $PGDATA is
specified
and
When i am giving command pg_ctl status at bash it is giving
postmaster is running
[EMAIL PROTECTED] /root]# su - postgres
bash-2.04$ pg_ctl status
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 giving command at root directory:
[EMAIL PROTECTED] /root]# pg_ctl stop
pg_ctl: No database directory or environment variable $PGDATA is
specified
[EMAIL PROTECTED] /root]# su - postgres
bash-2.04$ pg_ctl stop
/usr/bin/pg_ctl: kill: (776) - No such pid
postmaster successfully shut down.
when i am giving command
bash-2.04$ 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
when i am giving pg_ctl restart
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
Please tell how to start services in postgres
when i m giving command
[EMAIL PROTECTED] /root]# service postgresql restart
Stopping postgresql service: [FAILED]
Checking postgresql installation: [ OK ]
Starting postgresql service: [FAILED]
Please help ASAP, as i have to up the application as soon as possible
Thanks & Regards:
Nitin Saxena
On 8/17/07, Douglas Toltzman <[EMAIL PROTECTED]> wrote:
PostgreSQL version 7.0 is really, really out of date, but as far as
I know, it should still work.
I generally use "ps -ax | grep postges" to see if there is a
postgres process running. Also, I use "netstat -a" to see open
sockets and listening servers.
Have you removed the socket file in /tmp and tried to start the
server? You may also want to check the server log to see if there
is any indication of why it crashed. Once you clean up the residue
from the server that abended, you'll be able to start it again,
unless there are serious problems with the database. I've only
seen one case where I couldn't get the server restarted, though,
and that was after a hard drive failure caused corruption in
several files. Even then, I was able to recover everything.
BTW: the socket file ("/tmp/.s.PGSQL.5432") will be a hidden file.
You'll need to "ls -a /tmp" to see it. You can just "rm -f /
tmp/.s.PGSQL.5432" as root and that should clean it up for you.
p.s. This is not a bug, and even if it was, I'm sure version 7.0 is
no longer supported. You may want to use a different list if you
require additional assistance.
On Aug 17, 2007, at 10:31 AM, Nitin Saxena wrote:
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
Douglas Toltzman
[EMAIL PROTECTED]
(910) 526-5938
--
NItin Saxena
Douglas Toltzman
[EMAIL PROTECTED]
(910) 526-5938
