Обсуждение: Postgre capability
Hi All,
I'm looking for any experience on runing an ERP software (Oracle application, SAP, PeopleSoft, ...) on top of a postgre data base.
Best Retards
Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.
On Sun, Feb 26, 2006 at 04:55:21AM -0800, Farhad wrote: > Hi All, > I'm looking for any experience on runing an ERP software (Oracle application, SAP, PeopleSoft, ...) on top of a postgredata base. The database is called PostgreSQL or Postgres, not Postgre. Search for ERP and Postgres on http://sourceforge.net and you'll get some hits back. I don't know of anyone running a commercial ERP system on PostgreSQL, but that doesn't mean someone isn't doing it. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
Hi,
Thanks for the link.
More exactly I wanted to know how far PostgreSql is from the Oracle or DB2 regard the following point:
Performances,
Data volume management, Could PostgreSql handle the giga data?
Backup and restore functionality.
Thanks Farhad
"Jim C. Nasby" <jnasby@pervasive.com> wrote:
"Jim C. Nasby" <jnasby@pervasive.com> wrote:
On Sun, Feb 26, 2006 at 04:55:21AM -0800, Farhad wrote:
> Hi All,
> I'm looking for any experience on runing an ERP software (Oracle application, SAP, PeopleSoft, ...) on top of a postgre data base.
The database is called PostgreSQL or Postgres, not Postgre.
Search for ERP and Postgres on http://sourceforge.net and you'll get
some hits back. I don't know of anyone running a commercial ERP system
on PostgreSQL, but that doesn't mean someone isn't doing it.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 9: In versions be low 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.
farhad_fh2003@yahoo.com (Farhad) wrote: > I'm looking for any experience on runing an ERP software (Oracle > application, SAP, PeopleSoft, ...) on top of a postgre data base. You won't find it, for two reasons: 1. There's no such thing as "postgre" The proper name is PostgreSQL, though people are often forgiven for falling back to "postgres". 2. Looking at that list... - Oracle Applications are an Oracle product, written expressly for the Oracle "database platform." - SAP is not the identity of a software product; it is the name of a large German company that sells something known as R/3. Deploying R/3 to additional database platforms (I *believe* the current list of databases is Oracle, Informix, DB2, Microsoft SQL Server, and SAP-DB) requires that SAP AG rewrite portions of the R/3 kernel. You cannot run R/3 atop any database you choose; you must run it on one of the specific combinations of OS and database that SAP AG supports. (They actually get more precise than that; historically, you needed to use a database install that was bundled with R/3. Thus, an "R/3 on HP/UX and Oracle" installation was a set of CDs that included both R/3 and Oracle, and that would only run on a specific release of HP/UX...) -- output = reverse("moc.liamg" "@" "enworbbc") http://linuxdatabases.info/info/internet.html Including a destination in the CC list that will cause the recipients' mailer to blow out is a good way to stifle dissent. -- from the Symbolics Guidelines for Sending Mail
It is certainly capable of running an ERP system from a technical standpoint, just that the major commercial vendors don't support it in their applications. If you were writing your own system though (or if you wanted to port one), you should be fine. On Sunday 26 February 2006 14:19, Farhad wrote: > Hi, > Thanks for the link. > More exactly I wanted to know how far PostgreSql is from the Oracle or > DB2 regard the following point: Performances, > Data volume management, Could PostgreSql handle the giga data? > Backup and restore functionality. > > Thanks Farhad > > "Jim C. Nasby" <jnasby@pervasive.com> wrote: > > On Sun, Feb 26, 2006 at 04:55:21AM -0800, Farhad wrote: > > Hi All, > > I'm looking for any experience on runing an ERP software (Oracle > > application, SAP, PeopleSoft, ...) on top of a postgre data base. > > The database is called PostgreSQL or Postgres, not Postgre. > > Search for ERP and Postgres on http://sourceforge.net and you'll get > some hits back. I don't know of anyone running a commercial ERP system > on PostgreSQL, but that doesn't mean someone isn't doing it. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL