Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012
    Posts
    18

    Unanswered: Dependency of Database from PosgreSQL?

    Hi again, dear people.

    I figure there are like 3 entities involved in using PosgreSQL:

    1.PostgreSQL itself,

    2. the database created/used, and

    3. A software (client) that talks to PosgreSQL, which in turn talks to the database and talks back to the software. So, it figures, but correct me if not so, that PostgreSQL is in-between the application and the database.

    I have these questions, and would much appreciate your valued replies on them, on the location/dependency of those 3 entities:

    1. Can each of the 3 entities be in separate machines and there-from interact? Meaning like: Computer-1 have the database, Computer-2 have PostgreSQL, and Computer-3 have the application (client)?

    Thanks again!

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    No. The database is not a "process" itself. It's an integral part of the PostgreSQL server and that cannot be separated. So 1) and 2) are always on the same computer. Actually one can't exist without the other.

    You might want to have a look here: http://www.postgresql.org/docs/curre...rial-arch.html
    and here: http://www.postgresql.org/files/developer/tour.pdf (page 3 & 4)
    Last edited by shammat; 06-09-12 at 20:12.

  3. #3
    Join Date
    Jun 2012
    Posts
    18
    Thank you very much, Shammat. This confirms what I was kind of gathering, that contrary to what I was used to, the database DEPENDS on PostgreSQL, but PostgreSQL can exist without a database.

    In fact, seems to me, but correct me if wrong, the relationship is kind of like a one-to-many, since the same installed and running PosgreSQL can manage many databases simultaneously?

    I think this also kind of explains (to me) why the databases are not portable, as you made clear in another thread, plus of course the links you referred me to, that I will go to as soon as possible. First I'll make sure I have the docs for the version I installed (the latest, I believe).

    Thanks again. This is very helpful to me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •