separating out database files

From: "Gill, Jeffrey L" <jeffrey(dot)l(dot)gill(at)intel(dot)com>
To: "Pgsql Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: separating out database files
Date: 2002-03-14 21:28:12
Message-ID: 01BDB7EEF8D4D3119D95009027AE999511DD2CE5@FMSMSX33
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

How do you separate the postgresql database files in InterChange
from the rest of the application?

What is the command syntax and what files need to be modified that
call and point to the database? I am researching DSN...

My goal is to separate InterChange so it can exist on three
different machines representing a three tier architecture -
web tier, middle tier, and data tier (backend database).

I only want the minimum number of files required on the database
server. Therefore what files are required and which ones can
moved to the other machines? Is there a FAQ on this somewhere?

Are there any gotchas to look out for when doing this?

Specs: Server RedHat 7.1 2.4.2-2 kernal everything build with
Interchange 4.8

I am learning Linux and Postgresql from scratch.

Thanks,
Jeff

Browse pgsql-admin by date

  From Date Subject
Next Message postgresql 2002-03-14 22:28:35 Re: seq scan on indexed column
Previous Message Oliver Elphick 2002-03-14 21:17:05 Re: [SQL] Syslog