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....@gmail.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.va...@enterprisedb.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....@gmail.com> wrote: >> >>> Hi All, >>> >>> Please find the below scenario, and suggest me... >>> >>> Trying to start the server, but not starting. >>> ---------------------------------------------------------- >>> [postg...@dbarhel564 mypg]$ pg_ctl -D /usr/local/pgsql/mypg/ start >>> server starting >>> [postg...@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"? >>> [postg...@dbarhel564 mypg]$ >>> >>> Checked in the Data Directory >>> ------------------------------------------- >>> [postg...@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 >>> [postg...@dbarhel564 mypg]$ >>> I havnt find the postmaster.pid here. >>> >>> Could you please guide me. >>> >>> Regards >>> Raghavendra >>> >>> >> >> >
