Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-26 Thread Chris Browne
[EMAIL PROTECTED] ("Eric Yum") writes: > I am a developer of one commercial organization. We are going to > develop some applications with PostgreSQL 7.3.3. I learn from some > websites that it cost no charge for developing software with > PostgreSQL in commercial environment. However, I saw the Po

Re: [ADMIN] automatic pg_dumpall

2004-03-26 Thread Victor Sudakov
Kemin Zhou wrote: >> >>If I have to organize an automatic nightly pg_dumpall, how do I handle >>authentication ? I do not want to create a passwordless superuser (or >>trust method in pg_hba.conf), and there is noone to enter the password >>manually. Is there another recipe? >> >>Thanks in advance

Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-26 Thread Doug Quale
Chris Browne <[EMAIL PROTECTED]> writes: > The FSF characterizes the PostgreSQL license as being "an X11 style > license." They felt a need to distinguish between different > variations of licenses that are called 'BSD licenses.' > > The FSF web site then compares various variations on "BSD lice

Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-26 Thread Andrew Sullivan
On Thu, Mar 25, 2004 at 06:04:10PM -0500, Chris Browne wrote: > > The FSF web site then compares various variations on "BSD licenses," > considering that there are some that they deem to be "free" (in their > terms), and that there are others that they deem to _NOT_ be "free" > (again in their ter

Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-26 Thread Radu-Adrian Popescu
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Doug Quale wrote: | Chris Browne <[EMAIL PROTECTED]> writes: | | |>The FSF characterizes the PostgreSQL license as being "an X11 style |>license." They felt a need to distinguish between different |>variations of licenses that are called 'BSD licenses.

Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-26 Thread scott.marlowe
On Fri, 26 Mar 2004, Radu-Adrian Popescu wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Doug Quale wrote: > | Chris Browne <[EMAIL PROTECTED]> writes: > | > | > |>The FSF characterizes the PostgreSQL license as being "an X11 style > |>license." They felt a need to distinguish betwe

[ADMIN] Can I make PostgreSql namespace case-insensitive?

2004-03-26 Thread Ben Kim
Dear List, Is there a way to completely turn off case sensitivity of the names of table, field, sequence, etc.? In our case we used mixed-case names, and the names are unique. They wouldn't collide even if they get turned into lowercase names. Because of interfacing problems with other software

[ADMIN] Raw devices

2004-03-26 Thread Jaime Casanova
Hi, all.   I was thinking about using postgresql and want to know if i can use raw devices with it? if it is possible, how i can configure it? and what are your opinions about postgresql performance on raw devices.       thanx in advance, el_vigiaHelp STOP spam with the new MSN 8 and get 2 months

[ADMIN] postgres copy command very slow.

2004-03-26 Thread Hemapriya
Hi, We have postgresql 7.4.1 running on Mac OS.we are doing a conversion from mysql to postgres. I'm importing the table dumps using copy command in postgres. Copy takes 2 min to import 427938 rows in one table and at the same time it takes more than 2 hrs for 2415768 rows.. no of columns are simi

Re: [ADMIN] automatic pg_dumpall

2004-03-26 Thread Bruno Wolff III
On Thu, Mar 25, 2004 at 04:21:16 +, Victor Sudakov <[EMAIL PROTECTED]> wrote: > Colleagues, > > If I have to organize an automatic nightly pg_dumpall, how do I handle > authentication ? I do not want to create a passwordless superuser (or > trust method in pg_hba.conf), and there is noone to

Re: [Retrieved]RE: [ADMIN] backup and recovery

2004-03-26 Thread Murthy Kambhampaty
I think you can get both benefits of "multi-statement transactions for INSERT dumps" by doing "subset copies" ... without any changes in postgresql! The method I use is developed for handling single table "loads", but is still relatively painless even for database dumps; however, it is limited

Re: [ADMIN] backup and recovery

2004-03-26 Thread Bruno Wolff III
On Mon, Mar 22, 2004 at 09:13:06 -0800, "Mark M. Huber" <[EMAIL PROTECTED]> wrote: > That sounds like a brilliant idea, who do we say it to make it so? It might be better to make this part of pg_restore, rather than pg_dump. > > Mark H > > -Original Message- > From: Naomi Walker [mail

Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-26 Thread Doug Quale
Radu-Adrian Popescu <[EMAIL PROTECTED]> writes: > Doug Quale wrote: > > | The Postgres license is a free software license that is GPL > | compatible. > > Where GPL compatible means (possibly among other things) that I can get > a BSD-licensed Postgresql and turn it into a GPL-licensed MyPostgresq

Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-26 Thread listas
Hi, > > | The Postgres license is a free software license that is GPL > > | compatible. > > > > Where GPL compatible means (possibly among other things) that I can get > > a BSD-licensed Postgresql and turn it into a GPL-licensed MyPostgresql ? > > > No, it means you can distribute the two toget

Re: [ADMIN] postgres copy command very slow.

2004-03-26 Thread Sam Barnett-Cormack
On Fri, 26 Mar 2004, Hemapriya wrote: > Hi, > > We have postgresql 7.4.1 running on Mac OS.we are > doing a conversion from mysql to postgres. I'm > importing the table dumps using copy command in > postgres. Copy takes 2 min to import 427938 rows in > one table and at the same time it takes more

Re: [Retrieved]RE: [ADMIN] backup and recovery

2004-03-26 Thread Murthy Kambhampaty
Title: RE: [Retrieved]RE: [ADMIN] backup and recovery Oops, sorry for the typo in the psql command invocation.  The output of the awk command in Step 3 is piped to /usr/local/pgsql-7.4/bin/psql -d db_quux -f - -Atnq (in the logging alternative it goes to /usr/local/pgsql-7.4/bin/psql -d db_q