Hi Ashesh
Postgresql.conf file (port part of conf file)
================
# - Connection Settings -
# - 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
# 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.RegardsRaghavendra
