Re: [GENERAL] Poatgresql database on more than one disk
> Pardon me for being dense, but I don't see how, with this approach, you > maintain transaction integrity between the two databases. Suppose you need > a transaction involving tables from both databases. Can you explain how you > achieve this? You can't anyways (server side) no matter where the two separate databases reside unless you use contrib/dblink in which case it again matters not where the databases reside. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Poatgresql database on more than one disk
--On Monday, May 31, 2004 2:14 PM -0500 "Philip A. Chapman" <[EMAIL PROTECTED]> wrote: On Tue, 2004-05-25 at 18:33, Barry wrote: Is it possible to configure Postgresql to have seperate databases on seperate disks ? One solution is to run two postmasters (two services). Each would use a different value for the PGDATA environment variable. Pardon me for being dense, but I don't see how, with this approach, you maintain transaction integrity between the two databases. Suppose you need a transaction involving tables from both databases. Can you explain how you achieve this? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Poatgresql database on more than one disk
Barry wrote: Hi All, I am a newcommer to Postgresql, currently I am looking at moving a Pick based application across to PostgreSQL. I am using RH Linux and Postgresql 7.3.6 The test system I am using has a 2 channel raid card with a disk pack connected to each channel. The OS and Postgresql sits on its own internal disk. I would like to be able to use one disk pack for development and the other for end user testing / verification (the tape drive can only backup one disk pack completely, not both) I have spent a fair amount of time researching how I can run two databases, one on each disk pack but have not been able to find a solution. Is it possible to configure Postgresql to have seperate databases on seperate disks ? Not easily as will be with the Table Space feature that most probably will be present on 7.5 With 7.3.6 what you can do is move your db and create a link in the original place: -bash-2.05b$ oid2name All databases: - 17142 = kalman 19185 = photodb 27895 = empdb 1 = template1 17141 = template0 5776262 = logs -bash-2.05b$ pwd /var/lib/pgsql/data/base -bash-2.05b$ ll total 32 drwx--2 postgres postgres 4096 Feb 8 15:18 1 drwx--2 postgres postgres 4096 Feb 8 03:56 17141 drwx--2 postgres postgres 4096 May 25 19:37 17142 drwx--2 postgres postgres 8192 Feb 8 15:58 19185 drwx--3 postgres postgres 8192 May 16 02:46 27895 drwx--2 postgres postgres 4096 May 18 00:06 5776262 in my case if I want the database kalman to another disk what I have to do is: stop the engine, move the directory /var/lib/pgsql/data/base/17142 to the new location and create the link. With the same mechanism you can also place different tables in different disks. I hope this help you. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html