Re: Server not Starting

[raghavendra t <raagavendra.rao@xxxxxxxxx>]

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.rao@xxxxxxxxx> 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.vashi@xxxxxxxxxxxxxxxx> wrote:

What is the value set for the port in postgresql.conf?

--
Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Company

On Wed, Apr 14, 2010 at 10:57 AM, raghavendra t <raagavendra.rao@xxxxxxxxx> wrote:

Hi All,

 

Please find the below scenario, and suggest me...

 

Trying to start the server, but not starting.

----------------------------------------------------------

[postgres@dbarhel564 mypg]$ pg_ctl -D /usr/local/pgsql/mypg/ start
server starting
[postgres@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@dbarhel564 mypg]$

 

Checked in the Data Directory

-------------------------------------------

[postgres@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@dbarhel564 mypg]$

I havnt find the postmaster.pid here.

 

Could you please guide me.

 

Regards

Raghavendra