Re: error while starting database

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

[root(at)imap /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:

[root(at)imap /root]# pg_ctl stop
pg_ctl: No database directory or environment variable $PGDATA is specified

[root(at)imap /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

[root(at)imap /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 <doug(at)oakstreetsoftware(dot)com> 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*
> doug(at)oakstreetsoftware(dot)com
> (910) 526-5938
>
>
>
>

--
NItin Saxena