[BUGS] Index file corruption in PG 7.1.3
This bug is for PostgreSQL 7.1.3 running on an SGI Irix 6.5 system. All regression tests passed when the system was built. While loading large amounts of data into new database, I started getting the following error message from my loading script. At Thu Dec 13 15:48:29 EST 2001: executing copy atoms from stdin ERROR: copy: line 1, cannot open segment 3 of relation atoms_id (target block 4215318): No such file or directory PQendcopy: resetting connection I tracked down the filename for this relation and the segments are not full length! Notice: gaia postgres 12 >>ls 4750787* -rw---1 postgres other 617963520 Dec 13 14:54 4750787 -rw---1 postgres other 97861632 Dec 13 14:48 4750787.1 -rw---1 postgres other 114630656 Dec 13 14:43 4750787.2 The first two files should have been 1073741824 bytes in length. This file is an index which was created when the data base was empty using the following command: create index atoms_id on atoms using hash (atom_id); The atoms table is defined as follows: create table atoms ( mol_id text, res_id text, name text, atom_idtext, elementtext); +--++ | Robert E. Bruccoleri, Ph.D. | Phone: 609 737 6383| | President, Congenomics, Inc. | Fax: 609 737 7528| | 114 W Franklin Ave, Suite K1,4,5 | email: [EMAIL PROTECTED]| | P.O. Box 314 | URL: http://www.congen.com/~bruc | | Pennington, NJ 08534 || +--++ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[BUGS] Bug #537: In Red Hat don't open port 5432 and PostgreSql don't work.
Roger ([EMAIL PROTECTED]) 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
Re: [BUGS] Bug #537: In Red Hat don't open port 5432 and PostgreSql
On Thu, 13 Dec 2001 [EMAIL PROTECTED] wrote: > Roger ([EMAIL PROTECTED]) 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. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [BUGS] Bug #537: In Red Hat don't open port 5432 and PostgreSql don't work.
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: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 ([EMAIL PROTECTED]) 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 > ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [BUGS] Bug #537: In Red Hat don't open port 5432 and PostgreSql
On Thursday 13 December 2001 06:24 pm, Stephan Szabo wrote: > On Thu, 13 Dec 2001 [EMAIL PROTECTED] wrote: > > Roger ([EMAIL PROTECTED]) 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 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
