Search Postgresql Archives

Re: does postgresql works on distributed systems?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Justin wrote:
> >
> >
> > aravind chandu wrote:
> > Hi,
> > >>  My question is
> > >>    Microsoft sql server 2005 cannot be shared on multiple systems
> > i,e in a network environment when it is installed in one system it
> > cannot be accessed one other systems.
> >
> >
> > This don't make any sense.  Are your taking about sharing the actual
> > mdb files or access the service itself???  This question is just
> > confusing.
> >
> >
> > Your Questions are confusing can you clarify
> > I'm guessing at what you mean???


> He's talking about having the raw database files on a file server (eg
> SMB share).  DB's like firebird and sqlite can handle this way of
> accessing the data using the embedded engines.

Active-active, multiple server databases are either a shared nothing or
a shared disk system.  Oracle, for instance is a shared disk system
where multiple database instances can connect to the same underlying
disk.  Greenplum, Teradata, and Netezza are examples of shared nothing
systems.

http://en.wikipedia.org/wiki/Shared_nothing_architecture

http://en.wikipedia.org/wiki/Shared_disk_file_system

PostgreSQL does not have either a shared disk or shared nothing
architecture.  It is similar to SQL Server where replication and/or
failover is how you can get high availability.

http://www.postgresql.org/docs/8.3/interactive/high-availability.html

Greenplum and EnterpriseDB are both based on PostgreSQL and use a shared
nothing architecture to achieve and active-active system.


Jon


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux