Re: [GENERAL] pg on Debian servers

On 12/11/17 19:15, Karsten Hilbert wrote: On Sat, Nov 11, 2017 at 01:03:18PM +, Mark Morgan Lloyd wrote: Several legacy programs written in Delphi ground to a halt this morning, which turned out to be because a Debian system had updated its copy of PostgreSQL and restarted the server

Re: [GENERAL] pg on Debian servers

On 11/11/17 16:45, Jan Claeys wrote: On Sat, 2017-11-11 at 14:23 +, Mark Morgan Lloyd wrote: I think that the "preventing upgrades" route is the one to follow, since inhibiting the restart would obviously present a risk that something loaded dynamically could get out of step. As a

Re: [GENERAL] pg on Debian servers

On 11/11/17 13:45, Christoph Berg wrote: Re: Magnus Hagander 2017-11-11 Is there any way that either the package maintainer or a site administrator/programmer such as myself can mark the Postgres server packages as "manual upgrade only" or similar? Or since I'm almost certainl

[GENERAL] pg on Debian servers

art (irrespective of all investment in UPSes etc.) has the potential of playing havoc on a clustered system. Is there any way that either the package maintainer or a site administrator/programmer such as myself can mark the Postgres server packages as "manual upgrade only" or similar?

Re: [GENERAL] pg_logical/snapshots directory

On Sat, Nov 4, 2017 at 10:45 AM, Mark Fletcher wrote: > > While trying to track down my logical decoding problem, I noticed that > my pg_logical/snapshots directory has ~5000 .snap files and is growing at a > rate of about 4 files a minute. The earliest file is from yesterday > af

[GENERAL] pg_logical/snapshots directory

large table. I have not been able to find any docs on this directory. Can someone point me to an explanation of this directory and how to manage the number of .snap files in it (and/or whether I should be worried about the number of files in it)? Thanks, Mark

Re: [GENERAL] Logical decoding error

ch. Hence my email here. Do you capture the raw data from the replication connection when the error > happens? > > I was not, but I have added that and some other logging, and will report back when I get more info. Thanks, Mark

[GENERAL] Logical decoding error

start to work again. We are also doing standard streaming replication to a slave off this database, and that has never seen a problem. Does this ring a bell for anyone? Do you have any suggestions for how I should go about figuring out what's happening? Thanks, Mark

[GENERAL] multiple sql results to shell

I have this bash/sql script which outputs some curl commands. the backticks causes it to get interpreted by the shell. This works fine if there is one result, but when there are many rows returned, it looks like one shell command. any help on getting multiple rows returned to be executed by the

Re: [GENERAL] archive_command fails but works outside of Postgres

meter %p contains the complete path of the file and that you may need to specify the file name for the destination. Try this for your archive command : archive_command = 'gsutil cp "%p" "gs://my_bucket/pg_xlog/%f"' - Mark Watson

[GENERAL] Setting Variables within the PostgreSQL Service Process on AWS Linux

set a global one in the /etc/profile.d directory. This unfortunately breaks AWS Linux utilities that use Python2.7. Any help would be appreciated. Regards, Mark Street

Systemd support (was:Re: [GENERAL] Please say it isn't so)

h the underlying platform would have been very much to PostgreSQL's disadvantage, OP: Please note that you do yourself no favours at all by posting a subject line which could very easily be misinterpreted as spam. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above

Re: [GENERAL] Postgres 9.6.2 and pg_log - solved

De : pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] De la part de Mark Watson Envoyé : Monday, April 24, 2017 3:39 PM À : David G. Johnston Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log De : David G. Johnston

Re: [GENERAL] Postgres 9.6.2 and pg_log

De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 3:15 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 11:27 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>>

Re: [GENERAL] Postgres 9.6.2 and pg_log

De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 2:18 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 10:58 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>> wrote

Re: [GENERAL] Postgres 9.6.2 and pg_log

De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 1:34 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 8:43 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>> wrote

Re: [GENERAL] Postgres 9.6.2 and pg_log

De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 1:34 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 8:43 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>> wrote

[GENERAL] Postgres 9.6.2 and pg_log

9.6.2 has otherwise been running flawlessly. Mark Watson

Re: [GENERAL] Request to add feature to the Position function

De : pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] De la part de Ron Ben Envoyé : Monday, March 27, 2017 11:05 AM À : pgsql-general@postgresql.org Objet : [GENERAL] Request to add feature to the Position function > position(substring in string) > as listed her

Re: [GENERAL] Running TAP regression tests under windows/msvc

> On Mar 7, 2017, at 12:24 PM, Mark Dilger wrote: > > Hello, > > I am attempting to get the tap tests working under windows so as to > help review patches for the 10.0 development cycle. I can compile > the sources on windows 2008 using the MS Visual C and run the >

[GENERAL] Running TAP regression tests under windows/msvc

workspace/unicorns/postgresql/src/test/perl/PostgresNode.pm line 1321. # '' # doesn't match '(?^:statement: CREATE EXTENSION "plpgsql")' # Looks like you failed 1 test of 14. Thanks in advance for any clarification regarding what I might be doing wrong. Mark Dilger -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL on eMMC - Corrupt file system

titioning it to make absolutely sure that the internal controller has touched every block. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Regrding:- Arduino-Postgresql Direct Connection

n unavoidable need to use Arduino "shields" there's an interface called the Raspduino which would help. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] -- Sent via pgsql-general m

Re: [GENERAL] How to open PGStrom (an extension of PostgreSQL) in Netbeans?

Yes making the file is the problem. If you read my topic again, then you may know about what is the exact question -- View this message in context: http://postgresql.nabble.com/How-to-open-PGStrom-an-extension-of-PostgreSQL-in-Netbeans-tp5931425p5931594.html Sent from the PostgreSQL - general m

Re: [GENERAL] How to open PGStrom (an extension of PostgreSQL) in Netbeans?

Nope. I am not asking about installation instructions. I have installed it. And I know how to run it from command line. I just wanted to compile it in netbeans. -- View this message in context: http://postgresql.nabble.com/How-to-open-PGStrom-an-extension-of-PostgreSQL-in-Netbeans-tp5931425p59

Re: [GENERAL] How to open PGStrom (an extension of PostgreSQL) in Netbeans?

PostgreSQL has been successfully compiled in netbeans 8.1. But how to add its extension PG_Strom into it? -- View this message in context: http://postgresql.nabble.com/How-to-open-PGStrom-an-extension-of-PostgreSQL-in-Netbeans-tp5931425p5931427.html Sent from the PostgreSQL - general mailing li

[GENERAL] How to open PGStrom (an extension of PostgreSQL) in Netbeans?

Considering PGStrom, an extension of PostgreSQL-9.5.4, I tried opening that file in netbeans 8.1 I opened PGStrom in netbeans as File -> New Project -> C/C++ -> C/C++ Project with Existing Sources. And then selected the Folder that contains existing sources (PG_Strom). And then Finish It is showi

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

What are the functions (for example) are available/not available to get transformed to GPU source code? What is the factor value u consider to get multiplied with actual cost for CPU? For example, default cpu_tuple_cost is 0.01. Consider, for example, if the cost=0.00..458.00 for seq scan, how c

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

"fraction of the cost of executing the same portion of the plan using the traditional CPU processing" Can u explain about this fraction in detail? I need the clarifications for query plan tree also. Executing a query in CPU is different from executing the same in GPU. So the plan also differs.

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

Can u explain this statement "check whether the scan qualifier can be executable on GPU device" What are the scan qualifiers? How to determine whether they are device executable or not? The cost estimates are entirely based on number of rows and type of scan. Then it will be same for both CPU a

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

Can u explain this statement "check whether the scan qualifier can be executable on GPU device" What are the scan qualifiers? How to determine whether they are device executable or not? -- View this message in context: http://postgresql.nabble.com/How-the-Planner-in-PGStrom-differs-from-Postg

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

Thanks for your response. But that planning for a query execution in GPU is different from planning a query execution in CPU right? Even considering cost calculation, cost for executing a query in GPU is different from cost for executing a query in CPU. How this cost calculation for GPU occurs?

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

Yeah I think Kouhei Kaigai is one of the Contributors. So expecting his reply. And thanks for your kind responses -- View this message in context: http://postgresql.nabble.com/How-the-Planner-in-PGStrom-differs-from-PostgreSQL-tp5929724p5930373.html Sent from the PostgreSQL - general mailing l

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

Thank you so much for your references. How the planning factors of PGStrom differs from planning factos of PostgreSQL? -- View this message in context: http://postgresql.nabble.com/How-the-Planner-in-PGStrom-differs-from-PostgreSQL-tp5929724p5930356.html Sent from the PostgreSQL - general mail

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

Thank you so much for your kind reply. I am just curious about this planning factors in GPU. There can be more than one appropriate paths in query plan tree. How the decision for particular path has been made considering those planning factors? -- View this message in context: http://p

[GENERAL] How the Planner in PGStrom differs from PostgreSQL?

I am reading through Postgres and PGStrom. Regarding the planning factors, I need some clarifications. Can u help me with that? Planner in Postgres checks for different scan and join methods, and then find the cheapest one and creates a query plan tree. While going for same thing in GPU, the check

[GENERAL] PostgreSQL and ArcGIS used in UK military exercise

Potentially useful publicity. http://www.theregister.co.uk/2016/10/28/unmanned_warrior_esri_argcis_cloud_based_mapping/ -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] -- Sent via pgsql-general mailing

[GENERAL] update records to have occurance number

I want to update a table to have the value of the occurrence number. For instance, I have the below table. I want to update the number column to increment the count of last name occurrences, so that it looks like this: first last 1 second last 2 third last 3 first other 1 next other 2 Here's my

Re: [GENERAL] postgres driver for mysql

#x27;t given us a URL or told us the name of the module. Can anyone suggest a db federeted plugin for mysql/mariadb to store data in pg. Changing applications is impossible, they are proprietary and work only with specific databases only. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT

[GENERAL] foreign key with where clause

I have two tables that i want to link with a FK where the child table record is "active". some googling shows that i could use a function and a check constraint on the function, but that only works for inserts, not updates on table b. create table a (int id, text name); create table b (int id, bo

[GENERAL] unique constraint with several null values

aks when the application is multi-threaded and the rules are not applied at the database level. Another solution I can think of is to just use a trigger to prevent the duplicate rows. Any thoughts are certainly appreciated. I can't do much about the data model itself right now, I need to protect the integrity of the data. Thanks! -mark-

Re: [GENERAL] Stored procedure version control

Mark Morgan Lloyd wrote: Elsewhere, somebody was asking how people implemented version control for stored procedures on (MS) SQL Server. The consensus was that this is probably best managed by using scripts or command files to generate stored procedures etc., but does anybody have any

Re: [GENERAL] Stored procedure version control

Mike Sofen wrote: -Original Message- From: Mark Morgan Lloyd Sent: Thursday, June 30, 2016 2:41 AM Neil Anderson wrote: On 2016-06-29 12:37 PM, Mark Morgan Lloyd wrote: Elsewhere, somebody was asking how people implemented version control for stored procedures on (MS) SQL

Re: [GENERAL] Stored procedure version control

Neil Anderson wrote: On 2016-06-29 12:37 PM, Mark Morgan Lloyd wrote: Elsewhere, somebody was asking how people implemented version control for stored procedures on (MS) SQL Server. The consensus was that this is probably best managed by using scripts or command files to generate stored

[GENERAL] Stored procedure version control

PostgreSQL? -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

[GENERAL] System aggregation

something called Virtual Iron (possibly based on Xen), but it was swallowed by Oracle where it was under the wing of Wim Coekaerts who I believe has just joined Microsoft. Has anybody ever experimented with PostgreSQL on this sort of thing, and is anybody aware of an open equivalent? -- Mark Morgan

Re: [GENERAL] PostgreSQL advocacy

Jernigan, Kevin wrote: On 3/25/16, 4:37 AM, "pgsql-general-ow...@postgresql.org on behalf of Mark Morgan Lloyd" wrote: Just because a corporate has a hundred sites cooperating for inventory management doesn't mean that the canteen menus have to be stored on Oracle RAC :-

Re: [GENERAL] PostgreSQL advocacy

has a hundred sites cooperating for inventory management doesn't mean that the canteen menus have to be stored on Oracle RAC :-) -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] -- Sent via pgsql-gene

[GENERAL] PostgreSQL advocacy

ation of developers etc.) can in no way be interpreted as meaning that the technology is not unavailable or unreliable. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] -- Sent via pgsql-general mailin

[GENERAL] $user namespace with pg_dump?

ous, of course: replace $user with the value of the -U argument . This is a question of curiosity, not practicality.) Also, is there any difference between `pg_dump -n '(foo|bar)'` and `pg_dump -n foo -n bar`? In my narrow testing, they produce identical results. Thanks, -- Mark E. Haase

Re: [GENERAL] "Web of trust" connections

Jim Nasby wrote: On 11/6/15 8:01 AM, Mark Morgan Lloyd wrote: Purely out of curiosity, is there any way of using some sort of "web of trust" (comparable with GPG or whatever) when verifying server and client certificates, rather than going back to a centralised CA? My apologies if

[GENERAL] "Web of trust" connections

new server and get it cooperating with the rest, and some sort of WoT might be plausible rather than having to wait for the root administrator to send keys over a secure channel. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his emp

Re: [GENERAL] Red Hat Policies Regarding PostgreSQL

ely a security hazard too. It's a good policy IMO (though I used to work there so no doubt I've just drunk too much Red Hat koolaid). Seems reasonable. In fact somewhat better than current KDE as in e.g. Debian "Jessie", which embeds a copy of MySQL whether the the user wants to

Re: [GENERAL] Listen/notify, equivalents on other DBs

Thomas Kellerer wrote: Mark Morgan Lloyd schrieb am 25.09.2015 um 23:41: I'm trying to get support for PostgreSQL's listen/notify into a development environment, but since it supports multiple database backends: can anybody comment on how many other servers have a comparable facility

[GENERAL] Listen/notify, equivalents on other DBs

rbase, but I'm not in a position to investigate Oracle, IBM, MS and the rest. I'd appreciate any general comments from somebody who has broad SQL experience, I'm not asking for example code. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author'

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

I think part of the question is what the "true Debian way" is to massage the configuration files to include appropriate entries. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] -- Sent via pgsql-

Re: [HACKERS] [GENERAL] Insert result does not match record count

and I was thinking it was a psycopg2 problem, but seems there are issues with the internal counters in pg as well for tracking "large" changes. thanks, Mark On Sun, Feb 2, 2014 at 9:12 AM, Tom Lane wrote: > Vik Fearing writes: > > Without re-doing the work, my IRC logs sho

[GENERAL] [No subject]

-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres connection failures

ore the connection is closed. Printing a stack trace over there reveals that the pool code thinks the connection is idle and closes it. I’ll submit a bug report in the node-postgres library. Thanks for the help! /Mark -- Sent via pgsql-general mailing list (pgsql-general@postg

[GENERAL] Postgres connection failures

4-04-04 15:16:37 CEST LOCATION: RemoveOldXlogFiles, xlog.c:3414 /Mark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] designing time dimension for star schema

On Mon, Feb 10, 2014 at 8:45 AM, Mark Wong wrote: > Hello everybody, > > I was wondering if anyone had any experiences they can share when > designing the time dimension for a star schema and the like. I'm > curious about how well it would work to use a timestamp for the

Re: [GENERAL] designing time dimension for star schema

uld be good enough. I would estimate a query would touch up to an order of 1 million rows at a time. Regards, Mark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] designing time dimension for star schema

y exists in the dimension table. RETURN new; END; $$ LANGUAGE 'plpgsql'; CREATE TRIGGER populate_time BEFORE INSERT ON fact FOR EACH ROW EXECUTE PROCEDURE decompose_timestamp(); Regards, Mark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

[GENERAL] PgAgent Error 1053 on Windows 2008 R2 Server

es. I have checked the service entry in the Registry and compared it with other windows servers I have it running successfully. If some someone could point me down the right path as to why the service is not starting it would be appreciated. Regards, Mark Street Support Instinct Systems

Re: [GENERAL] Largest PG database known to man!

Thanks for your quick response John. >From the limited information, it is mostly relational. As for usage patterns, I do not have that yet. I was just after a general feel of what is out there size wise. Regards Mark Jones Princi

[GENERAL] Largest PG database known to man!

.. Mark Jones Principal Sales Engineer Emea http://www.enterprisedb.com/ Email: mark.jo...@enterprisedb.com Tel: 44 7711217186 Skype: Mxjones121

Re: [GENERAL] PL/R etc.

Merlin Moncure wrote: On Fri, May 10, 2013 at 2:32 PM, Mark Morgan Lloyd wrote: Merlin Moncure wrote: On Fri, May 10, 2013 at 4:41 AM, Mark Morgan Lloyd wrote: I don't know whether anybody active on the list has R (and in particular PL/R) experience, but just in case... :-) i) Some

Re: [GENERAL] PL/R etc.

Merlin Moncure wrote: On Fri, May 10, 2013 at 4:41 AM, Mark Morgan Lloyd wrote: I don't know whether anybody active on the list has R (and in particular PL/R) experience, but just in case... :-) i) Something like APL can operate on an array with minimal regard for index order

[GENERAL] PL/R etc.

down the array. Does this apply to PL/R? ii) Things like OpenOffice can be very inefficient if operating over a table comprising a non-trivial number of rows. Does PL/R offer a significant improvement, e.g. by using a cursor rather than trying to read an entire resultset into memory? --

Re: [GENERAL] How large can a PostgreSQL database get?

On Wed, 17 Apr 2013 08:23:41 -0500, Aleksey Tsalolikhin wrote: Hi. I was promoting PostgreSQL to an AIX/Oracle shop yesterday, they are looking to switch to open source to cut their licensing costs, and was asked how large a database does PostgreSQL support? Is there an upper bound on datab

Re: [GENERAL] libpq thread safety

Tom Lane wrote: Mark Morgan Lloyd writes: Do any special precautions need to be taken when PQNotifies is being called, to make sure that nothing else is referencing the handle? It's pretty much the same as any other operation on a PGconn: if there could be more than one thread touchin

[GENERAL] libpq thread safety

(GUI) timer is asynchronously polling for notifications. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Trouble with PQnotifies()

s reliable. Please also pardon me for asking inappropriate questions like this one. As far as I can recall, every issue I encountered before always finally proved that PostgreSQL is flawless. But at least it demonstrates that somebody's using that facility. -- Mark Morgan Lloyd markML

Re: [GENERAL] Installing minimal client libraries on Windows

Albe Laurenz wrote: Mark Morgan Lloyd wrote: Apologies for this old chestnut, but I think it's a question more often asked than answered. If I want to install a minimal binary libpq.dll on a non-developer machine to support Lazarus/FPC programs, where do I get it? I definitely don'

Re: [GENERAL] libpq - prevent automatic reconnect

I'm definitely not saying that it's a Postgres issue. I've tried forcing random connection drops at the application level in the past and have never been able to characterise the problem. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author

[GENERAL] Installing minimal client libraries on Windows

server, or to build from source. I'd rather not give them pgadmin or psql. I'd prefer not to install ODBC since I need to get at listen/notify that it doesn't support. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those

[GENERAL] Adding Default Privileges to a schema for a role

version of PostGIS I am able to see more than just the public role in the Default Privileges tab. I don't remember doing anything special to see other groups on the older machine. This isn't a bug is it? Thank You Mark Volz GIS Specialist -- Sent via pgsql-general mailing l

Re: [GENERAL] Looking for ODBC drivers for NT4.

odbc.msi of the appropriate version. You might also need a separate MDAC installer. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] How to analyze load average ?

On Mon, 06 Aug 2012 10:27:18 -0500, Tomas Vondra wrote: Although the OP mentioned he's using ext4, so I suppose he's running Linux (although I know there was some ext4 support e.g. in FreeBSD). Still, the load average 0.88 means the system is almost idle, especially when there's no I/O acti

Re: [GENERAL] How to analyze load average ?

On Mon, 06 Aug 2012 09:38:33 -0500, Tomas Vondra wrote: Load average is defined as a number of processes in the run queue That depends on if he's running Linux or BSD. http://www.undeadly.org/cgi?action=article&sid=20090715034920 -- Sent via pgsql-general mailing list (pgsql-general@postgre

Re: [GENERAL] BI tools and postgresql

h OSS and PostgreSQL, having come from a large corporate environment into a smaller more lean organization. Thus my request here. I would like to offer the new manager an opportunity to extend the range of options. - Mark

[GENERAL] Adding users connection via SSL

es one authenticated by password? -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.post

Re: [GENERAL] Terminating a rogue connection

Chris Angelico wrote: On Fri, Jul 27, 2012 at 7:09 PM, Mark Morgan Lloyd wrote: Chris Angelico wrote: On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd wrote: Assuming a *nix server: if a monitoring program determines that an established connection appears to be trying to so something

Re: [GENERAL] Switching from OSX to Linux, multi-line queries in \copy don't work anymore

lect * from pg_settings) to '/tmp/settings.csv' with csv header; \copy: parse error at "select" markMLl=> However my psql and server are rather old which could be an issue (8.1.19 to server 8.4 if I recall correctly). -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinio

Re: [GENERAL] Terminating a rogue connection

Chris Angelico wrote: On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd wrote: Assuming a *nix server: if a monitoring program determines that an established connection appears to be trying to so something inappropriate, what's the best way of terminating that session rapidly? s

[GENERAL] Terminating a rogue connection

Assuming a *nix server: if a monitoring program determines that an established connection appears to be trying to so something inappropriate, what's the best way of terminating that session rapidly? -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author&#

Re: [GENERAL] BI tools and postgresql

db and manipulating/plotting, > although I don't know in more detail of what the client's use cases are. > > > > On Wed, Jul 25, 2012 at 1:41 PM, Mark Phillips > wrote: > I am seeking suggestions for business intelligence and data mining tools > compatible with post

[GENERAL] BI tools and postgresql

I am seeking suggestions for business intelligence and data mining tools compatible with postgresql. A new manager at a client's shop is leaning toward the MS offerings. I would like to be able to speak to the issue. TIA, - Mark -- Sent via pgsql-general mailing list (pgsql-ge

Re: [GENERAL] Problem using a pl/pgsql function to populate a geometry column with x,y data - SOLVED

Nothwithstanding the fact I had my x and y's around the wrong way, I've got it working using ST_MakePoint.See below On 25/07/2012, at 12:39 AM, Mark Wynter wrote: > CREATE OR REPLACE FUNCTION load_xyz_data(sourcefile text, sourcesrid integer) > RETURNS text AS $$ &

Re: [GENERAL] Problem using a pl/pgsql function to populate a geometry column with x,y data - SOLVED

Notwithstanding the fact I had my x and y's around the wrong way, I've got it working using ST_MakePoint.See below On 25/07/2012, at 12:39 AM, Mark Wynter wrote: > CREATE OR REPLACE FUNCTION load_xyz_data(sourcefile text, sourcesrid integer) > RETURNS text AS $$ &

[GENERAL] Problem using a pl/pgsql function to populate a geometry column with x,y data

Within a pl/pgsql function block, I'm wanting to populate a geometry column with x,y data. However when I invoke the function, I get the error message that column "y" doesn't exist, even though it does. The error message is: SELECT load_xyz_data('/var/tmp/rscp_coverage_test.txt',32754); ERROR:

[GENERAL] Problem setting environmental variables for postgresql or plpythonu

no success adding them to... /etc/postgresql/9.1/main/environment #Shell commands are not evaluated. Any suggestions would be appreciated... Thanks Mark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] db server processes hanging around

ion/thread management, something like > this might show up in production. > > - Sumit > > > On 19 June 2012 18:28, Steve Crawford > wrote: > > On 06/19/2012 09:29 AM, Mark Rostron wrote: > >> > >> hi > >> > >> we are running out of databas

[GENERAL] db server processes hanging around

hi we are running out of database connections. we are using pg 9.0.6 on linux centos 5.7 64bit. we are not using any go-between connection pools such as pgbouncer or pgpool - connections occur directly from client to database. the connection setup on the client (java) is default, only providing (

Re: [GENERAL] full text index / search

http://linuxgazette.net/164/sephton.html I suggest that you review the Postgres Documentation for FTS: http://www.postgresql.org/docs/9.1/interactive/textsearch.html One option you may find interesting is the pg_trgm module: http://www.postgresql.org/docs/9.1/static/pgtrgm.html hth, - Mark Phillips On J

Re: [GENERAL] timestamps, formatting, and internals

f Time calculation is good to something like 250mSec so that's the limit of your accuracy, but as soon as you start taking refraction and atmospheric turbulence into account- even with the Sun high above the horizon- you're going to degrade that. -- Mark Morgan Lloyd markMLl .

Re: [GENERAL] Libpq question

t;roll your own" interface library, the libpq+pg combination has been in use for 10+ years, is actively maintained, and (hopefully) is bug- and backdoor-free. Reinventing this particular wheel is definitely not something that should be approached casually. -- Mark Morgan Lloyd markMLl .AT. t

[GENERAL] full text searching

most grateful for links to articles that discuss the design issues one should consider before implementing a long term strategy. Case study, or architectural articles, and similar. Thanks, - Mark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

Re: [GENERAL] FATAL: lock file "postmaster.pid" already exists

runtime from 4 minutes down to less than a second. I have a fairly clean patch in the works that I will submit after I have verified it on Windows 2003, Windows 2008 and Linux. From: Magnus Hagander To: Mark Dilger Cc: Tom Lane ; deepak ; Alban Hertroys

Re: [GENERAL] FATAL: lock file "postmaster.pid" already exists

were modified to pass a filter, this code might perform better on Windows.  I'll look into this. From: Tom Lane To: Mark Dilger Cc: deepak ; Alban Hertroys ; "pgsql-general@postgresql.org" Sent: Wednesday, May 23, 2012 4:25 PM Subject: Re: [

  1   2   3   4   5   6   7   >