Re: [PERFORM] Minimum hardware requirements for Postgresql db

Dear all Sorry for my mistake on the 15000 recs per day. In fact, this server is planned as a OLTP database server for a retailer. Our intention is either to setup 1 or 2 Postgresql db in the server. The proper sizing info for the 1st Postgresql db should be: No. of item master : 200,000 (Thi

[PERFORM] Minimum hardware requirements for Postgresql db

Dear all We would be recommending to our ct. on the use of Postgresql db as compared to MS SQL Server. We are targetting to use Redhat Linux ES v2.1, Postgresql v7.3.4 and Postgresql ODBC 07.03.0100. We would like to know the minimum specs required for our below target. The minimum specs is refer

Re: [PERFORM] Duplicate user in pg_shadow

Hi I tried to delete the user from the pg_user but couldnt. This username is being duplicated so we have the same 2 records. What is the cause ? Is it due to memory or wrong configuration? Thank you, REgards.

[PERFORM] Duplicate user in pg_shadow

Hi When I do a SELECT * FROM pg_shadow, I can have more than one user with the same id. This caused the pg_dump to fail.

[PERFORM] Postgresql vs OS compatibility matrix

Hi We installed our Postgresql package from the RH CDROM v9. The version is v7.3.2 Is there a compatibility matrix for Postgresql vs OS that I can verify? I have checked the ftp sites for Postgresql software under the binary/RPMS folder and discovered that v7.3.2 is not available for redhat 9.0

[PERFORM] Duplicate in pg_user table

Hi Currently we are running Postgresql v7.3.2 on Redhat Linux OS v9.0. We have Windows2000 client machines inserting records into the Postgresql tables via the Postgres ODBC v7.3.0100. After a few weeks of usage, when we do a \d at the sql prompt, there was a duplicate object name in the same sch

Re: [PERFORM] Postgresql performance

Hi The Postgresql package came from the Redhat v9.0 CDROM. I have checked the version using psql --version and it showed v7.3.2 The duplication of table names is in the same schema. How to check the pg_dump version? Thank you, REgards.

Re: [PERFORM] Postgresql performance

Hi The Postgresql package came from the Redhat v9.0 CDROM. I have checked the version using psql --version and it showed v7.3.2 How to check the pg_dump version? Thank you, REgards.

[PERFORM] Postgresql performance

Hi Currently we are running Postgresql v7.3.2 on Redhat Linux OS v9.0. We have Windows2000 client machines inserting records into the Postgresql tables via ODBC. After a few weeks of usage, when we do a \d at the sql prompt, there was a duplicate object name, ie it can be a duplicate row of index