Re: [GENERAL] Call for design: PostgreSQL mugs

On 9/9/2013 6:42 PM, Gavin Flower wrote: More people have heardof Linux compared to BSD, and the Linux market share is growing faster than BSD's! if you rate things by market share, then you'd compare it with MS Windows, or iOS. lets not go there. -- john r pierce

Re: [GENERAL] Streaming replication slave crash

On Mon, 2013-09-09 at 13:04 -0700, Mahlon E. Smith wrote: > After some wild googlin' "research", I saw the index visibility map fix > for 9.2.1. We did pg_upgrade in-between versions, but just to be sure I > wasn't somehow carrying corrupt data across versions (?), I went ahead > and VACUUMed eve

Re: [GENERAL] Call for design: PostgreSQL mugs

On Monday, September 9, 2013, Gavin Flower wrote: > > On 10/09/13 13:21, John R Pierce wrote: >> >> On 9/9/2013 5:39 PM, Sam Hahn wrote: >>> >>> How about >>> "Postgres -the Linux of Data"  (or) >>> "The Linux of DBs" >> >> >> >> ugh no.    if anything, Mysql is the Linux of data. PostgreSQL is

Re: [GENERAL] Call for design: PostgreSQL mugs

On 10/09/13 13:21, John R Pierce wrote: On 9/9/2013 5:39 PM, Sam Hahn wrote: How about * "Postgres -the Linux of Data" (or) * "The Linux of DBs" ugh no.if anything, Mysql is the Linux of data. PostgreSQL is more like the BSD of Data. -- john r pierce

Re: [GENERAL] Call for design: PostgreSQL mugs

On 9/9/2013 5:39 PM, Sam Hahn wrote: How about * "Postgres -the Linux of Data" (or) * "The Linux of DBs" ugh no.if anything, Mysql is the Linux of data. PostgreSQL is more like the BSD of Data. -- john r pierce 37N 122W somewhere on the

Re: [GENERAL] PostgreSQL and cgroup

Now let me reply it myself. When I changed memory.limit_in_bytes=300M， it worked. memeory before sql statment execution and after sql statement execution is: [postgres@cent6 Desktop]$ free -m total used free sharedbuffers cached Mem: 2006537

Re: [GENERAL] Call for design: PostgreSQL mugs

How about * "Postgres -the Linux of Data" (or) * "The Linux of DBs" ?? On 9/8/2013 4:51 PM, Bret Stern wrote: > PostgreSQL - (the worlds database) > > >

Re: [GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?

On Mon, Sep 9, 2013 at 4:00 PM, Chris Curvey wrote: > But I'm having troubles with the 9.2 server crashing when I'm restoring > the dump. I'm using the 9.2 version of pg_dump. I've tried restoring a > custom-format dump with pg_restore, and I've tried restoring a text-format > dump with pqsl, a

Re: [GENERAL] Call for design: PostgreSQL mugs

I like Basil's idea, and I would add some sort of a "catchy" or similar line at the top (but inside) of the blue bar with something like the following: "I did nothing today, and still got paid, thanks to PG :-)" Cheers, cyclix On 09/10/2013 07:07 AM, Basil Bourque wrote: > Other folks posted m

Re: [GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?

On 9/9/2013 4:53 PM, John R Pierce wrote: On 9/9/2013 7:00 AM, Chris Curvey wrote: any idea where I go from here? don't develop on a newer version of the database than you are deploying on. *maybe* you can use the pgdump from 8.4 to connect to and dump the 9.2 database, but the 9.2 dump is

Re: [GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?

On 9/9/2013 7:00 AM, Chris Curvey wrote: any idea where I go from here? don't develop on a newer version of the database than you are deploying on. *maybe* you can use the pgdump from 8.4 to connect to and dump the 9.2 database, but the 9.2 dump is NOT guaranteed to generate 8.4 compatible S

Re: [GENERAL] Migrate from mysql

On 09/09/2013 03:15 PM, Florent THOMAS wrote: Hy folks, I'm trying to migrate a database running on mysql for the famous www.redmine.org from mysql to postgresql. I was looking for ressources and I found this : http://www.olimpiks.ru/2011/03/redmine-mysqlpostgresql-converter.html The process is

[GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?

I have a production server running PG 8.4 on RHEL6. I have a development server running PG 9.2 on Ubuntu 13.04. Periodically, I like to take a dump of the production server and load it on the development machine. But I'm having troubles with the 9.2 server crashing when I'm restoring the dum

Re: [GENERAL] select DISTINCT

Thank you Kevin and Jeff for the responses. These are very helpful. On Fri, Sep 6, 2013 at 10:48 PM, Jeff Janes wrote: > On Friday, September 6, 2013, pg noob wrote: > >> >> Hi all, >> >> I'm curious about some of the query estimates that I'm seeing with >> queries that use DISTINCT. >> I am us

Re: [GENERAL] Migrate from mysql

On Mon, Sep 9, 2013 at 5:15 PM, Florent THOMAS wrote: > Hy folks, > > I'm trying to migrate a database running on mysql for the famous > www.redmine.org from mysql to postgresql. > I was looking for ressources and I found this : > http://www.olimpiks.ru/2011/03/redmine-mysqlpostgresql-converter.ht

Re: [GENERAL] Call for design: PostgreSQL mugs

Other folks posted much more clever and original ideas than mine here. But for a mug I would actually enjoy seeing on my desk daily… --> Lift the rounded-corner blue bar off the top of the PostgreSQL.org web site: http://www.postgresql.org/ and wrap around a white mug. So, the left-handed se

[GENERAL] Migrate from mysql

Hy folks, I'm trying to migrate a database running on mysql for the famous www.redmine.org from mysql to postgresql. I was looking for ressources and I found this : http://www.olimpiks.ru/2011/03/redmine-mysqlpostgresql-converter.html The process is almost perfect except for the binary datas.

Re: [GENERAL] psql client memory usage

On Sep 6, 2013, at 6:56 AM, Merlin Moncure wrote: > On Fri, Sep 6, 2013 at 8:19 AM, Tim Kane wrote: >> Ahh. All these years (albeit sporadic), I never knew about FETCH_COUNT. >> That makes sense. Thanks muchly. > > Not your fault: FETCH_COUNT is a hack IMO. The real issue was that > libpq (un

Re: [GENERAL] Call for design: PostgreSQL mugs

On 9/9/2013 2:07 PM, Basil Bourque wrote: Other folks posted much more clever and original ideas than mine here. But for a mug I would actually enjoy seeing on my desk daily… --> Lift the rounded-corner blue bar off the top of the PostgreSQL.org web site: http://www.po

Re: [GENERAL] Call for design: PostgreSQL mugs

On 9/9/2013 1:22 PM, patrick keshishian wrote: If printing inside the mug is too difficult, cost prohibitive, then stick with the smiling elephant at the outside bottom of the mug. as I rarely see mugs with anything printed on the bottom, I suspect this too would add significantly to the cost

Re: [GENERAL] psql client memory usage

On Mon, Sep 09/09/13, 2013 at 01:56:33PM -0700, Alan Nilsson wrote: > > On Sep 6, 2013, at 6:56 AM, Merlin Moncure wrote: > > > On Fri, Sep 6, 2013 at 8:19 AM, Tim Kane wrote: > >> Ahh. All these years (albeit sporadic), I never knew about FETCH_COUNT. > >> That makes sense. Thanks muchly. > >

Re: [GENERAL] Call for design: PostgreSQL mugs

On 9/9/13, John R Pierce wrote: > On 9/9/2013 1:22 PM, patrick keshishian wrote: >> If printing inside the mug is too difficult, cost prohibitive, then stick >> with the smiling elephant at the outside bottom of the mug. > > > as I rarely see mugs with anything printed on the bottom, I suspect thi

Re: [GENERAL] Call for design: PostgreSQL mugs

On 9/3/13, Andreas 'ads' Scherbaum wrote: > > PostgreSQL folks! > > We are looking for the next big thing. Actually, it's a bit smaller: a > new design for mugs. So far we had big blue elephants, small blue > elephants, frosty elephants, white SQL code on black mugs ... Now it's > time to design s

Re: [GENERAL] Call for design: PostgreSQL mugs

A couple ideas: A system diagram type thing with various app servers / languages, all connected to a central postgresql server, subtitled "All paths lead to PostgreSQL" PostgreSQL: Spend your money on hardware, not license fees. A timeline for pgsql showing all the major releases and what they add

Re: [GENERAL] Streaming replication slave crash

[piggybackin' on older (seeming very similar) thread...] On Fri, Mar 29, 2013, Quentin Hartman wrote: > Yesterday morning, one of my streaming replication slaves running 9.2.3 > crashed with the following in the log file: > > 2013-03-28 12:49:30 GMT WARNING: page 1441792 of relation base/63229/

Re: [GENERAL] Making substrings uppercase

Oliver Kohll - Mailing Lists wrote: > Hello, > > Given a string with certain words surrounded by stars, e.g. > > The *quick* *brown* fox jumped over the *lazy* dog > > can you transform the words surrounded by stars with uppercase versions, i.e. Maybe you can turn that into a resultset, then upp

[GENERAL] invalid resource manager ID in primary checkpoint record

Hi, For special testing reason, I am trying to restore PG from a backup that the basebase is from Standby and WAL files are from Master. During recovery phase, for every WAL file process, it returned 'invalid resource manager ID in primary checkpoint record' and paused, I had to manually run "

Re: [GENERAL] Call for design: PostgreSQL mugs

On Mon, Sep 9, 2013 at 10:09 AM, Mike Christensen wrote: > How about something incredibly cheesy like > > SELECT * FROM Mug; > I dig this. Black mug with this in white on one side, and a postgres logo in white on the other side. I'd buy one... One thing I have not seen discussed here is "Who is

Re: [GENERAL] are WAL file segment boundaries a point of consistency?

On Fri, Sep 6, 2013 at 1:26 PM, John Lumby wrote: > We use logshipping replication,and have recently noticed a nasty bug > where, in certain very rare cases, the primary archive_command program > will fail to send the WAL file to the standby but report good return code 0 > to postgresql. > I

Re: [GENERAL] are WAL file segment boundaries a point of consistency?

I would look at WAL files as a sequence of commits and not a sequence of files within timelines where you can specify either with recovery_target_time or recovery_target_xid the point of consistency you want to reach. Cheers, A.A. On Fri, Sep 6, 2013 at 1:26 PM, John Lumby wrote: > We use log

Re: [GENERAL] Call for design: PostgreSQL mugs

How about something incredibly cheesy like SELECT * FROM Mug; On Mon, Sep 9, 2013 at 8:22 AM, Karsten Hilbert wrote: > Inside of the mug: > > - runs of 0's and 1's = data > - neatly aligned or in compartments/boxes/shelved ? > > Outside of mug: > > 10 elephants > >

Re: [GENERAL] Call for design: PostgreSQL mugs

Inside of the mug: - runs of 0's and 1's = data - neatly aligned or in compartments/boxes/shelved ? Outside of mug: 10 elephants - each with a headband, carrying one of P-O-S-T-G-R-E-S-Q-L on the forehead - cordoning off towards the outsi

Re: [GENERAL] Making substrings uppercase

On 9 Sep 2013, at 14:41, David Johnston wrote: > Oliver Kohll - Mailing Lists wrote >> select regexp_replace(sentence,'\*(.*?)\*','' || upper('\1'),'g') from >> sentences; > > Yeah, you cannot embed a function-call result in the "replace with" section; > it has to be a literal (with the group i

Re: [GENERAL] Call for design: PostgreSQL mugs

Hi, "this is not an elephant" (to fake Magritt) http://enculturation.gmu.edu/3_2/images/magritte1.jpg or an elephant breast-feeding its babies to illustrate replication. but better ask someone else for the painting ;-) regards, Marc Mamin > -Original Message- > From: pgsql-general-o

Re: [GENERAL] Making substrings uppercase

Oliver Kohll - Mailing Lists wrote > select regexp_replace(sentence,'\*(.*?)\*','' || upper('\1'),'g') from > sentences; Yeah, you cannot embed a function-call result in the "replace with" section; it has to be a literal (with the group insertion meta-sequences allowed of course). I see two possi

Re: [GENERAL] Hello,

On 09/09/2013 05:55 AM, fumihisa.suz...@justsystems.com wrote: > Hello, > > initdb fails as follows: > > initdb.exe -A md5 -D "C:\Program Files\...\postgresql\data" -E UTF-8 -- > locale C -U postgres --pwfile="C:\Program Files\...\postgresql\pwfile. > txt" > The files belonging to this database s

Re: [GENERAL] PK referenced function

This is what I did with your help, So with this function you can know if a PK in table_from is referenced in x table with CONSTRAINT FOREIGN KEY Just if someone needs CREATE OR REPLACE FUNCTION referenced_in ( in_id bigint, in_schema_from varchar, in_table_from varchar ) RETURNS TABLE ( i

[GENERAL] Hello,

Hello, initdb fails as follows: initdb.exe -A md5 -D "C:\Program Files\...\postgresql\data" -E UTF-8 -- locale C -U postgres --pwfile="C:\Program Files\...\postgresql\pwfile. txt" The files belonging to this database system will be owned by user " u1". This user must also own the server proce

Re: [GENERAL] Sum of columns

hi, in addition to the others comments, you can also remove " ELSE 0 " from your query. It will result in values that are discarded by SUM. regards, Marc Mamin From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of jane...@web.de Sent: Montag, 9. S

[GENERAL] Making substrings uppercase

Hello, Given a string with certain words surrounded by stars, e.g. The *quick* *brown* fox jumped over the *lazy* dog can you transform the words surrounded by stars with uppercase versions, i.e. The QUICK BROWN fox jumped over the LAZY dog Given text in a column sentence in table sentences, I

[GENERAL] PostgreSQL and cgroup

Hello: Sorry for disturbing, In order to make my question clear, I wrote this one as a seperate question. If using cgroup, I can find wget work well. But , for postgresql, when I deal huge amount of data, it still report out of memory error. In fact I hope postgresql can work under a limit a