Re: error while starting database

All I can tell you, based on this information, Nitin, is that your
postmaster is not started, and it is failing to start for some
reason. Without any additional information, there is absolutely
nothing I can tell you. Try listing the /var/lib/pgsql/data folder.
Verify that it does exist and that it does contain the postgres
configuration files, at least.

I don't have time to teach you everything you need to know to
administer a Un*x system or to be a DBA. If you were encountering a
specific error, I'm sure someone could help you isolate it. However,
this is the bugs list, as I pointed out before, it is not the correct
list for determining how to configure your server. Once you get the
server started, you should be able to dump your database and upgrade
your software.

On Aug 18, 2007, at 12:40 PM, Nitin Saxena wrote:

> Sir ,
>
> plz reply
>
> regards:
> nitin
>
> On 8/18/07, Nitin Saxena <nitinmca05(at)gmail(dot)com> wrote:
> Dear Sir,
>
> please find the attached file.:
>
> This error is of boot.log file which i had attach with mail
>
> Aug 18 13:33:19 imap postgresql: Starting postgresql service: failed
> Aug 18 13:39:21 imap postgresql: postmaster shutdown failed
> Aug 18 13:39:23 imap postgresql: Checking postgresql installation:
> succeeded
> Aug 18 13:39:25 imap postgresql: Starting postgresql service: failed
> Aug 18 13:41:44 imap postgresql: postmaster shutdown failed
> Aug 18 13:41:46 imap postgresql: Checking postgresql installation:
> succeeded
> Aug 18 13:41:48 imap postgresql: Starting postgresql service: failed
> Aug 18 13:49:01 imap postgresql: postmaster shutdown failed
> Aug 18 13:49:03 imap postgresql: Checking postgresql installation:
> succeeded
> Aug 18 13:49:05 imap postgresql: Starting postgresql service: failed
> Aug 18 14:44:56 imap postgresql: postmaster shutdown failed
> Aug 18 14:44:58 imap postgresql: Checking postgresql installation:
> succeeded
> Aug 18 14:45:00 imap postgresql: Starting postgresql service: failed
>
> output of different commands
>
> [root(at)imap /]# pg_ctl status
> /usr/bin/pg_ctl: [: -lt: unary operator expected
> pg_ctl: postmaster is running (pid: )
> options are:
> /usr/bin/postmaster
> -p 5432
> -D /var/lib/pgsql/data
> -B 64
> -b /usr/bin/postgres
> -i
> -N 32
>
> [root(at)imap /]# pg_ctl stop
> /usr/bin/pg_ctl: [: -lt: unary operator expected
> kill: usage: kill [-s sigspec | -n signum | -sigspec] [pid |
> job]... or kill -l [sigspec]
> postmaster successfully shut down.
>
> [root(at)imap /]# pg_ctl start
> pg_ctl: It seems another postmaster is running. Try to start
> postmaster anyway.
> pg_ctl: Cannot start postmaster. Is another postmaster is running?
>
> I dont have postgresql.conf file in any of my directory
>
> I had only pg_hba.conf file.
>
> My application was working fine till yesterday.
>
> plzz help
>
>
> Regards:
>
> Nitin Saxena
>
>
>
>
>
> On 8/18/07, Douglas Toltzman <doug(at)oakstreetsoftware(dot)com > wrote:
> At this point, I'd have to have more information to be able to tell
> you what to fix. Does the server give any reason why it fails to
> start? There could be a configuration error or a permissions error
> on one of the database configuration files. Does the server give a
> detailed error message? Check your error logs, also, for clues.
>
> On Aug 18, 2007, at 11:45 AM, Nitin Saxena wrote:
>
>> Hi,
>>
>> I have done it on my system
>>
>> drwxrwxrwt 2 root root 4096 Aug 18 19:06 tmp
>>
>>
>> still getting the same error.
>>
>> [root(at)imap /]# /etc/rc.d/init.d/postgresql restart
>> Stopping postgresql service: FAILED]
>> Checking postgresql installation: OK ]
>> Starting postgresql service: FAILED]
>>
>> Now what to do sir?
>>
>> looking forward for your support.
>>
>>
>> Regards
>> Nitin
>>
>>
>>
>> On 8/18/07, Gregory Stark <stark(at)enterprisedb(dot)com> wrote:
>> "Douglas Toltzman" <doug(at)oakstreetsoftware(dot)com> writes:
>>
>> > In any case, the server specifically calls out an error creating
>> > "/tmp/.s.PGSQL.5432". I would start by creating a world-
>> writable /tmp
>> > folder.
>>
>> FWIW the correct permissions for /tmp on Unix machines is 1777. It
>> should look
>> like this (note the "t" in place of the last "x"):
>>
>> $ ls -ld /tmp
>> drwxrwxrwt 8 root root 12288 Aug 18 16:30 /tmp
>>
>> --
>> Gregory Stark
>> EnterpriseDB http://www.enterprisedb.com
>>
>>
>>
>> --
>> NItin Saxena
>
> Douglas Toltzman
> doug(at)oakstreetsoftware(dot)com
> (910) 526-5938
>
>
>
>
>
>
> --
> NItin Saxena
>
>
>
> --
> NItin Saxena

Douglas Toltzman
doug(at)oakstreetsoftware(dot)com
(910) 526-5938