Hi,
I'm creating a pl/pgSQL function that returns a table that has a column name
which is the same as a PostgreSQL reserved. In the below example a have
returning table with a column called 'desc':
CREATE OR REPLACE FUNCTION bad_func() RETURNS TABLE (bar INTEGER, "desc"
VARCHAR(100)) AS $$
BE
I've been getting database out of memory failures with some queries which deal
with a reasonable amount of data.
I was wondering what I should be looking at to stop this from happening.
The typical messages I been getting are like this: http://pastebin.com/Jxfu3nYm
The OS is:
Linux TSTLHAPP01
memory after each sort operation has
completed.
Thanks,
Jeremy
From: Scott Marlowe [scott.marl...@gmail.com]
Sent: Friday, 25 March 2011 5:04 p.m.
To: Jeremy Palmer
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Out of memory
On Thu, Mar 24, 2011
any given time.
Thanks,
Jeremy
-Original Message-----
From: Jeremy Palmer
Sent: Saturday, 26 March 2011 9:57 p.m.
To: Scott Marlowe
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] Out of memory
Hi Scott,
It was the work_mem that was set too high. I reduced it to 32mb and the
ameter to sensible values given the
hardware and database utilization.
2) Can anyone help me make sense of the top transaction memory error to help
track down the issue?
Any other suggestions would be greatly appreciated.
Thanks
Jeremy
________
From: Jeremy Palmer
Sen
Hi John,
> Does that all really have to be a single transaction?
Yes - I need to ensure that of the changesets and denormalised tables are
created in the same transaction, so that if an error occurs the database is
rolled back to the last successfully applied changeset. I don't want to get
int
Hi Jeff,
< Where is the source to the function?
The source is located here: https://github.com/linz/linz_bde_uploader
The main function LDS_MaintainSimplifiedLayers that is being called is on line
37 is in
https://github.com/linz/linz_bde_uploader/blob/master/sql/lds_layer_functions.sql.
T
e would be greatly appreciated.
Regards,
Jeremy
____
From: Jeremy Palmer
Sent: Tuesday, 5 April 2011 9:50 p.m.
To: pgsql-general@postgresql.org
Subject: Out of memory
Hi,
I've been having repeated troubles trying to get a PostgreSQL app to play
nicely on Ubu
Hi All,
I running PostgreSQL 9.0.3 and getting an out of memory error while running a
big transaction. This error does not crash the backend.
The nature of this transaction is it is sequentially applying data updates to a
large number (104) of tables, then after applying those updates, a serie
ULL,
guarantee_status TEXT NOT NULL,
estate_description TEXT,
number_owners INT8 NOT NULL,
part_share BOOLEAN NOT NULL,
shape GEOMETRY,
);
CREATE INDEX shx_title_shape ON titles USING gist (shape);
Thanks,
Jeremy
From: Tom Lane [t...@sss.pgh
> No, given the info from the memory map I'd have to say that the leakage
> is in the cursor not in what you do in the plpgsql function. The cursor
> query looks fairly unexciting except for the cast from geometry to text.
> I don't have PostGIS installed here so I can't do any testing, but I
> wo
Hi All,
I'm just investigating the option for configuring SSO for windows clients
connecting to a PostgreSQL 9.3 server installed on Ubuntu 14.04. Our windows
environment uses a Windows 2012 domain controller.
The best information I could find on this subject was
http://www.hagander.net/talks/
I think PgAdmin is just a client that uses libpq and does not specifically help
with SSO.
From: Raghu Ram [mailto:raghuchenn...@gmail.com]
Sent: Tuesday, 13 January 2015 10:22 p.m.
To: Jeremy Palmer
Subject: Re: [GENERAL] SSO Windows-to-unix
On Tue, Jan 13, 2015 at 5:15 AM, Jeremy Palmer
Anybody have an help on this topic?
Thanks
Jeremy
From: Guillaume Lelarge [guilla...@lelarge.info]
Sent: Wednesday, 14 January 2015 8:20 p.m.
To: Jeremy Palmer
Cc: PostgreSQL General; raghuchenn...@gmail.com
Subject: Re: [GENERAL] SSO Windows-to-unix
Le
Sorry to ask again, but I still have not got any reply to this. Maybe this
indicates it’s a bad option?
>
>
> On Tue, Jan 13, 2015 at 5:15 AM, Jeremy Palmer
> mailto:jpal...@linz.govt.nz>> wrote:
>
> Hi All,
>
> I'm just investigating the option for
I'm setting up an apache server and was wondering if it is possible to setup
HTTP user authentication against PostgreSQL authentication? I see
http://www.giuseppetanzilli.it/mod_auth_pgsql2/, but that requires a custom
username table. I want to be able to leverage the PostgreSQL Authentication
David G Johnston wrote
> Personally, I would consider having both Apache and PostgreSQL talk to a
> LDAP database if you really need to have a single point of identity
> definition.
The PostgreSQL DB is currently setup with Kerberos for Windows SSO, as well as
MD5 password authentication for an
Subject: Re: [GENERAL] HTTP user authentication against PostgreSQL
On 1/30/2015 12:31 AM, Jeremy Palmer wrote:
> The PostgreSQL DB is currently setup with Kerberos for Windows SSO, as well
> as MD5 password authentication for another pool of other PostgreSQL users who
> are not part of o
I maintain large libraries of files containing PL/pgsql code which I would like
to document better. Are there any tools currently available that can generate
documentation from PL/pgsql source code? Would be good if it had functionality
like doxygen. e.g
/**
* my function comment..
*
* @param p
>> Ok I removed the geometry column from the cursor query within the function
>> and the session still runs out of memory. I'm still seeing the same error
>> message as well:
>> PortalHeapMemory: 16384 total in 4 blocks; 5944 free (0 chunks); 10440
>> used
>> ExecutorState: 122880 to
Hi All,
We are currently running PostgreSQL 8.4 on Windows server 2003 and are planning
to move the instance to Ubuntu 10.4 - yay!. At the same time we will also
upgrade to 9.1. One nice features that we leverage from the windows
configuration is the ability for windows clients to use AD SSO i.
00 a.m.
To: Craig Ringer
Cc: Jeremy Palmer; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Windows SIngle Sign On - LINUX Server
In real world deployment, LDAP and Kerbero are often combined for
authentication and authorization.
The link below is a well documented howto:
https://help.ubuntu.com
I'm getting infrequent backend crashes on a windows instance of PostgreSQL. The
error I get is in the log below. It seems to relate to the share memory each
time. Does anyone have any ideas what the problem is here, or what additional
things I can do to get more information out next time the ba
No they all got killed off.
-Original Message-
From: Magnus Hagander [mailto:mag...@hagander.net]
Sent: Wednesday, August 18, 2010 8:06 PM
To: Jeremy Palmer
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Win32 Backend Cash - pre-existing shared memory block is
still in use
On
t for another crash. Should I set the
level to 'debug5'? The cluster is for development purposes, so I don't mind the
overhead.
Cheers,
Jeremy
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, August 19, 2010 4:07 AM
To: Alvaro Herrera
Cc: Jeremy P
x27;m
willing provide more information to help diagnose this.
Regards,
Jeremy
-Original Message-
From: Magnus Hagander [mailto:mag...@hagander.net]
Sent: Friday, August 20, 2010 1:46 AM
To: Tom Lane
Cc: Jeremy Palmer; pgsql-general@postgresql.org; Alvaro Herrera
Subject: Re: [GENERAL]
-Original Message-
From: Jeremy Palmer
Sent: Friday, August 20, 2010 1:52 PM
To: 'Magnus Hagander'; Tom Lane
Cc: pgsql-general@postgresql.org; Alvaro Herrera; Chris Crook
Subject: RE: [GENERAL] Win32 Backend Cash - pre-existing shared memory block is
still in use
Yes I do re
session can create large temp tables.
Thanks
Jeremy
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Wednesday, August 25, 2010 5:11 PM
To: Jeremy Palmer
Cc: Magnus Hagander; Tom Lane; pgsql-general@postgresql.org; Alvaro Herrera
Subject: Re: [GENERAL] Win32
Yeah that's what stated here:
http://technet.microsoft.com/en-us/library/ms189334.aspx
But only if I add /3gb switch to the kernel boot parameters
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Wednesday, August 25, 2010 5:28 PM
To: Tom Lane
Cc: J
: Wednesday, August 25, 2010 5:34 PM
To: Jeremy Palmer
Cc: Tom Lane; Magnus Hagander; pgsql-general@postgresql.org; Alvaro Herrera
Subject: Re: [GENERAL] Win32 Backend Cash - pre-existing shared memory block is
still in use
I would be WAY cheaper in time and effort, to just build a simple 64
bit linux
Hi,
I have a table:
observation (
id int4 NOT NULL [PRIMARY KEY],
vector_id NOT NULL [FORGIEN KEY],
obs_type VARCHAR(4) NOT NULL,
date TIMESTAMP NULL
)
I need to select the newest observation id, classify by type, for each
vector (there can be multiple observation ids on each vector)
Sorry I posted this to the wrong list. I have now reposted this is
pgsql-sql.
-Original Message-
From: Jeremy Palmer [mailto:[EMAIL PROTECTED]
Sent: Saturday, 19 November 2005 11:05 a.m.
To: 'pgsql-general@postgresql.org'
Subject: DISTINCT ON
Hi,
I have a table:
observati
32 matches
Mail list logo
