[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 comm

[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

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" d

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

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 c

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

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 ne

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

[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 open

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 ad