Re: New Live CD needed

Hello,

We are going to need a new Live CD. I was hoping that we could have one
with a 8.3Beta but... the only way that is going to happen is if we get
a Beta (or Alpha) within 3 weeks.

Any chance of that?

If not, we need a new Live CD with 8.2.4. We need this, before the end
of June please. By June 25th if possible.

Sincerely,

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

On Fri, 01 Jun 2007 10:28:26 -0700 Joshua D. Drake wrote:

Hello,

> We are going to need a new Live CD. I was hoping that we could have one
> with a 8.3Beta but... the only way that is going to happen is if we get
> a Beta (or Alpha) within 3 weeks.
>
> Any chance of that?
>
> If not, we need a new Live CD with 8.2.4. We need this, before the end
> of June please. By June 25th if possible.

I don't know the exact intention, but is it possible to get some more
for the european group(s)?

Kind regards

--
Andreas 'ads' Scherbaum
Failure is not an option. It comes bundled with your Microsoft product.
(Ferenc Mantfeld)

Andreas 'ads' Scherbaum wrote:
> On Fri, 01 Jun 2007 10:28:26 -0700 Joshua D. Drake wrote:
>
> Hello,
>
>> We are going to need a new Live CD. I was hoping that we could have one
>> with a 8.3Beta but... the only way that is going to happen is if we get
>> a Beta (or Alpha) within 3 weeks.
>>
>> Any chance of that?
>>
>> If not, we need a new Live CD with 8.2.4. We need this, before the end
>> of June please. By June 25th if possible.
>
> I don't know the exact intention, but is it possible to get some more
> for the european group(s)?

I don't see why not.

>
>
> Kind regards
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

Hi Guys,

What are your needs?

What are your current deadlines?

Robert

On Friday 1 June 2007 17:41, Andreas 'ads' Scherbaum wrote:
> On Fri, 01 Jun 2007 10:28:26 -0700 Joshua D. Drake wrote:
>
> Hello,
>
> > We are going to need a new Live CD. I was hoping that we could have one
> > with a 8.3Beta but... the only way that is going to happen is if we get
> > a Beta (or Alpha) within 3 weeks.
> >
> > Any chance of that?
> >
> > If not, we need a new Live CD with 8.2.4. We need this, before the end
> > of June please. By June 25th if possible.
>
> I don't know the exact intention, but is it possible to get some more
> for the european group(s)?
>
>
> Kind regards
>

Robert Bernier wrote:
> Hi Guys,
>
> What are your needs?
>
> What are your current deadlines?
>
>>> If not, we need a new Live CD with 8.2.4. We need this, before the end
>>> of June please. By June 25th if possible.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Joshua D. Drake

>> I don't know the exact intention, but is it possible to get some more
>> for the european group(s)?
>>
>>
>> Kind regards
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

Robert,

> What are your needs?

Can we add the PostgreSQL Business Case document to the CD?

Also, we really need to get an interesting sample database. When I was at
SCALE I think Daniel volunteered one ... need to bug him about it.

--
Josh Berkus
PostgreSQL @ Sun
San Francisco

> We are going to need a new Live CD.

When I think LiveCD, I think of a *nix distro that boots from a CD to a
fully usable operating system and doesn't touch the hard drive. What
does LiveCD mean in this Postgres context? I didn't see a whole lot on
the pgfoundry/livecd page, just

'This project aims to build the PostgreSQL Live CD (iso image), share
tools and HOWTOs, and make them "up to date".'

In lieu of making a coaster, does this mean that it's a LiveCD distro of
Nix with Postgres et al installed?

Thanks,

Kevin

Kevin Hunter wrote:
>> We are going to need a new Live CD.
>
> When I think LiveCD, I think of a *nix distro that boots from a CD to a
> fully usable operating system and doesn't touch the hard drive. What
> does LiveCD mean in this Postgres context? I didn't see a whole lot on
> the pgfoundry/livecd page, just

Exactly that, except that we include a fully functioning postgresql with
pgadmin etc... already configured.

>
> 'This project aims to build the PostgreSQL Live CD (iso image), share
> tools and HOWTOs, and make them "up to date".'
>
> In lieu of making a coaster, does this mean that it's a LiveCD distro of
> Nix with Postgres et al installed?

Yes.

>
> Thanks,
>
> Kevin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

Josh Berkus wrote:
> Robert,
>
>> What are your needs?
>
> Can we add the PostgreSQL Business Case document to the CD?
>
> Also, we really need to get an interesting sample database. When I was at
> SCALE I think Daniel volunteered one ... need to bug him about it.

Not having looked at the livecd itself, but adding pagila for example
shouldn't be too hard, no?

//Magnus

Hello all,

On Fri, 1 Jun 2007 23:41:58 +0200 Andreas 'ads' Scherbaum wrote:

could everybody please stop Ccing me? I'm on the list.

Thank you

--
Andreas 'ads' Scherbaum
Failure is not an option. It comes bundled with your Microsoft product.
(Ferenc Mantfeld)

Andreas 'ads' Scherbaum wrote:
> Hello all,
>
> On Fri, 1 Jun 2007 23:41:58 +0200 Andreas 'ads' Scherbaum wrote:
>
> could everybody please stop Ccing me? I'm on the list.

There's a setting in majordomo called "eliminatecc". You likely want to
set that one if you haven't already, and it shouldn't make a difference
if you're in CC or not. (Not sure which is the default)

Including the senders in the CC row is more or less standard practice on
these lists AFAIK, and has been for many years. Let's you easily filter
out which discussions you're actively a part in.

//Magnus

Ads,

>> I don't know the exact intention, but is it possible to get some more
>> for the european group(s)?
>
> I don't see why not.

We need two things:
1. Quantities and Dates for the CDs you need.
2. You to figure out deal with tax issues

(2) is difficult; we've found that the EU taxes boxes of CDs we ship,
even if we are a non-profit and giving them away for free. So, you need
to figure out how the EU organization can pay the tax or how to avoid
it, and whether or not the tax makes shipping CDs from the US completely
uneconomical.

--Josh Berkus

Hello,

On Sun, 03 Jun 2007 11:53:53 -0700 Josh Berkus wrote:

> >> I don't know the exact intention, but is it possible to get some more
> >> for the european group(s)?
> >
> > I don't see why not.
>
> We need two things:
> 1. Quantities and Dates for the CDs you need.

First date would be PGDay in Italy, i think.

> 2. You to figure out deal with tax issues
>
> (2) is difficult; we've found that the EU taxes boxes of CDs we ship,
> even if we are a non-profit and giving them away for free. So, you need
> to figure out how the EU organization can pay the tax or how to avoid
> it, and whether or not the tax makes shipping CDs from the US completely
> uneconomical.

Hmm, since i never got anything sent from the US, i don't know, how to
avoid this taxes. But i understand, that sending 100 or more CDs may
not count as a giveaway. Anyway, i will start looking into this problem.

Hmm, how about finding a company in europe, who will press some hundred
CDs? Anybody has an address and a price for this? Remember additionaly
labels.

Kind regards

--
Andreas 'ads' Scherbaum
Failure is not an option. It comes bundled with your Microsoft product.
(Ferenc Mantfeld)

Ciao guys,
> First date would be PGDay in Italy, i think.
>
Yep, I agree.
> Hmm, how about finding a company in europe, who will press some hundred
> CDs? Anybody has an address and a price for this? Remember additionaly
> labels.
>
I have almost convinced my boss at the City Council of Prato to print at
least 100 CDs of a live distribution. I am in touch with Robert for PG
Live. Also I have been told there is an Italian guys who's prepared
another live distribution, more oriented towards GIS purposes - but I
can't remember the name right now. Some guys of the Italian community
are evaluating that as well.

I need to get informed about taxes. There is a tax in Italy called SIAE
that we need to pay. However I am not sure if we have to even if the
distributed software is open-source. Will find out in the next few days.

Thanks.

Ciao,
Gabriele

--
Gabriele Bartolini: Web Programmer, IWA/HWG Member
Current Location: Prato, Tuscany, Italy
gabriele(dot)bartolini(at)gmail(dot)com | www.gabrielebartolini.it
"If I had been born ugly, you would never have heard of Pelé", George Best

Hi Josh,

On Friday 1 June 2007 23:40, Josh Berkus wrote:
> Can we add the PostgreSQL Business Case document to the CD?

What's the URL?

> Also, we really need to get an interesting sample database. When I was at
> SCALE I think Daniel volunteered one ... need to bug him about it.

Any movement on this?

Robert

Dear All
could everybody please stop Ccing me? I'm on the list.

Kindly Regards
Siva
----- Original Message -----
From: "Robert Bernier" <robert(dot)bernier5(at)sympatico(dot)ca>
To: <pgsql-advocacy(at)postgresql(dot)org>
Sent: 06/06/2007 9:45 PM
Subject: Re: [pgsql-advocacy] New Live CD needed

> Hi Josh,
>
> On Friday 1 June 2007 23:40, Josh Berkus wrote:
>> Can we add the PostgreSQL Business Case document to the CD?
>
> What's the URL?
>
>> Also, we really need to get an interesting sample database. When I was
>> at
>> SCALE I think Daniel volunteered one ... need to bug him about it.
>
> Any movement on this?
>
> Robert
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

Siva wrote:
> Dear All
> could everybody please stop Ccing me? I'm on the list.

We should put this in the FAQ.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

I would (also) like to be completely removed from this list. Could Someone
tell me how?

Thank You.

-----Original Message-----
From: pgsql-advocacy-owner(at)postgresql(dot)org
[mailto:pgsql-advocacy-owner(at)postgresql(dot)org] On Behalf Of Alvaro Herrera
Sent: Wednesday, June 06, 2007 4:24 PM
To: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [pgsql-advocacy] New Live CD needed

Siva wrote:
> Dear All
> could everybody please stop Ccing me? I'm on the list.

We should put this in the FAQ.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On 06/06/07, Chanko family <cmchanko(at)wowway(dot)com> wrote:
> I would (also) like to be completely removed from this list. Could Someone
> tell me how?
>
> Thank You.

Hi:

Included in the headers of every email in this list is the following:

List-Unsubscribe: <mailto:majordomo(at)postgresql(dot)org?body=unsub%20pgsql-advocacy>

Most email clients will let you double-click that mailto: link to
create an email message addressed to majordomo(at)postgresql(dot)org with a
message body of:

unsub pgsql-advocacy

Hope this helps you get unsubscribed.

--
Dan Scott
Laurentian University

Joshua D. Drake wrote:
> Robert Bernier wrote:
>> Hi Guys,
>>
>> What are your needs?
>>
>> What are your current deadlines?
>>
>>>> If not, we need a new Live CD with 8.2.4. We need this, before the
>>>> end of June please. By June 25th if possible.
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Robert can we count on your for this?

Joshua D. Drake

>
> Joshua D. Drake
>
>
>
>>> I don't know the exact intention, but is it possible to get some more
>>> for the european group(s)?
>>>
>>>
>>> Kind regards
>>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>>
>
>

On Wednesday 6 June 2007 19:32, Joshua D. Drake wrote:
> >>>> If not, we need a new Live CD with 8.2.4. We need this, before the
> >>>> end of June please. By June 25th if possible.
>
> Robert can we count on your for this?

yes

Guys,

I've updated the live CD to pg_live-8.2.4.1.

I will upload the iso image after getting feedback on what else should be on pg_live, it's a time constraint issue.

For the most part no new documentation has been added and I'm still using the same version of Xubuntu that I used the last time. I'll add the Italian translation of the PostgreSQL reference documentation as soon as I get it sent to me (the French translation is already there).

As per request, I've added the pagila database although I'm not clear where I can find the document "The Business Case for PostgreSQL".

Joshua, any chance of getting a working version of plphp?

FYI: it is possible to change pg over to 8.3 if it comes out fast enough.

Comments?

Robert

Hello,

On Fri, 8 Jun 2007 09:05:54 -0400 Robert Bernier wrote:

> FYI: it is possible to change pg over to 8.3 if it comes out fast enough.
>
> Comments?

Sounds nice. If you need a betatester, just let me know.

Kind regards

--
Andreas 'ads' Scherbaum
Failure is not an option. It comes bundled with your Microsoft product.
(Ferenc Mantfeld)

On Jun 1, 2007, at 10:40 PM, Josh Berkus wrote:
> Robert,
>
>> What are your needs?
>
> Can we add the PostgreSQL Business Case document to the CD?
>
> Also, we really need to get an interesting sample database. When I
> was at
> SCALE I think Daniel volunteered one ... need to bug him about it.

Yeah, that'd be useful for a number of things; certainly for
classroom training.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

Hello all,

On Mon, 4 Jun 2007 00:34:44 +0200 Andreas 'ads' Scherbaum wrote:

> > 2. You to figure out deal with tax issues
> >
> > (2) is difficult; we've found that the EU taxes boxes of CDs we ship,
> > even if we are a non-profit and giving them away for free. So, you need
> > to figure out how the EU organization can pay the tax or how to avoid
> > it, and whether or not the tax makes shipping CDs from the US completely
> > uneconomical.
>
> Hmm, since i never got anything sent from the US, i don't know, how to
> avoid this taxes. But i understand, that sending 100 or more CDs may
> not count as a giveaway. Anyway, i will start looking into this problem.

Finally, after ~10 days, i got an answer from our customs office:

Everything below 22 Euro is tax-free.

CD-ROMs with computer programs on it (customs data number:
8523 4045 00 0): import sales tax: 19%.
Third country duty rate: free.
Then they sent a short help for calculation:

invoice amount, in Euro, from seller/sender
+ costs (includes postage, shipping, insurance)
= customs value * duty rate = duty
+ duty
= import turnover tax value * import turnover tax rate
= import sales tax

The german description contains words i have never heard of.
Hope, my translation matches more or less. Since in the customs info
office nobody is picking up the phone, i'm not really sure, but "invoice
amount" should match the costs of the CD-ROMs + press + labeling.

For native german speakers here is the original text:
----- cut -----
Rechnungsbetrag umgerechnet in Euro, ab Verkäufer /Versender
+ Kosten (insbesondere Porto/Fracht/Versicherung)
= Zollwert * Zollsatz= Zoll
+ Zoll
= Einfuhrumsatzsteuerwert * Einfuhrumsatzsteuersatz
= Einfuhrumsatzsteuer
----- cut -----

Maybe we need this informations sometimes in the future.

Kind regards

--
Andreas 'ads' Scherbaum
German PostgreSQL User Group