Thread: removal from list

removal from list

From
Brickley Jeff-RA9607
Date:
How can I get off this email list. 
unregister 'email address'
 
Came back with bogus errors!
 

removal from list

From
Xue-Feng Yang
Date:
 --- Brickley Jeff-RA9607 <Jeff.Brickley@motorola.com>
wrote: > How can I get off this email list.
> unregister 'email address'
>
> Came back with bogus errors!
>
>

______________________________________________________________________
Post your free ad now! http://personals.yahoo.ca

Re: removal from list

From
"Marc G. Fournier"
Date:
what sort of errors?

On Mon, 10 Mar 2003, Xue-Feng Yang wrote:

>  --- Brickley Jeff-RA9607 <Jeff.Brickley@motorola.com>
> wrote: > How can I get off this email list.
> > unregister 'email address'
> >
> > Came back with bogus errors!
> >
> >
>
> ______________________________________________________________________
> Post your free ad now! http://personals.yahoo.ca
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

unregister salvamaine@yahoo.com

From
"Salva Maine"
Date:
 

Re: removal from list

From
"Marc G. Fournier"
Date:
the database (Berkeley DB is used) backend for the majordomo2 lists isn't
the most stable, so we've been having periodic corruption problems where
we have to rebuild it ... the problem is that the rebuild process doesn't
seem to be aware of unsubscribe/set commands that were issued *after* the
initial subscribe, so everyone gets back on ;(

If you are mis-configured, or on the list when you shouldn't be, please
re-unsubscribe and/or issue the set command, to get yourself back to the
format you were in ...


On Thu, 13 Mar 2003, LN Cisneros wrote:

>
> Something weird is going on.  All of a sudden yesterday I started receiving
> individual posts from the list (pgsql-admin) but I'm subscribed to the
> digest (and I still am).  Apparently, others started getting posts even
> though they are not on the list anymore.  This happened one other time to
> me a few weeks ago.  Could this be a majordomo bug or someone affected a
> setting?
>
> Thanks,
>
> Laurette
> (chulat@mail.com)
>
> At 12:00 AM 3/13/2003 -0400, you wrote:
>
> >what sort of errors?
> >
> >On Mon, 10 Mar 2003, Xue-Feng Yang wrote:
> >
> > >  --- Brickley Jeff-RA9607 <Jeff.Brickley@motorola.com>
> > > wrote: > How can I get off this email list.
> > > > unregister 'email address'
> > > >
> > > > Came back with bogus errors!
> > > >
> > > >
> > >
> > > ______________________________________________________________________
> > > Post your free ad now! http://personals.yahoo.ca
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 3: if posting/reading through Usenet, please send an appropriate
> > > subscribe-nomail command to majordomo@postgresql.org so that your
> > > message can get through to the mailing list cleanly
> > >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 4: Don't 'kill -9' the postmaster
>
>
>

Re: removal from list

From
"Chad R. Larson"
Date:
At 12:15 PM 3/13/2003 -0400, Marc G. Fournier wrote:
>the database (Berkeley DB is used) backend for the majordomo2 lists isn't
>the most stable, so we've been having periodic corruption problems where
>we have to rebuild it

Does anyone else see the irony here?

How about using, oh say, PostgreSQL for the database?    :-)



          -crl
--
Chad R. Larson (CRL22)    chad@eldocomp.com
   Eldorado
Computing, Inc.   602-604-3100
      5353 North 16th Street, Suite
400
        Phoenix, Arizona   85016-3228


Re: removal from list

From
"Marc G. Fournier"
Date:
On Thu, 13 Mar 2003, Chad R. Larson wrote:

> At 12:15 PM 3/13/2003 -0400, Marc G. Fournier wrote:
> >the database (Berkeley DB is used) backend for the majordomo2 lists isn't
> >the most stable, so we've been having periodic corruption problems where
> >we have to rebuild it
>
> Does anyone else see the irony here?
>
> How about using, oh say, PostgreSQL for the database?    :-)

Do you volunteer to dive into the Majordomo2 code and extend it to use
PgSQL?  i started, but time didn't allow me to get very far with it, but
if you have the time and wish to do so, I have commit access to the
repository to get the changes in place ...


Re: removal from list

From
Mathieu Arnold
Date:

--Le 13/03/2003 10:52 -0700, Chad R. Larson écrivait :

> At 12:15 PM 3/13/2003 -0400, Marc G. Fournier wrote:
>> the database (Berkeley DB is used) backend for the majordomo2 lists
>> isn't  the most stable, so we've been having periodic corruption
>> problems where  we have to rebuild it
>
> Does anyone else see the irony here?
>
> How about using, oh say, PostgreSQL for the database?    :-)

It's on it way.

--
Mathieu Arnold



Re: removal from list

From
Mathieu Arnold
Date:

--Le 13/03/2003 15:16 -0400, Marc G. Fournier écrivait :

> On Thu, 13 Mar 2003, Chad R. Larson wrote:
>
>> At 12:15 PM 3/13/2003 -0400, Marc G. Fournier wrote:
>> > the database (Berkeley DB is used) backend for the majordomo2 lists
>> > isn't the most stable, so we've been having periodic corruption
>> > problems where we have to rebuild it
>>
>> Does anyone else see the irony here?
>>
>> How about using, oh say, PostgreSQL for the database?    :-)
>
> Do you volunteer to dive into the Majordomo2 code and extend it to use
> PgSQL?  i started, but time didn't allow me to get very far with it, but
> if you have the time and wish to do so, I have commit access to the
> repository to get the changes in place ...

Did you have a look at what I committed to Mj::SimpleDB::SQL ?
I still have a few things to work out, and if you don't use sublists, you
can dive in, it works :)

--
Mathieu Arnold



Re: removal from list

From
"Marc G. Fournier"
Date:
On Thu, 13 Mar 2003, Mathieu Arnold wrote:

>
>
> --Le 13/03/2003 15:16 -0400, Marc G. Fournier écrivait :
>
> > On Thu, 13 Mar 2003, Chad R. Larson wrote:
> >
> >> At 12:15 PM 3/13/2003 -0400, Marc G. Fournier wrote:
> >> > the database (Berkeley DB is used) backend for the majordomo2 lists
> >> > isn't the most stable, so we've been having periodic corruption
> >> > problems where we have to rebuild it
> >>
> >> Does anyone else see the irony here?
> >>
> >> How about using, oh say, PostgreSQL for the database?    :-)
> >
> > Do you volunteer to dive into the Majordomo2 code and extend it to use
> > PgSQL?  i started, but time didn't allow me to get very far with it, but
> > if you have the time and wish to do so, I have commit access to the
> > repository to get the changes in place ...
>
> Did you have a look at what I committed to Mj::SimpleDB::SQL ?
> I still have a few things to work out, and if you don't use sublists, you
> can dive in, it works :)

You feel confident enough for me to use it on these lists? :)


pg_dumpall

From
"Christian Frabel"
Date:
After a pg_dumpall > alldata how can I to restore?



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/2003

Re: removal from list

From
Mathieu Arnold
Date:

--Le 13/03/2003 22:17 -0400, Marc G. Fournier écrivait :

> On Thu, 13 Mar 2003, Mathieu Arnold wrote:
>> --Le 13/03/2003 15:16 -0400, Marc G. Fournier écrivait :
>> > Do you volunteer to dive into the Majordomo2 code and extend it to use
>> > PgSQL?  i started, but time didn't allow me to get very far with it,
>> > but if you have the time and wish to do so, I have commit access to the
>> > repository to get the changes in place ...
>> Did you have a look at what I committed to Mj::SimpleDB::SQL ?
>> I still have a few things to work out, and if you don't use sublists, you
>> can dive in, it works :)
>
> You feel confident enough for me to use it on these lists? :)

Well, as I said, it works perfectly well on my dev box if you don't use
sublist, because Mj2 use hard coded opendirs to find out if they exists.
(which is not always "the right way to do it" of course.) This does not
count the Xowners GLOBAL sublists which is not tested because it should
always exist :)
As I say, it works, but I would not want to be the end of postgresql.org
mailing lists in case there is a but somewhere :)

--
Mathieu Arnold



Re: pg_dumpall

From
Jean-Michel Chabanne
Date:
Christian Frabel wrote:

>After a pg_dumpall > alldata how can I to restore?
>
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/2003
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>
>
>
psql -f alldata template1 postgres

--
Jean-Michel Chabanne
77450 MONTRY (FRANCE)
48" 54' N - 2" 49' E
Powered by Linux



Clustering Postgres

From
Kris Kiger
Date:
Has anyone heard of clusgres or, better yet, had any experience with it?
 I came across it while searching for active clustering projects.

http://www.linuxlabs.com/clusgres.html

Thanks in advance for the info!

Kris


Re: Clustering Postgres

From
Robert Treat
Date:
On Thu, 2004-05-20 at 14:30, Kris Kiger wrote:
> Has anyone heard of clusgres or, better yet, had any experience with it?
>  I came across it while searching for active clustering projects.
>
> http://www.linuxlabs.com/clusgres.html
>
> Thanks in advance for the info!
>

I have heard of it but I've not heard of any reports on these lists of
how well it works. If you (or anyone else) gives it a spin please try to
post an account to the list and/or if you send me the info it could
probably make its way on to techdocs.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


Re: Clustering Postgres

From
Greg Spiegelberg
Date:
Robert,

I am currently evaluating PolyServe Matrix Server which is a clustering
solution including a clustered file system (mounted read-write
everywhere).

Anything special anyone wants to know?  I'm using PostgreSQL 7.4.2 in
a Linux cluster.

Greg


Robert Treat wrote:
> On Thu, 2004-05-20 at 14:30, Kris Kiger wrote:
>
>>Has anyone heard of clusgres or, better yet, had any experience with it?
>> I came across it while searching for active clustering projects.
>>
>>http://www.linuxlabs.com/clusgres.html
>>
>>Thanks in advance for the info!
>>
>
>
> I have heard of it but I've not heard of any reports on these lists of
> how well it works. If you (or anyone else) gives it a spin please try to
> post an account to the list and/or if you send me the info it could
> probably make its way on to techdocs.
>
> Robert Treat


--
Greg Spiegelberg
  Product Development Manager
  Cranel, Incorporated.
  Phone: 614.318.4314
  Fax:   614.431.8388
  Email: gspiegelberg@cranel.com
Technology. Integrity. Focus. V-Solve!


Re: Clustering Postgres

From
Ericson Smith
Date:
Do you mean that you are actually testing this product now? If so,
what's the hardware configuration (nodes, storage server, interconnects)
that you are using?

Warmest regards,
Ericson Smith
Tracking Specialist/DBA
+-----------------------+-----------------------------------------+
| http://www.did-it.com | "3 Years ago I was worth $5M on paper!" |
| eric@did-it.com       | "Sweet! Can I have fries with that?"    |
| 516-255-0500          |                          - Tom Tomorrow |
+-----------------------+-----------------------------------------+



Greg Spiegelberg wrote:

> Robert,
>
> I am currently evaluating PolyServe Matrix Server which is a clustering
> solution including a clustered file system (mounted read-write
> everywhere).
>
> Anything special anyone wants to know?  I'm using PostgreSQL 7.4.2 in
> a Linux cluster.
>
> Greg
>
>
> Robert Treat wrote:
>
>> On Thu, 2004-05-20 at 14:30, Kris Kiger wrote:
>>
>>> Has anyone heard of clusgres or, better yet, had any experience with
>>> it? I came across it while searching for active clustering projects.
>>>
>>> http://www.linuxlabs.com/clusgres.html
>>>
>>> Thanks in advance for the info!
>>>
>>
>>
>> I have heard of it but I've not heard of any reports on these lists of
>> how well it works. If you (or anyone else) gives it a spin please try to
>> post an account to the list and/or if you send me the info it could
>> probably make its way on to techdocs.
>> Robert Treat
>
>
>

Attachment

Re: Clustering Postgres

From
Greg Spiegelberg
Date:
2 dual PIII-1.4GHz Linux RedHat 3.0 servers each with onboard AIC7xxx
and 2 U160 drives (mirrored), 2 GB of ECC memory, 2 onboard Intel Ether
Pro 100Mbps type NIC's, 1 Qlogic 2310 HBA on a 1GBs SAN using a Candera
510 storage cluster with Xyratex SATA on the backend configured with 1+0
LUN's.  It will be using a private network and a small disk on the SAN
as the interconnect.

Once I have it running and I've run the necessary tests for myself
I could run a few tests for anyone else who is interested.  Deadline
is June 18th when either I scrap it and try a different solution or
we have to buy in which case I'll need it for our production databases.
Below is the config I intend to use for PostgreSQL 7.4.2.

Greg


PostgreSQL 7.4.2 config & compile
configure \
   --prefix=/psfs1/apps/pgsql-7.4.2 \
   --enable-thread-safety \
   --enable-largefiles \
   --enable-odbc \
   --enable-multibyte \
   --enable-shared \
   --enable-syslog \
   --with-perl \
   --with-CXX \
   --with-pam \
   --with-maxbackends=128 \
   --with-tcl \
   --with-readline \
   --with-zlib
make -j 2 CPPFLAGS="-O3 -DALLOW_ABSOLUTE_DBPATHS -DLOCK_DEBUG" all



Ericson Smith wrote:
> Do you mean that you are actually testing this product now? If so,
> what's the hardware configuration (nodes, storage server, interconnects)
> that you are using?
>
> Warmest regards, Ericson Smith
> Tracking Specialist/DBA
> +-----------------------+-----------------------------------------+
> | http://www.did-it.com | "3 Years ago I was worth $5M on paper!" |
> | eric@did-it.com       | "Sweet! Can I have fries with that?"    |
> | 516-255-0500          |                          - Tom Tomorrow |
> +-----------------------+-----------------------------------------+
>
>
> Greg Spiegelberg wrote:
>
>> Robert,
>>
>> I am currently evaluating PolyServe Matrix Server which is a clustering
>> solution including a clustered file system (mounted read-write
>> everywhere).
>>
>> Anything special anyone wants to know?  I'm using PostgreSQL 7.4.2 in
>> a Linux cluster.
>>
>> Greg
>>
>>
>> Robert Treat wrote:
>>
>>> On Thu, 2004-05-20 at 14:30, Kris Kiger wrote:
>>>
>>>> Has anyone heard of clusgres or, better yet, had any experience with
>>>> it? I came across it while searching for active clustering projects.
>>>>
>>>> http://www.linuxlabs.com/clusgres.html
>>>>
>>>> Thanks in advance for the info!
>>>>
>>>
>>>
>>> I have heard of it but I've not heard of any reports on these lists of
>>> how well it works. If you (or anyone else) gives it a spin please try to
>>> post an account to the list and/or if you send me the info it could
>>> probably make its way on to techdocs.
>>> Robert Treat
>>
>>
>>
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


--
Greg Spiegelberg
  Product Development Manager
  Cranel, Incorporated.
  Phone: 614.318.4314
  Fax:   614.431.8388
  Email: gspiegelberg@cranel.com
Technology. Integrity. Focus. V-Solve!


Re: Clustering Postgres

From
Ericson Smith
Date:
We'd be very interested in the performance, especially with the disk
being used as in interconnect (I assume that that is being used to
simulate global shared memory?)

We did have a talk with the folks over at http://www.linuxlabs.com/clustgres

They were honest enough to say that even with the Dolphon interconnects, that writing would be slower than usual. We
havenot made a complete decision on that yet, but are still looking at alternatives. 

It seems that Clustres might be a good solution. They use a SAN, the Dolphin interconnects, and multiple diskless
nodes.In theory I am sure it works, but this is one of the chicken/egg problems where we want to see it in general use
firstbefore committing :-) 

- Ericson




Greg Spiegelberg wrote:

> 2 dual PIII-1.4GHz Linux RedHat 3.0 servers each with onboard AIC7xxx
> and 2 U160 drives (mirrored), 2 GB of ECC memory, 2 onboard Intel Ether
> Pro 100Mbps type NIC's, 1 Qlogic 2310 HBA on a 1GBs SAN using a Candera
> 510 storage cluster with Xyratex SATA on the backend configured with 1+0
> LUN's.  It will be using a private network and a small disk on the SAN
> as the interconnect.
>
> Once I have it running and I've run the necessary tests for myself
> I could run a few tests for anyone else who is interested.  Deadline
> is June 18th when either I scrap it and try a different solution or
> we have to buy in which case I'll need it for our production databases.
> Below is the config I intend to use for PostgreSQL 7.4.2.
>
> Greg
>
>
> PostgreSQL 7.4.2 config & compile
> configure \
>   --prefix=/psfs1/apps/pgsql-7.4.2 \
>   --enable-thread-safety \
>   --enable-largefiles \
>   --enable-odbc \
>   --enable-multibyte \
>   --enable-shared \
>   --enable-syslog \
>   --with-perl \
>   --with-CXX \
>   --with-pam \
>   --with-maxbackends=128 \
>   --with-tcl \
>   --with-readline \
>   --with-zlib
> make -j 2 CPPFLAGS="-O3 -DALLOW_ABSOLUTE_DBPATHS -DLOCK_DEBUG" all
>
>
>
> Ericson Smith wrote:
>
>> Do you mean that you are actually testing this product now? If so,
>> what's the hardware configuration (nodes, storage server,
>> interconnects) that you are using?
>>
>> Warmest regards, Ericson Smith
>> Tracking Specialist/DBA
>> +-----------------------+-----------------------------------------+
>> | http://www.did-it.com | "3 Years ago I was worth $5M on paper!" |
>> | eric@did-it.com       | "Sweet! Can I have fries with that?"    |
>> | 516-255-0500          |                          - Tom Tomorrow |
>> +-----------------------+-----------------------------------------+
>>
>>
>> Greg Spiegelberg wrote:
>>
>>> Robert,
>>>
>>> I am currently evaluating PolyServe Matrix Server which is a clustering
>>> solution including a clustered file system (mounted read-write
>>> everywhere).
>>>
>>> Anything special anyone wants to know?  I'm using PostgreSQL 7.4.2 in
>>> a Linux cluster.
>>>
>>> Greg
>>>
>>>
>>> Robert Treat wrote:
>>>
>>>> On Thu, 2004-05-20 at 14:30, Kris Kiger wrote:
>>>>
>>>>> Has anyone heard of clusgres or, better yet, had any experience
>>>>> with it? I came across it while searching for active clustering
>>>>> projects.
>>>>>
>>>>> http://www.linuxlabs.com/clusgres.html
>>>>>
>>>>> Thanks in advance for the info!
>>>>>
>>>>
>>>>
>>>> I have heard of it but I've not heard of any reports on these lists of
>>>> how well it works. If you (or anyone else) gives it a spin please
>>>> try to
>>>> post an account to the list and/or if you send me the info it could
>>>> probably make its way on to techdocs.
>>>> Robert Treat
>>>
>>>
>>>
>>>
>>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Don't 'kill -9' the postmaster
>
>
>

Attachment

Re: Clustering Postgres

From
Robert Treat
Date:
Some basics on how easy it is to install/configure and some before/after type
benchmarks showing how it affected performance.  Perferrably you could
measure simple vs. complex queries as well as update vs. insert performance.
If you're really ambitious you could try running one of the tpc style
benchmarks on the system, check the archives or the osdl site for more info
on getting these up and running.

Robert Treat

On Monday 24 May 2004 09:59, Greg Spiegelberg wrote:
> Robert,
>
> I am currently evaluating PolyServe Matrix Server which is a clustering
> solution including a clustered file system (mounted read-write
> everywhere).
>
> Anything special anyone wants to know?  I'm using PostgreSQL 7.4.2 in
> a Linux cluster.
>
> Greg
>
> Robert Treat wrote:
> > On Thu, 2004-05-20 at 14:30, Kris Kiger wrote:
> >>Has anyone heard of clusgres or, better yet, had any experience with it?
> >> I came across it while searching for active clustering projects.
> >>
> >>http://www.linuxlabs.com/clusgres.html
> >>
> >>Thanks in advance for the info!
> >
> > I have heard of it but I've not heard of any reports on these lists of
> > how well it works. If you (or anyone else) gives it a spin please try to
> > post an account to the list and/or if you send me the info it could
> > probably make its way on to techdocs.
> >
> > Robert Treat

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Re: Clustering Postgres

From
Greg Spiegelberg
Date:
Here's the basics basically because I ran out of time and budget to
actually purchase it but here's what I know.

1 day to install.  Installed RedHat ES 3.0 from scratch, and the
PolyServe process took perhaps 1.5 hours to install including a
kernel build and system reboot.  Roughly 2 hours into PolyServe I
had my first psfs (shared cluster) partition setup on my 1Gb SAN.

Just doing a basic dd to write 1.5GB and 5GB to an ext3 on the
same hardware produced roughly 115 MB/s and 107 MB/s respectively.
It's my understand that PostgreSQL won't create files largers than
2GB though.

Doing the same tests on the PolyServe file system (psfs) accomplished
the tasks in 117 MB/s and 109 MB/s, just slightly faster.

If you're familiar with Veritas Cluster Server it operates similiar
to it though I didn't have a chance to fully test it.

Given the budget I'd definitely take another look at it.

Greg



Robert Treat wrote:
> Some basics on how easy it is to install/configure and some before/after type
> benchmarks showing how it affected performance.  Perferrably you could
> measure simple vs. complex queries as well as update vs. insert performance.
> If you're really ambitious you could try running one of the tpc style
> benchmarks on the system, check the archives or the osdl site for more info
> on getting these up and running.
>
> Robert Treat
>
> On Monday 24 May 2004 09:59, Greg Spiegelberg wrote:
>
>>Robert,
>>
>>I am currently evaluating PolyServe Matrix Server which is a clustering
>>solution including a clustered file system (mounted read-write
>>everywhere).
>>
>>Anything special anyone wants to know?  I'm using PostgreSQL 7.4.2 in
>>a Linux cluster.
>>
>>Greg
>>
>>Robert Treat wrote:
>>
>>>On Thu, 2004-05-20 at 14:30, Kris Kiger wrote:
>>>
>>>>Has anyone heard of clusgres or, better yet, had any experience with it?
>>>>I came across it while searching for active clustering projects.
>>>>
>>>>http://www.linuxlabs.com/clusgres.html
>>>>
>>>>Thanks in advance for the info!
>>>
>>>I have heard of it but I've not heard of any reports on these lists of
>>>how well it works. If you (or anyone else) gives it a spin please try to
>>>post an account to the list and/or if you send me the info it could
>>>probably make its way on to techdocs.
>>>
>>>Robert Treat
>
>


--
Greg Spiegelberg
  Product Development Manager
  Cranel, Incorporated.
  Phone: 614.318.4314
  Fax:   614.431.8388
  Email: gspiegelberg@cranel.com
Technology. Integrity. Focus. V-Solve!