Re: [GENERAL] Different result depending on order of joins

2015-05-22 Thread Christofer C. Bell
Tim, You just need to go back to the mailing list page on the PostgreSQL website: * Mailing list page: http://www.postgresql.org/list/ * Management page for subscriptions: http://www.postgresql.org/community/lists/subscribe/ While that URL says "subscribe", on the page itself, there's a drop-dow

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread Christofer C. Bell
On Tue, Jul 5, 2016 at 3:17 PM, Paul Linehan wrote: > > a good point, but I would prefer NOT to open a 324GB backup file in a > text > > editor. I can however cat/less/head/tail the file in Linux. > > Use vi (or flavour thereof) - it doesn't load the entire file in order to > read the contents of

Re: [GENERAL] initdb createuser commands

2016-10-31 Thread Christofer C. Bell
On Sun, Oct 30, 2016 at 11:10 PM, Melvin Davidson wrote: > > > > > On Sun, Oct 30, 2016 at 8:08 PM, Samuel Williams < > space.ship.travel...@gmail.com> wrote: > >> Sorry, just to clarify, b "worst" I don't mean functionality, I mean >> the way the commands are named and organised. >> >> On 31 Oct

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-24 Thread Christofer C. Bell
On Sat, Apr 22, 2017 at 9:11 AM, Edson Lidorio wrote: > > > On 22-04-2017 06:40, Magnus Hagander wrote: > > > > On Sat, Apr 22, 2017 at 3:05 AM, Cat wrote: > >> On Fri, Apr 21, 2017 at 08:20:38PM -0300, Edson Lidorio wrote: >> > Ls -la /var/lib/pgsql/9.6/data >> > >> > drwx--. 20 postgres p

Re: [GENERAL] Not sure this should be asked here but...

2017-04-24 Thread Christofer C. Bell
On Sun, Apr 23, 2017 at 5:31 AM, Ron Ben wrote: > > A simple open source forum system can be enough simetng like php-bb > example: warez-bb.org > > the installation of such system is like 1 hour of work. > > In my point of view something like stack overflow is the best but i'm not > sure if it's

Re: [GENERAL] Missing folder rhel-6Workstation-x86_64 for 9.6 repo (redhat)

2017-06-16 Thread Christofer C. Bell
On Fri, Jun 16, 2017 at 1:03 AM, Sari Thiele wrote: > Hi, > > it would be really great, if someone can look at this. > > Just to be clear, I am talking about the folder here: > > https://download.postgresql.org/pub/repos/yum/9.6/redhat/ > > There is one for RHEL7 Workstation, but not for RHEL6.

Re: [GENERAL] ERROR: out of memory DETAIL: Failed on request of size ???

2013-11-24 Thread Christofer C. Bell
On Fri, Nov 22, 2013 at 1:09 PM, Edson Richter wrote: > Em 19/11/2013 02:30, Brian Wong escreveu: > > I've tried any work_mem value from 1gb all the way up to 40gb, with no > effect on the error. I'd like to think of this problem as a server process > memory (not the server's buffers) or client

Re: [DOCS] Re: postgresql.org inconsistent (Re: [GENERAL] PG replication across DataCenters)

2013-12-15 Thread Christofer C. Bell
On Sun, Dec 15, 2013 at 9:40 AM, Wolfgang Keller wrote: > > > > Instead it lists Postgres-R, which has been in koma for how long > > > now... Can't even remember any more. > > > > Nope, it is actively developed and sponsored by Translattice. > > "Actively developed"? > > http://www.postgres-r.org/

Re: [GENERAL] Linux vs FreeBSD

2014-04-09 Thread Christofer C. Bell
On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil wrote: > Hi all! > > Does PG perform that much better on FreeBSD? I have some performance issues > on a Ubuntu 12.04 which I'd like to resolve. iowait varies a lot, between 5 > and 50%. Does FreeBSD better schedule I/O, which could alleviate s

Re: [GENERAL] Linux vs FreeBSD

2014-04-10 Thread Christofer C. Bell
On Wed, Apr 9, 2014 at 3:36 PM, François Beausoleil wrote: > > Le 2014-04-09 à 16:20, Bruce Momjian a écrit : > > On Wed, Apr 9, 2014 at 10:02:07AM -0500, Christofer C. Bell wrote: > > This highlights a more fundamental problem of the difference between a > workstation-ba