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

From Douglas Toltzman
Subject Re: error while starting database
Date
Msg-id F21C0D96-9C81-4F1C-B1D8-173935AA3435@oakstreetsoftware.com
Whole thread Raw
In response to error while starting database  ("Nitin Saxena" <nitinmca05@gmail.com>)
List pgsql-bugs
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
>
> [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

Douglas Toltzman
doug@oakstreetsoftware.com
(910) 526-5938

pgsql-bugs by date:

Previous
From: Kris Jurka
Date:
Subject: Re: BUG #3544: SQLException from JDBC driver
Next
From: Otto Weichselbaum
Date:
Subject: JDBC-Interface - Behaviour on Update, Insert or Delete returning ResultSets - Inconsistency to Console & ODBC