Thread: Bug #537: In Red Hat don't open port 5432 and PostgreSql don't work.
Bug #537: In Red Hat don't open port 5432 and PostgreSql don't work.
From
pgsql-bugs@postgresql.org
Date:
Roger (rogermg@teleline.es) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description In Red Hat don't open port 5432 and PostgreSql don't work. Long Description Hi! I recently installing Red Hat 7.2. One of RPM were your PostgreSql. I thing that there is a bug in the instalallation. Packetis installed correctly with no error messages. When I try to init server by (etc/init.d/postgresql start) the Linuxsays all is OK. But when I make a port Scan the PostfreSql Port (5432) is not openened and PostMaster process is running.So PostgreSql don't work because I can not connect to databases... In redHat 7.1 all was ok.... But 7.2.... -- Roger PD: Sorry for my english. Sample Code No file was uploaded with this report
On Thu, 13 Dec 2001 pgsql-bugs@postgresql.org wrote: > Roger (rogermg@teleline.es) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > In Red Hat don't open port 5432 and PostgreSql don't work. > > Long Description > Hi! > I recently installing Red Hat 7.2. One of RPM were your PostgreSql. I > thing that there is a bug in the instalallation. Packet is installed > correctly with no error messages. When I try to init server by > (etc/init.d/postgresql start) the Linux says all is OK. But when I > make a port Scan the PostfreSql Port (5432) is not openened and > PostMaster process is running. So PostgreSql don't work because I can > not connect to databases... In redHat 7.1 all was ok.... But 7.2.... What version of PostgreSQL is it? I believe between PostgreSQL 7.0 and PostgreSQL 7.1 the default was changed on install to not open the port for security reasons. You'll probably need to edit the postgresql.conf file to turn it on (tcpip_socket = true) and may need to edit the pg_hba.conf to set up your security rules.
You probably need to configure your firewall. RedHat 7.2 installs, by default, with firewall settings that do not allow access to most ports. root@localhost> /usr/sbin/setup Then select firewall setup and add ports 5432:tcp and (possibly) 5432:udp manually. --rob P.S. I admire your English. At least you can speak another language. ----- Original Message ----- From: <pgsql-bugs@postgresql.org> To: <pgsql-bugs@postgresql.org> Sent: Thursday, December 13, 2001 5:52 PM Subject: [BUGS] Bug #537: In Red Hat don't open port 5432 and PostgreSql don't work. > Roger (rogermg@teleline.es) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > In Red Hat don't open port 5432 and PostgreSql don't work. > > Long Description > Hi! > > I recently installing Red Hat 7.2. One of RPM were your PostgreSql. I thing that there is a bug in the instalallation. Packet is installed correctly with no error messages. When I try to init server by (etc/init.d/postgresql start) the Linux says all is OK. But when I make a port Scan the PostfreSql Port (5432) is not openened and PostMaster process is running. So PostgreSql don't work because I can not connect to databases... In redHat 7.1 all was ok.... But 7.2.... > > -- > Roger > > PD: Sorry for my english. > > Sample Code > > > No file was uploaded with this report > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
On Thursday 13 December 2001 06:24 pm, Stephan Szabo wrote: > On Thu, 13 Dec 2001 pgsql-bugs@postgresql.org wrote: > > Roger (rogermg@teleline.es) reports a bug with a severity of 2 > > The lower the number the more severe it is. > > Short Description > > In Red Hat don't open port 5432 and PostgreSql don't work. > > Long Description > > Hi! > > I recently installing Red Hat 7.2. One of RPM were your PostgreSql. I > > thing that there is a bug in the instalallation. Packet is installed > What version of PostgreSQL is it? I believe between PostgreSQL 7.0 and > PostgreSQL 7.1 the default was changed on install to not open the port > for security reasons. You'll probably need to edit the postgresql.conf > file to turn it on (tcpip_socket = true) and may need to edit the > pg_hba.conf to set up your security rules. Red Hat 7.2 comes with PostgreSQL 7.1.3. And, as Stephan has already said, this is intentional behavior. Edit postgresql.conf as he suggests, and port 5432 will show in the portscan. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11