Re: error while starting database - Mailing list pgsql-bugs

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@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@imap /root]# pg_ctl stop
pg_ctl: No database directory or environment variable $PGDATA is specified

[root@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@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@oakstreetsoftware.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@oakstreetsoftware.com
> (910) 526-5938
>
>
>
>


--
NItin Saxena