Re: [GENERAL] pg on Debian servers

roblem has been fixed in version 181+deb9u1. Cheers, Rob -- 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] pg on Debian servers

d up in different paths, however libpq will be updated and that may cause a restart. I run upgrades without any applications running so I don't know exactly what could happen when using unattended upgrades. HTH. Cheers, Rob -- 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] idle in transaction, why

> On Nov 7, 2017, at 12:16 AM, Thomas Kellerer <spam_ea...@gmx.net> wrote: > > Rob Sargent schrieb am 06.11.2017 um 23:09: >> Gosh I wish I could learn to proof-read my posts. >> My support crew graciously set >> >> idle_transaction_timeout = 1 >>

Re: [GENERAL] idle in transaction, why

On 11/07/2017 09:09 AM, Scott Marlowe wrote: On Tue, Nov 7, 2017 at 7:44 AM, Rob Sargent <robjsarg...@gmail.com> wrote: On Nov 7, 2017, at 12:16 AM, Thomas Kellerer <spam_ea...@gmx.net> wrote: I would figure values in "minutes" to be more realistic depe

Re: [GENERAL] idle in transaction, why

> On Nov 7, 2017, at 12:16 AM, Thomas Kellerer <spam_ea...@gmx.net> wrote: > > Rob Sargent schrieb am 06.11.2017 um 23:09: >> Gosh I wish I could learn to proof-read my posts. >> My support crew graciously set >> >> idle_transaction_timeout = 1 >>

Re: [GENERAL] idle in transaction, why

On 11/06/2017 02:38 PM, Merlin Moncure wrote: On Mon, Nov 6, 2017 at 2:50 PM, Rob Sargent <robjsarg...@gmail.com> wrote: On 11/06/2017 01:41 PM, Tom Lane wrote: Rob Sargent <robjsarg...@gmail.com> writes: idle_in_transaction_session_timeout | 0 | default | |

Re: [GENERAL] idle in transaction, why

On 11/06/2017 02:38 PM, Merlin Moncure wrote: On Mon, Nov 6, 2017 at 2:50 PM, Rob Sargent <robjsarg...@gmail.com> wrote: On 11/06/2017 01:41 PM, Tom Lane wrote: Rob Sargent <robjsarg...@gmail.com> writes: idle_in_transaction_session_timeout | 0 | default | |

Re: [GENERAL] idle in transaction, why

On 11/06/2017 01:50 PM, Rob Sargent wrote: On 11/06/2017 01:41 PM, Tom Lane wrote: Rob Sargent <robjsarg...@gmail.com> writes: idle_in_transaction_session_timeout | 0 | default | || A value of 0 turns off the timeout. | user Meh. I think we're barking up the

Re: [GENERAL] idle in transaction, why

On 11/06/2017 01:41 PM, Tom Lane wrote: Rob Sargent <robjsarg...@gmail.com> writes: idle_in_transaction_session_timeout | 0 | default | || A value of 0 turns off the timeout. | user Meh. I think we're barking up the wrong tree anyway: so far as I ca

Re: [GENERAL] idle in transaction, why

On 11/06/2017 01:17 PM, Tom Lane wrote: "David G. Johnston" writes: You should probably login as your application user and do "show idle_in_transaction_session_timeout" to see what a clean session has for a value and then figure out from there where that value is

Re: [GENERAL] idle in transaction, why

On 11/06/2017 01:09 PM, David G. Johnston wrote: On Mon, Nov 6, 2017 at 12:32 PM, Rob Sargent <robjsarg...@gmail.com <mailto:robjsarg...@gmail.com>>wrote: Using postgres 10-beta3 (hopefully 10.0 this week) on virtual CentOS7 and this JDBC driver postg

[GENERAL] idle in transaction, why

Using postgres 10-beta3 (hopefully 10.0 this week) on virtual CentOS7 and this JDBC driver postgresql:42.1.4 The postgresql.conf file has #idle_in_transaction_session_timeout = 0# in milliseconds, 0 is disabled my db url has "?prepareThreshold=0" since I bump into "already

Re: [GENERAL] gin index trouble

On 10/30/2017 10:56 AM, Peter Geoghegan wrote: On Mon, Oct 30, 2017 at 9:45 AM, Rob Sargent <robjsarg...@gmail.com> wrote: Peter, you beat me to the punch. I was just about to say "Having read the referenced message I thought I would add that we never delete from

Re: [GENERAL] Adding 'serial' to existing column

eral, not quote_ident, because you're trying to > produce > a single-quoted literal. > > regards, tom lane > > You could also do:- ALTER SEQUENCE tab_id_seq OWNED BY listings_cdc.table_id; which would establish the one-to-one relationship between th

Re: [GENERAL] query not scaling

On 10/31/2017 03:12 AM, Laurenz Albe wrote: Rob Sargent wrote: I think your biggest problem is the join condition on m.basepos between s.startbase and s.endbase That forces a nested loop join, which cannot be performed efficiently. Agree! 800,000 * 4,000 = 3,200,000,000. It's just

Re: [GENERAL] pg_audit to mask literal sql

On 10/30/2017 03:35 PM, John R Pierce wrote: On 10/30/2017 10:55 AM, rakeshkumar464 wrote: Is there a way in pgaudit to mask literal sqls like the below: insert into table (col1,col2) values(1,2) select * from table where col1 = 1 These sqls are typed by our QA folks using pgadmin. pgaudit

Re: [GENERAL] gin index trouble

On 10/30/2017 10:56 AM, Peter Geoghegan wrote: On Mon, Oct 30, 2017 at 9:45 AM, Rob Sargent <robjsarg...@gmail.com> wrote: Peter, you beat me to the punch. I was just about to say "Having read the referenced message I thought I would add that we never delete from

Re: [GENERAL] gin index trouble

On 10/30/2017 10:32 AM, Peter Geoghegan wrote: On Fri, Oct 27, 2017 at 3:15 PM, Rob Sargent <rsarg...@xmission.com> wrote: I’ve hit this same message Caused by: org.postgresql.util.PSQLException: ERROR: right sibling of GIN page is of different type in a couple of contexts and I’m st

Re: [GENERAL] gin index trouble

If you can make a test case that (eventually) hits that, we'd be interested to see it ... Any hint(s) on what might trigger this sort of thing? I could duplicate the upload, but I doubt you want the 800K records, 200M input file even if it did regenerate the problem. Would select * from

[GENERAL] gin index trouble

I’ve hit this same message Caused by: org.postgresql.util.PSQLException: ERROR: right sibling of GIN page is of different type in a couple of contexts and I’m starting to get worried. I’ve rebuilt the index, but will that help? Is there a way to see what the ‘different type’ is? Is it

Re: [GENERAL] query not scaling

On 10/26/2017 09:01 AM, Tom Lane wrote: Laurenz Albe writes: Also, to have PostgreSQL inline the function, which would be good for performance, it should be declared IMMUTABLE. Actually, if you hope to have a SQL function be inlined, it's better not to decorate it

Re: [GENERAL] query not scaling

On 10/26/2017 09:01 AM, Tom Lane wrote: Laurenz Albe writes: Also, to have PostgreSQL inline the function, which would be good for performance, it should be declared IMMUTABLE. Actually, if you hope to have a SQL function be inlined, it's better not to decorate it

Re: [GENERAL] query not scaling

> On Oct 26, 2017, at 1:02 AM, Laurenz Albe <laurenz.a...@cybertec.at> wrote: > > Rob Sargent wrote: >> I have a query I cannot tame and I'm wondering if there's an alternative >> to the "between" clause I'm using. Perhaps a custom type could do >&

[GENERAL] query not scaling

I have a query I cannot tame and I'm wondering if there's an alternative to the "between" clause I'm using. Perhaps a custom type could do better? I've tried the "<@" orperator and that changes the query plan significantly but the execution cost/time is not improved. Any suggestion or

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

On Sun, 2017-10-22 at 15:13 +0100, Martin Moore wrote: > 2017-10-22 14:08:28 UTC [2479-1] LOG: 0: database system > shutdown was interrupted; last known up at 2017-10-22 14:07:20 UTC There is something missing here. Last shutdown at 2017-10-22 14:07:20 UTC on which server? Then attempting

Re: [GENERAL] Problems with the time in data type timestamp without time zone

On Thu, 2017-10-19 at 10:28 -0400, américo bravo astroña wrote: > We are using two different programs within the same computer, a > program saves the data with date and time in the DB and we are doing > another program to retrieve that information with date and time to > generate reports, all

Re: [GENERAL] "Shared strings"-style table

On 10/13/2017 09:49 AM, Seamus Abshere wrote: hey, In the spreadsheet world, there is this concept of "shared strings," a simple way of compressing spreadsheets when the data is duplicated in many cells. In my database, I have a table with >200 million rows and >300 columns (all the

Re: [GENERAL] Inserting millions of record in a partitioned Table

On 09/20/2017 02:46 PM, Vick Khera wrote: On Wed, Sep 20, 2017 at 10:10 AM, Job > wrote: We noticed that if we import directly into the global table it is really, really slow. Importing directly in the single partition

[GENERAL] advisory locks namespace?

Hi, Am I right if two applications use advisory locks in the same database, they need to know which lock numbers are used to by the other application, to avoid conflicts? Rob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] looking for a globally unique row ID

parent. You mention payments being made. Users make mistakes. They can post a payment to the wrong account and later it has to be reversed. These things can be modelled via your UML diagram. Cheers, Rob -- 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] looking for a globally unique row ID

On 09/15/2017 12:45 PM, Adam Brusselback wrote: I cannot image a single postgres index covering more than one physical table. Are you really asking for that? While not available yet, that is a feature that has had discussion before. Global indexes are what i've seen it called in

Re: [GENERAL] looking for a globally unique row ID

Isn't this typically handled with an inheritance (parent-children) setup. MasterDocument has id, subtype and any common columns (create date etc) then dependents use the same id from master to complete the data for a given type. This is really common in ORM tools. Not clear from the

Re: [GENERAL] looking for a globally unique row ID

On 09/14/2017 02:39 PM, Rafal Pietrak wrote: W dniu 14.09.2017 o 19:30, Rob Sargent pisze: On 09/14/2017 11:11 AM, Rafal Pietrak wrote: [--] So I'm stuck with seriously incomplete solution. that's why I have an impression, that I'm going into entirely wrong direction here

Re: [GENERAL] looking for a globally unique row ID

On 09/14/2017 11:11 AM, Rafal Pietrak wrote: Not really. As I said, I'm not looking for performance or "fair probability" of planetary-wide uniqueness. My main objective is the "guarantee". Which I've tried to indicate referring to "future UPDATEs". What I mean here is functionality

Re: [GENERAL] How to add new Collation language

-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 14 September 2017 14:53 To: Rob Northcott <rob.northc...@compilator.com> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to add new Collation language Rob Northcott <rob.northc...@compilator.co

Re: [GENERAL] How to add new Collation language

-Original Message- From: rob stone [mailto:floripa...@gmail.com] Sent: 14 September 2017 13:38 To: Rob Northcott <rob.northc...@compilator.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] How to add new Collation language On Thu, 2017-09-14 at 11:30 +000

Re: [GENERAL] How to add new Collation language

On Thu, 2017-09-14 at 11:30 +, Rob Northcott wrote: > How can I add a collation language to a Postgres server? > Specifically, I want to create a new database with collation of > English_United Kingdom.1252 but the only options are C, Posix and > United States. > Even if

[GENERAL] How to add new Collation language

How can I add a collation language to a Postgres server? Specifically, I want to create a new database with collation of English_United Kingdom.1252 but the only options are C, Posix and United States. Even if I select United Kingdom as the locale when installing Postgres I still only have

Re: [GENERAL] pg_ident mapping Kerberos Usernames

> > > > Hi Rob, > > How would that work? I was under the impression the first column was > for socket type and limited to > local, host, hostssl, and hostnossl? > > Thunderbird's config has been fixed, so here is the line from > pg_hba.conf line without th

Re: [GENERAL] pg_ident mapping Kerberos Usernames

FATAL: GSSAPI authentication failed for user "us...@a.domain.tld" > < 2017-09-09 19:50:55.023 CDT - 192.168.1.201 us...@a.domain.tld > > DETAIL: Connection matched pg_hba.conf line 87: "host all > all 192.168.1.0/24 gss include_realm=1 &

Re: [GENERAL] Dealing with number formats when server and client are different locales

-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 06 September 2017 15:49 To: Rob Northcott <rob.northc...@compilator.com> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Dealing with number formats when server and client are different locales Rob Nor

Re: [GENERAL] Dealing with number formats when server and client are different locales

-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 06 September 2017 13:36 To: Rob Northcott <rob.northc...@compilator.com> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Dealing with number formats when server and client are different locales Rob Nor

[GENERAL] Dealing with number formats when server and client are different locales

to have the server accept either . or , as a decimal separator. Any suggestions or hints very welcome before I get stuck into changing the formatting code in the application. Med vänlig hälsning / Best Regards Rob Northcott Software Developer (UK Office, TEAM Systems) Compilator AB Södergatan

Re: [GENERAL] pglogical bidirectional replication of sequences

On 09/01/2017 02:29 AM, Peter J. Holzer wrote: TLDR: Don't. I'm currently conducting tests which should eventually lead to a 2 node cluster with working bidirectional logical replication. (Postgresql 9.6.4-1.pgdg90+1, pglogical 2.0.1-1.jessie+1 on Debian 9 (Stretch)) pglogical supports

Re: [GENERAL] jdbc driver vis Release 10

> On Aug 25, 2017, at 5:55 PM, Dave Cramer <p...@fastcrypt.com> wrote: > > There are newer versions out there! > > Dave Cramer > > da...@postgresintl.com > www.postgresintl.com > >> On 25 August 2017 at 19:53, Rob Sargent <robjsarg...@gmail.com&

Re: [GENERAL] jdbc driver vis Release 10

On 08/25/2017 05:34 PM, Dave Cramer wrote: The JDBC driver release is divorced from the server release. Thanks Dave Cramer da...@postgresintl.com <mailto:da...@postgresintl.com> www.postgresintl.com <http://www.postgresintl.com> On 23 August 2017 at 19:33, Rob Sarge

Re: [GENERAL] jdbc driver vis Release 10

On 08/23/2017 06:09 PM, David G. Johnston wrote: On Wed, Aug 23, 2017 at 4:33 PM, Rob Sargent <robjsarg...@gmail.com <mailto:robjsarg...@gmail.com>>wrote: I see no mention of a new jdbc driver on the release notes for Beta 1. Does that mean there isn't one? ​Whose r

[GENERAL] jdbc driver vis Release 10

I see no mention of a new jdbc driver on the release notes for Beta 1. Does that mean there isn't one? -- 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] Function not inserting rows

2'] ); > > > I don't use python but the traditional way to call a function is:- select api_dev.add_texts_to_item( 444, array['PGADM1','PGADM2'] ); HTH, Rob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Count column with name 'count' returns multiple rows. Why?

Hi all, I don't understand why this query: select count(base.*) from mytable base; does return multiple rows. select count(1) from mytable base; returns the proper count. There is a column with the name 'count'. Can anyone please explain this behaviour? Steps to reproduce: create

Re: [GENERAL] sequence used on null value or get the max value for a column whith concurrency

On Thu, 2017-08-10 at 19:05 -0300, marcelo wrote: > In some table, I have a bigint column which at the app level can be  > null. Call it "DocumentNumber", and of course is not the PK. > In most cases, the applications give some value to the column. > > But sometimes, the value remains null,

Re: [GENERAL] invalid byte sequence for encoding

On Wed, 2017-08-09 at 14:21 +0200, basti wrote: > Hello, > i have a webapp convert from ascii to uft8. > > Now I get in postgres > > ERROR:  invalid byte sequence for encoding "UTF8": 0xfc > > Now I try to log all queries with log_statement = 'all'. > All queries are longed expected this one.

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

> On Aug 5, 2017, at 3:12 PM, Dan Cooperstock at Software4Nonprofits > wrote: > > I’m on PostgreSQL 9.6, 64-bit Windows. > > That really is the correct name for the sequence, because I’m not using > SERIAL. (I needed everything to match the naming in my

Re: [GENERAL] bidirectional mapping?

On 08/02/2017 01:35 PM, John McKown wrote: On Wed, Aug 2, 2017 at 10:55 AM, Chris Travers >wrote: On Wed, Aug 2, 2017 at 5:44 PM, John McKown > wrote:

Re: [GENERAL] Developer GUI tools for PostgreSQL

uld be connected to a Postgres database and also an Oracle one. HTH. Rob -- 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] How to get transaction started always in WRITE mode.

much for any hints. > Adam Slachta > > Hello Adam, There is a Hibernate parameter that overrides the database's default isolation level:- hibernate.connection.isolation Are you certain that second level caching is off? You can make a class in a cache immutable by:- Don't know if th

Re: [GENERAL] Backward compatibility

split_part(). > > regression=# select split_part(version(), ' ', 2); >  split_part  > >  9.5.7 > (1 row) > > regards, tom lane > > An alternative select:- SELECT version(), (regexp_split_to_array( version(), E'\\s+'))[2] Cheers, Rob -

Re: [GENERAL] Is the row version available in SQL?

What you are describing is called 'optimistic locking’. […] > https://blog.2ndquadrant.com/postgresql-anti-patterns-read-modify-write-cycles/ Thanks, both answers helped. Rob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] Is the row version available in SQL?

ection for that long. I can add a `version bigint` column to my table, and the final update will look like: update ... where id = ? and version = the_version_selected_earlier_in_a_different_thread … and if that gets 0 rows, it can handle the conflict. Rob

[GENERAL] performance considerations of jsonb vs separate rows

differences between these two options? Yes, I’ll need to build performance tests myself, but that’s a lot of work to get two realistic situations with millions of rows, so I’m wondering about guesses or common knowledge on this. thanks, Rob

Re: [GENERAL] Inconsistent performance with LIKE and bind variable on long-lived connection

64-bit You'll notice that the first time it ran the database was "cold" and it took 402, whereas the second time it dropped to 57. If I have time today I might alter it to used named variables and see if that makes a difference. Cheers, Rob -- 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] Deadlock with single update statement?

> On Jun 10, 2017, at 10:34 AM, Tom Lane wrote: > […] but it'd be better to adjust the query to ensure a deterministic > update order. Thank you for the answer. Since `update` has no `order by` clause, I’m guessing there’s no way to do this with just the `update` statement,

[GENERAL] Deadlock with single update statement?

threads, each running this update, get in a deadlock? In other words, are both of the following true: 1. The update locks each row in sequence, not all at once. 2. The order of the row locking could vary from one thread to the next. thanks, Rob -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] dump to pg

> On May 31, 2017, at 9:27 AM, David G. Johnston > wrote: > > On Wed, May 31, 2017 at 7:43 AM, Nicolas Paris wrote: > Hi, > > I have dumps from oracle and microsoft sql server (no more details). Is it > possible to load them "directly" into

Re: [GENERAL] SELECT statement with sub-queries

cts.category); >  ^ > Hmm, "serial" is an "integer" and the "category" and "manufacturer" > too. > > So whats wrong with it? > > You only need a single equals sign in SQL. SELECT

Re: [GENERAL] Error that shouldn't happen?

Postgres skipped checking for duplicate tables due to some timing issue. I don't want my DB to ending up hosed by something like that. Thanks, Rob From: "David G. Johnston" <david.g.johns...@gmail.com> Date: Thursday, May 18, 2017 at 3:31 PM To: Rob Brucks <rob.bru...@racksp

Re: [GENERAL] Error that shouldn't happen?

eate table statement. Thanks, Rob From: "David G. Johnston" <david.g.johns...@gmail.com> Date: Thursday, May 18, 2017 at 3:05 PM To: Rob Brucks <rob.bru...@rackspace.com> Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org> Subject: Re: [GENERAL

[GENERAL] Error that shouldn't happen?

PostgreSQL 9.5.4 installed from PGDG packages on Centos 7.3.1611 · Zabbix 3.2 server Thanks, Rob Brucks

Re: [GENERAL] all serial type was changed to 1

Every row? On 05/01/2017 05:17 PM, Max Wang wrote: Sorry. I mean all tables’ id column were reset to 1. Thanks. *From:*Melvin Davidson [mailto:melvin6...@gmail.com] *Sent:* Tuesday, 2 May 2017 9:14 AM *To:* Max Wang *Cc:* Adrian Klaver ;

[GENERAL] Cannot spot the difference in two queries

I have three very similar functions, two of which are fast and one is slow and I cannot explain the slowness of the third. All of which, with the correct arguments should return the same "optimal set". I present one of the two fast versions and the slow one, in whole and in part.I'm using

Re: [GENERAL] referential integrity between elements of an array and another table?

On 04/19/2017 01:13 PM, Henry M wrote: I was just reading this question on reddit (the text duplicated below). I was wondering if there is an approach for handling array foreign key references. I am interested in the answer since I started using array fields as well. Thank you. -

Re: [GENERAL] referential integrity between elements of an array and another table?

On 04/19/2017 01:13 PM, Henry M wrote: I was just reading this question on reddit (the text duplicated below). I was wondering if there is an approach for handling array foreign key references. I am interested in the answer since I started using array fields as well. Thank you. -

Re: [GENERAL] Error During PostGIS Build From Source on Linux

On 04/12/2017 12:01 PM, Adrian Klaver wrote: On 04/12/2017 10:14 AM, Osahon Oduware wrote: Hi All, I am working on a Linux OS (Centos 6.5). I built GDAL successfully from source as below: ./configure --prefix=/path/to/gdal make make install Next I built PostgreSQL successfully from source

Re: [GENERAL] Unable to connect to Postgresql

bs host, port, etc. out of the service file. All you have to do is keep the service file up-to-date. Cheers, Rob -- 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] Unable to connect to Postgresql

y obtaining the IP address from /etc/hosts. Are you able to put some trigger_error messages into testfcgi.php in order to make sure Apache is running the correct program? Cheers, Rob -- 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] Unable to connect to Postgresql

". There is no requirement to traverse a network. It is all on the same physical machine. Alter your postgresql.conf file and remove the hash so that:- listen_addresses = 'localhost' is explicitly defined. Alter pg_hba.conf so that localhost is declared and let's see what happens. Cheers,

Re: [GENERAL] Unable to connect to Postgresql

on > > >> > host 192.168.1.6 and accepting\n\tTCP/IP > connections on > > >> > port 5432? in > > >> > /httpd/iliffe/testfcgi.php on line 132 > > >> > --- > >  > This is a tad confusing to me. You have Apache, PHP, and P

Re: [GENERAL] A change in the Debian install

Hello Adrian, On Thu, 2017-04-06 at 21:24 -0700, Adrian Klaver wrote: > On 04/06/2017 08:01 PM, rob stone wrote: > > > > > > > That is the default location and is generally the case in a source  > install. Package maintainers can and do often put them elsewhere. &

Re: [GENERAL] A change in the Debian install

On Thu, 2017-04-06 at 15:58 -0700, Adrian Klaver wrote: > On 04/06/2017 03:16 PM, rob stone wrote: > > > > > > Which is what has me confused. If you are using the postgresql- > common  > system then the *.conf files should be in  > /etc/postgresql/version/clu

Re: [GENERAL] A change in the Debian install

ard /etc/postgresql/major_version/main method of installation. It means you can run different major versions on the same box. Cheers, Rob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] A change in the Debian install

iles are stored in the database cluster's data directory." which IMHO means where PGDATA is pointing. Has anybody else struck this issue? Cheers, Rob -- 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] Is there a point to having both a normal gist index and an exclude index?

On 04/05/2017 12:04 PM, Bruno Wolff III wrote: On Wed, Apr 05, 2017 at 00:05:31 -0400, Tom Lane wrote: Bruno Wolff III writes: ... I create both a normal gist index and an exclude index using the following: CREATE INDEX contains ON iplocation USING gist

Re: [GENERAL] Equivalent function not found for ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE().

On 03/27/2017 04:59 AM, MAJUMDER, SAYAN wrote: Hi, I am new to postgresql and presently we are migrating from sql server to postgresql. We have certain functions in sql server such as ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE(). I am unable to find any equivalent functions in

Re: [GENERAL] How to define the limit length for numeric type?

ant 30.2 or > 3.2 can not be inserted, how to do this? > > Thank you. > > > Assuming that column goose may only contain values ranging from 100.0 to 999.9, then a check constraint along the lines of:- goose > 99.9 and < 1000 should do the trick. HTH, Rob -- Sent

Re: [GENERAL] import CSV file to a table

On 03/08/2017 09:52 AM, Karl Czajkowski wrote: On Mar 08, Rob Sargent modulated: Yes Karl, I agree. I admitted as much. But if it's clean, as in free of quoted commas, life is much more simple. I've lost site of whether or not the OP knows his situation w.r.t. to this. The awk line

Re: [GENERAL] Unable to start postgresql

Meant to ask before, can you show the command you are using to connect? My memory says OP didn't use --host, which often leads to trying the socket. Do we know that's enabled in pg_hba? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] import CSV file to a table

the values. Karl On Mar 08, Rob Sargent modulated: Since bash has been bandied about in this thread I presume awk is available. Here's how I would check just how 'csv'ish the incoming file is. ... Yes Karl, I agree. I admitted as much. But if it's clean, as in free of quoted commas, life

Re: [GENERAL] import CSV file to a table

Since bash has been bandied about in this thread I presume awk is available. Here's how I would check just how 'csv'ish the incoming file is. awk -F"," '{a[$NF]++}END{for(i in a){printf "%d lines have %d fields(columns)\n", a[i], i}}' csvfilename If this doesn't produce one line you

Re: [GENERAL] Postgres, apps, special characters and UTF-8 encoding

the file's BOM is set correctly. 2) Make sure your headers contain the following:- or which is HTML5, however the long version is still recognised by HTML5. I understand that some versions of IE have issues with correctly determining the character set, so, unfortunately, you still have

Re: [GENERAL] CentOS 7.3, PostgreSQL 9.6.2, PHP 5.4 deliver array as string

converting the string to a PHP array via an explode. However, I've only had to do this with single level arrays. Don't know if this helps as you haven't supplied the table definition of words_games. Cheers, Rob -- 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] pg_xlog keeps growing

> On Feb 27, 2017, at 8:33 PM, dhanuj hippie wrote: > > Hi, > > I have a postgres cluster running in hot_standby. I see the pg_xlog is > growing over time (may files of size 16 MB each). The replication lag is very > less ~2kB, and never goes into a bad state. > I'm

Re: [GENERAL] NOTIFY command impact

every 30 seconds and the replay timestamp will be updated. But if communication to the master is lost, for whatever reason, the replay timestamp will not be updated on the slave and then lag can be accurately measured and alerted. I hope this helps! --Rob From: Benoit Lobréau <benoit.l

Re: [GENERAL] NOTIFY command impact

query all columns of all pg_stat* views on any DB, yet has no ability to modify *anything* (not even create any objects of its own). I won't grant super-user to my monitoring role since it is administered remotely, it is too much of a security risk. Thanks! Rob On 2/22/17, 3:19 PM, &qu

Re: [GENERAL] NOTIFY command impact

the "pg_last_xact_replay_timestamp" on the slaves so we can more accurately monitor replication lag on quiet systems. Thanks, Rob On 2/21/17, 5:03 PM, "Tom Lane" <t...@sss.pgh.pa.us> wrote: Rob Brucks <rob.bru...@rackspace.com> writes: > If a notify is sent and then PG is

Re: [GENERAL] NOTIFY command impact

If a notify is sent and then PG is immediately shut down, wouldn't PG want to save that message for processing after startup? Or is the message just discarded? --Rob From: "David G. Johnston" <david.g.johns...@gmail.com> Date: Tuesday, February 21, 2017 at 4:45 PM To: Rob

Re: [GENERAL] NOTIFY command impact

orage. But I wonder if that file is only used to store notify commands during shutdown/startup? Or if there are any considerations for memory usage… --Rob On 2/21/17, 4:38 PM, "Adrian Klaver" <adrian.kla...@aklaver.com> wrote: On 02/21/2017 02:19 PM, Rob Brucks wrote: >

Re: [GENERAL] NOTIFY command impact

I did find a post a while back saying they were discarded, but I wanted to double-check. I performed some tests to see if listens worked AFTER the notify was issued, they were not. This leads me to believe that the messages are discarded when a listen does not yet exist. --Rob From: "

Re: [GENERAL] NOTIFY command impact

In my case the monitoring user will be connecting, issuing the notify, then immediately disconnecting. And we don't have any systems using listen/notify. So I'm hoping there won't be a problem. That's why I'm asking ☺ --Rob On 2/21/17, 3:17 PM, "Adrian Klaver" <adrian.kla..

[GENERAL] NOTIFY command impact

ges inserted with nobody to listen for them, which is why I'm posting here. Do you see any long-term problems with constantly issuing "NOTIFY" commands every 30 seconds without an associated "LISTEN" command? Thank you, Rob Brucks

Re: [GENERAL] Fwd: Query parameter types not recognized

Hello Roberto, On Fri, 2017-02-10 at 16:43 -0500, Roberto Balarezo wrote: > Hi Rob, > > Thanks for your answer. The query is just an example I made to > illustrate the problem. In the database I'm working with, duedate is > a timestamp without timezone column, which can cont

  1   2   3   4   5   6   7   8   >