[ADMIN] Upgrade problems with OID type ...

2004-07-06 Thread Daniel Rubio
Hi all! I'm trying to upgrade from 7.3.2 to 7.4.3 but I've a problem with a database (1 I know, there could be more) containing a table with an oid type field. I run the migration doing: ../bin/pg_dumpall -o -p 5432 | /apps/pgs-7.4.3/bin/psql -d template1 -p 5433 1/tmp/out 2/tmp/err The

[ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Matt Browne
Hello all! I apologise in advance if any of my questions are in a FAQ somewhere - I haven't seen them... Does anyone know when (if ever) replication support will be added to the main PostgreSQL codebase? Is there any chance it'll be included in the upcoming 7.5 release? I've taken a look at the

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Christopher Browne
After a long battle with technology, [EMAIL PROTECTED] (Matt Browne), an earthling, wrote: I apologise in advance if any of my questions are in a FAQ somewhere - I haven't seen them... Does anyone know when (if ever) replication support will be added to the main PostgreSQL codebase? Is there

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Matt Browne
On 06 July 2004 16:41, Christopher Browne wrote: I've taken a look at the replication solutions already available, including the sterling effort made on Slony-I, but we're really looking for integrated, base-level support rather than an add-in. The problem is that replication doesn't

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Marc G. Fournier
On Tue, 6 Jul 2004, Matt Browne wrote: On 06 July 2004 16:41, Christopher Browne wrote: I've taken a look at the replication solutions already available, including the sterling effort made on Slony-I, but we're really looking for integrated, base-level support rather than an add-in. The problem is

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Bruce Momjian
Marc G. Fournier wrote: Christopher is correct ... if there was such a thing as an 'end all, be all' replication solution, there wouldn't be a half a dozen different ones out there ... It would be unwise for *anyone* to state never as far as inclusion of built-in replication, but since

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Christopher Petrilli
On Tue, 6 Jul 2004 17:07:33 -0300 (ADT), Marc G. Fournier [EMAIL PROTECTED] wrote: It would be unwise for *anyone* to state never as far as inclusion of built-in replication, but since the general consensus is that there is no such thing as the 'all-encompassing solution' for this, the chances

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Peter Eisentraut
Christopher Browne wrote: Jan Wieck puts it fairly nicely: The number of different replication solutions available supports the theory that ``one size fits all'' is not true when it comes to database replication. The fact that all but one or two replication solutions out there are

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Peter Eisentraut
Marc G. Fournier wrote: Christopher is correct ... if there was such a thing as an 'end all, be all' replication solution, there wouldn't be a half a dozen different ones out there ... Which ones are you thinking of in your count? I don't get anywhere near half a dozen.

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Marc G. Fournier
On Tue, 6 Jul 2004, Peter Eisentraut wrote: Marc G. Fournier wrote: Christopher is correct ... if there was such a thing as an 'end all, be all' replication solution, there wouldn't be a half a dozen different ones out there ... Which ones are you thinking of in your count? I don't get anywhere

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Bruce Momjian
Marc G. Fournier wrote: On Tue, 6 Jul 2004, Peter Eisentraut wrote: Marc G. Fournier wrote: Christopher is correct ... if there was such a thing as an 'end all, be all' replication solution, there wouldn't be a half a dozen different ones out there ... Which ones are you thinking of

[ADMIN] [admin] is there app to catalog email oe6

2004-07-06 Thread Paul Gimpelj
Hi I am hoping posgresql will get more widely used. I have an idea for an application. Consider , after spending months collecting email with information for research there becomes the need to catalog it and store it efficiently. A lot of it is scientific and engineering related. Is there an

Re: [ADMIN] [admin] is there app to catalog email oe6

2004-07-06 Thread Rosser Schwarz
On Tue, 6 Jul 2004 23:30:46 -0400, Paul Gimpelj [EMAIL PROTECTED] wrote: I am hoping posgresql will get more widely used. Aren't we all? I have an idea for an application... I'm not sure this is the most appropriate list for such a discussion. pgsql-admin is for discussions related to