Обсуждение: Postgre capability

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

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

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