On 04/01/2012 16:15, Andreas Kretschmer wrote:
Birta Levente wrote:
Hi all
I use postgresql 9.1.2 on centos 6.2 and I want to use pgfouine, but in
my log file appear #011, #015 ... characters and the pgfouine can't
handle it.
Can I configure the server or rsyslog to log without these characte
On Wed, 4 Jan 2012 15:50:25 +0100, Bruno Boettcher wrote:
Hello!
just made a stupid move... upgraded a working system and without
checking if the backup was ok
so i end up with a debian system having upgraded to 9,1 without
converting the database, and a scrambled backup which is totall
On Wed, Jan 04, 2012 at 10:06:53AM -0800, Adrian Klaver wrote:
Hello!
> So when you are running pg_ctlcluster 9.0 main start what user are you
> running
> as?
tried as root...
>
> Have you tried to directly start the 9.0 cluster as the postgres user?:
just tried, same error
postgres@agenda
On Wednesday, January 04, 2012 11:42:01 pm Bruno Boettcher wrote:
> On Wed, Jan 04, 2012 at 10:06:53AM -0800, Adrian Klaver wrote:
> Hello!
>
>
> ok, got it, from your lines i saw that the binaries of the server were
> removed
> so i copied them over from the other server, and got the server
Hi,
I have a data set of several hundred thousand points. Each point is saved as a
three dimensional coordinate, i.e. (x, y, z). What I'd like to do is given a
point in that space, get a list of all of the points in the table within some
radius.
I'm familiar with the q3c package that does this
On Thu, Jan 5, 2012 at 11:01 AM, wrote:
> Hi,
>
> I have a data set of several hundred thousand points. Each point is saved as
> a three dimensional coordinate, i.e. (x, y, z). What I'd like to do is given
> a point in that space, get a list of all of the points in the table within
> some radi
"'Isidor Zeuner'" writes:
> using the latest git source code, I found that libpq will let the
> connection stall when getRowDescriptions breaks on an out of memory
> condition. I think this should better be handled differently to allow
> application code to handle such situations gracefully.
The
Wendi/Craig
I have seen an installation issue very similar to this. It has been happening
on Windows 7 x86 systems. We are using postgres as the DB for our application
and I have incorporated the postgres installer into our installer, we also use
Bitrock. We are using postgres 8.4.4. It's been
How is the number of columns in a join determined? When I combine somewhere
around 90 tables in a JOIN, the query returns:
ERROR: joins can have at most 32767 columns
SQL state: 54000
I'm sure most people will say "Why the hell are you joining 90 tables."
I've asked this list before for advice on
Lee Hachadoorian writes:
> How is the number of columns in a join determined? When I combine somewhere
> around 90 tables in a JOIN, the query returns:
> ERROR: joins can have at most 32767 columns
It's the sum of the number of columns in the base tables.
> I'm sure most people will say "Why th
On 01/05/2012 06:18 PM, Tom Lane wrote:
ERROR: joins can have at most 32767 columns
It's the sum of the number of columns in the base tables.
That makes sense. I totally misunderstood the message to be referring to
the number of joined columns rather than table columns.
I've asked this li
On Thu, Jan 5, 2012 at 6:10 PM, Lee Hachadoorian
wrote:
>
> Many of the smaller geographies, e.g. census tracts, do in fact have data
> for the vast majority of the columns. I am trying to combine it all into one
> table to avoid the slowness of multiple JOINs (even though in practice I'm
> never
Lee Hachadoorian wrote:
On 01/05/2012 06:18 PM, Tom Lane wrote:
Are there really 23000 populated values in each row? I hesitate to
suggest an EAV approach, but it kinda seems like you need to go in that
direction. You're never going to get decent performance out of a schema
that requires 100-w
I'd like to keep my current installation (8.3.3) alive and running while
installing and running 9.1.2 on the same server. Can I do this using
only the existing postgres superuser account? I'd want to create two
different initdb locations, and run the versions on different ports, of
course,
Hi,
On Jan 5, 2012, at 12:54 PM, Merlin Moncure wrote:
> see:
> http://www.postgresql.org/docs/9.1/interactive/cube.html
>
> and pay special attention to gist indexing portions. cube only
> indexes box operations, but you can cull the sphere using 3d distance
> formula for points between inner
On Thu, Jan 5, 2012 at 9:48 PM, Nishad Prakash wrote:
>
> I'd like to keep my current installation (8.3.3) alive and running while
> installing and running 9.1.2 on the same server. Can I do this using only
> the existing postgres superuser account? I'd want to create two different
> initdb loca
Hello:
I am try to get a function to return the count of the rows updated within
the function.
As in the following, I wan the number of rows updated to be returned.
This is a simple update, other update statements that I need to write will
be complicated.
CREATE OR REPLACE FUNCTION est_idio_retu
Hi Igor
2011/12/16 Igor Neyman wrote: > But I think,
your problem is right here:
>
> " running VACUUM FULL pg_largeobject"
>
> If you are running "VACUUM FULL ..." on the table, you should follow it with
> the "REINDEX TABLE ...", at least on PG versions prior to 9.0.
I'm pretty sure that VACUU
You could try:
1) return UPDATE table
OR
2) use plpsql function instead of SQL
UPDATE table
GET DIAGNOSTICS = ROW_COUNT
RETURN
Kind regards,
Misa
Sent from my Windows Phone
--
From: Kevin Duffy
Sent: 06/01/2012 06:21
To: pgsql-general@postgresql.org
Subject: [GENER
Sorry,
Option 1) is wrong answer... :)
Option 2 should work
Sent from my Windows Phone
--
From: Misa Simic
Sent: 06/01/2012 08:34
To: Kevin Duffy; pgsql-general@postgresql.org
Subject: RE: [GENERAL] function return update count
You could try:
1) return UPDATE
On Fri, 2012-01-06 at 07:12 +0100, Stefan Keller wrote:
> Hi Igor
> 2011/12/16 Igor Neyman wrote: > But I think,
> your problem is right here:
> >
> > " running VACUUM FULL pg_largeobject"
> >
> > If you are running "VACUUM FULL ..." on the table, you should follow it
> > with the "REINDEX TABLE
>
> So assuming all this is done in regular userland. built from source
> etc, you'll need to do a couple things. Each version needs to be
> built with a different --prefix. I prefer something like
> --prefix=/home/myusername/pg83 and --prefix=/home/myusername/pg91 and
> so on. This will put the
22 matches
Mail list logo
