Re: Server not Starting

Hi,

Log file
=====

LOG: database system was interrupted; last known up at 2010-04-12 10:53:12
IST
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 0/1A0003C8
LOG: redo is not required
FATAL: could not access status of transaction 889
DETAIL: Could not read from file "pg_clog/0000" at offset 0: Success.
LOG: startup process (PID 303) exited with exit code 1
LOG: aborting startup due to startup process failure
~
Regards
Raghavendra
On Wed, Apr 14, 2010 at 11:02 AM, raghavendra t
<raagavendra(dot)rao(at)gmail(dot)com>wrote:

> Hi Ashesh
>
> Postgresql.conf file (port part of conf file)
> ================
> # - Connection Settings -
> listen_addresses = 'localhost' # what IP address(es) to listen on;
> # comma-separated list of
> addresses;
> # defaults to 'localhost', '*' =
> all
> # (change requires restart)
> port = 5432 # (change requires restart)
> max_connections = 100 # (change requires restart)
>
> regards
> raghavendra
>
>
> On Wed, Apr 14, 2010 at 11:00 AM, Ashesh Vashi <
> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>
>> What is the value set for the port in postgresql.conf?
>>
>> --
>> Thanks & Regards,
>>
>> Ashesh Vashi
>> EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com/>
>>
>>
>> On Wed, Apr 14, 2010 at 10:57 AM, raghavendra t <
>> raagavendra(dot)rao(at)gmail(dot)com> wrote:
>>
>>> Hi All,
>>>
>>> Please find the below scenario, and suggest me...
>>>
>>> Trying to start the server, but not starting.
>>> ----------------------------------------------------------
>>> [postgres(at)dbarhel564 mypg]$ pg_ctl -D /usr/local/pgsql/mypg/ start
>>> server starting
>>> [postgres(at)dbarhel564 mypg]$ psql -p 5432 -d postgres
>>> psql: could not connect to server: No such file or directory
>>> Is the server running locally and accepting
>>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>>> [postgres(at)dbarhel564 mypg]$
>>>
>>> Checked in the Data Directory
>>> -------------------------------------------
>>> [postgres(at)dbarhel564 mypg]$ ls
>>> arch db.dmp mypg.dmp mytablespace pg_hba.conf pg_log
>>> pg_stat_tmp pg_tblspc PG_VERSION postgresql.conf
>>> base global mypgtar.tar pg_clog pg_ident.conf pg_multixact
>>> pg_subtrans pg_twophase pg_xlog postmaster.opts
>>> [postgres(at)dbarhel564 mypg]$
>>> I havnt find the postmaster.pid here.
>>>
>>> Could you please guide me.
>>>
>>> Regards
>>> Raghavendra
>>>
>>>
>>
>>
>