Re: [ADMIN] replicating postgresql database to ms-sql database

2007-07-06 Thread Kenneth Marshall
Mary, I believe that you can use FreeTDS with dblink to set up your on replication process. I agree with you that having both databases be PostgreSQL would be preferrable. Ken On Fri, Jul 06, 2007 at 10:48:48AM -0700, Mary Anderson wrote: > Hi list, >I have been asked if it is possible to as

Re: [ADMIN] replicating postgresql database to ms-sql database

2007-07-06 Thread Kevin Grittner
>>> On Fri, Jul 6, 2007 at 12:48 PM, in message <[EMAIL PROTECTED]>, Mary Anderson <[EMAIL PROTECTED]> wrote: > > I have been asked if it is possible to asynchronously replicate a > postgresql database to ms-sql. My answer is yes, provided postgresql > ORM features aren't used in the desig

Re: [ADMIN] Performance benchmarking

2007-07-06 Thread Steve Crawford
lai yoke hman wrote: > > Hello, > I am an undergraduate of a university in Malaysia, if I want to do > performance benchmark on PostgreSQL 8, do I need to get a license agreement > or some sort of thing? > Thanks. Your license, provided without charge, is here: http://www.postgresql.org/about/l

[ADMIN] replicating postgresql database to ms-sql database

2007-07-06 Thread Mary Anderson
Hi list, I have been asked if it is possible to asynchronously replicate a postgresql database to ms-sql. My answer is yes, provided postgresql ORM features aren't used in the design of the database. One does an ascii dump of the tables and then bulk loads them into MSSQL. The database i

Re: [ADMIN] Performance benchmarking

2007-07-06 Thread Vishal Arora
I think you have already got your answer... NO you do not need any kind of license to use PostgreSQL as it an Open Source. You can do anything you want to do. - Vishal From: lai yoke hman <[EMAIL PROTECTED]> To: Subject: [ADMIN] Performance benchmarking Date: Fri, 6 Jul 2007 01:02:12 +

Re: [ADMIN] More than one pg_database entry for database

2007-07-06 Thread Tom Lane
"James Wilford" <[EMAIL PROTECTED]> writes: > I'd like to try the dump and reload - the only problem is that I can't > use pg_dump because of the error. And I can't rename the entry in > pg_database because my update statement won't match any rows. You can't change the dead entry, but it should wo

Re: [ADMIN] More than one pg_database entry for database

2007-07-06 Thread James Wilford
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: 05 July 2007 19:17 To: Alvaro Herrera Cc: James Wilford; pgsql-admin@postgresql.org Subject: Re: [ADMIN] More than one pg_database entry for database Alvaro Herrera <[EMAIL PROTECTED]> writ

[ADMIN] Performance benchmarking

2007-07-06 Thread lai yoke hman
Hello, I am an undergraduate of a university in Malaysia, if I want to do performance benchmark on PostgreSQL 8, do I need to get a license agreement or some sort of thing? Thanks. _ Did you know you can now customize your mailbox w