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 th

Re: [GENERAL] Error handling in stored functions/procedures

> You mean that the default generated error messages contain some more > information I presume, like the table name and the constraint name ? Even better, the information is *structured* afaik. > I think I noticed that already, and since I had time since yesterday > evening, I thought things over

Re: [GENERAL] book for postgresql

On Mon, 9 Feb 2004, Christopher Browne wrote: > Date: Mon, 09 Feb 2004 20:57:13 -0500 > From: Christopher Browne <[EMAIL PROTECTED]> > To: "[EMAIL PROTECTED]"@postgresql.org > Subject: Re: [GENERAL] book for postgresql > > A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Ed Wong) wr

Re: [GENERAL] FTP daemon that support Postgresql

ProFTPD supports PostgreSQL, see http://www.castaglia.org/proftpd/doc/contrib/ProFTPD-mini-HOWTO-SQL.html ProFTPD's website is http://www.proftpd.org ProFTPD also supports SSL/TLS encrypted FTP connections via OpenSSL via mod_tls. Jason -Original Message- From: [EMAIL PROTECTED] [mailt

Re: [GENERAL] Postgres on Solaris 10

The world rejoiced as [EMAIL PROTECTED] (Phil Berman) wrote: > Does anyone know if Postgres runs/will run on Solaris > 10? If not, will it be released for that OS? At some point, probably. It would be surprising for version 10 to be _so_ incompatible with its predecessors that PostgreSQL would b

Re: [GENERAL] FTP daemon that support Postgresql

After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] ("NTPT") belched out: > I know this is a slightly offtopic, but please hlep. I need to find a (S)FTP daemon > for my server > (RH7.3) , that can read username, password an home directory from > PGSQL table . Can you advise something ? I

Re: [GENERAL] pg_dump question

[EMAIL PROTECTED] writes: > Can I dump specifc table and still get the actual sequence for it. It works for me in 7.3 and later --- at least when the column was created by calling it a SERIAL column. If you made the sequence separately then I don't think this is really a bug.

Re: [GENERAL] Postgres on Solaris 10

Phil Berman wrote: > Does anyone know if Postgres runs/will run on Solaris > 10? If not, will it be released for that OS? Uh, it should work fine. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard

Re: [GENERAL] PostgreSQL Tablespaces

TroyGeek wrote: I found this on the Internet. http://candle.pha.pa.us/main/writings/pgsql/project/tablespaces.html Does anyone know when tablespaces will make their way into PostgreSQL? The next version ( is not yet choosed if is a 7.5 or 8.0 ) will contain that feature ( we hope ). Regards Gaet

Re: [GENERAL] Insert speed question

Josué Maldonado wrote: sort_mem = 131072 # min 64, size in KB 128 MB for sort_mem is really an huge ammount of memory considering that is not system-wide but almost for process ( under certain operations a single process can use more then this quantity ). Hackers: am I wrong ? Regards

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 differen

[GENERAL] Separating application from data

Is it possible to put the data and structure files of Postgres (tables, views, indicies, sequences and so on) on another machine than that one where system files are? In other words I want to put only the system and application files on one server and only the structure and data files on another