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 >> >> > >