Re: [GENERAL] Postgresql - commercial version

pay for, then I would suspect there will tables/functions/etc that do not exist in the community version you could query for. On 07-Jul-2017 7:28 PM, "Adrian Klaver" <mailto:adrian.kla...@aklaver.com>> wrote: On 07/07/2017 06:52 AM, Krithika Venkatesh wrote:

Re: [GENERAL] Postgresql - commercial version

. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] (Might be a bug) locale issue while upgrading data directory from PostgreSQL 8.4 to 9.5

ale/ parameter was not provided during PostgreSQL 8.4 installation [scenario 3]. Thanks and Regards, Mayank Agrawal . On Fri, Jul 7, 2017 at 4:56 AM, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 07/04/2017 10:23 PM, Mayank Agrawal wrote: Hello,

Re: [GENERAL] (Might be a bug) locale issue while upgrading data directory from PostgreSQL 8.4 to 9.5

e know what value to pass to the parameter --locale while installing PostgreSQL 9.5?* Thanks and Regards, Mayank Agrawal -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Renaming Raster Table

tored in the database and is not affected by -R. Note that your generated sql file will contain both the main table and overview tables." In addition it is going to produce an SQL file that contains the changes for you to look at. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent

Re: [GENERAL] Feature proposal, DBURL: psql pgsql://joe:p4zzw...@example.org:2345/dbname

On 07/05/2017 08:31 AM, Hans Schou wrote: 2017-07-05 15:41 GMT+02:00 Adrian Klaver <mailto:adrian.kla...@aklaver.com>>: [scheme[<+>dsn]]://[[username[:[password]]@][host][:port][/[dbname][/[[table[/[column[,column...]*]]]|sql]]] ^^^

Re: [GENERAL] Invalid field size

ues appear may help with determining the source. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] 64bit initdb failure on macOS 10.11 and 10.12

On 07/04/2017 11:56 PM, Rainer J.H. Brandt wrote: Tom Lane writes: Adrian Klaver writes: On 07/04/2017 01:29 PM, Rainer J.H. Brandt wrote: Good to know. I removed those options and tried again. Did you run make clean before re-running ./configure? Personally I do "make dist

Re: [GENERAL] Feature proposal, DBURL: psql pgsql://joe:p4zzw...@example.org:2345/dbname

...]*]]]|sql]]] ^ The thing is that in a quick search on this I did not find a reference implementation of this to compare against. Yours, Laurenz Albe -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@po

Re: [SPAM] [GENERAL] How to install pgadmin3 or pgadmin4 on linux machine

uot; https://yum.postgresql.org/repopackages.php#pg95 I have download pgdg-redhat95-9.5-3.noarch.rpm from the above link and install successfully on my server. " -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

Re: [GENERAL] 64bit initdb failure on macOS 10.11 and 10.12

error. I don't see how Perl can make the difference, but I guess it's not relevant that I can't see it ;-( Thanks for taking the time to answer. Rainer -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chan

Re: [SPAM] Re: [SPAM] Re: [GENERAL] Invalid field size

3) 1) and 2) could be moot if Daniel's hardware corruption theory is correct. 4) This is probably not going to be solved until you are able to access the actual file(s) in question. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general

Re: [SPAM] Re: [SPAM] Re: [GENERAL] Invalid field size

On 07/04/2017 10:13 AM, Moreno Andreo wrote: Il 04/07/2017 18:25, Adrian Klaver ha scritto: On 07/04/2017 09:02 AM, Moreno Andreo wrote: Il 04/07/2017 17:39, Adrian Klaver ha scritto: So what you are saying is "in the last 5 years you've been extremely lucky?" :-) Your ori

Re: [SPAM] Re: [GENERAL] Invalid field size

On 07/04/2017 09:02 AM, Moreno Andreo wrote: Il 04/07/2017 17:39, Adrian Klaver ha scritto: So what you are saying is "in the last 5 years you've been extremely lucky?" :-) Your original post went back and forth on whether you where lucky in the past: "... that's

Re: [GENERAL] Invalid field size

inary format rather than as text. It is somewhat faster than the text and CSV formats, but a binary-format file is less portable across machine architectures and PostgreSQL versions. Thanks Moreno -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Invalid field size

e up by 2 files, one with "normal data" and one with the result of COPYing this table to a file. A question that comes while I'm writing: but pg_dump with custom format is not using COPY with binary format? Thanks Moreno -- Adrian Klaver adrian.kla...@aklaver.com -- Sent vi

Re: [GENERAL] Invalid field size

d data (when using cheap pendrives we get often this error)." Thanks Moreno. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Invalid field size

me we are trying to COPY FROM corrupted data (when using cheap pendrives we get often this error). Should it be reasonable or I have to search elsewhere? Thanks in advance Moreno. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] Using 'WITH SELECT' Results Do Not Match 'SELECT FROM ' Results

st a matter a little push to get out of the rut:) Thanks again! /s/jr Sent from my iPhone -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Using 'WITH SELECT' Results Do Not Match 'SELECT FROM ' Results

1 Concerto - a composition for orchestra and a soloist -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Need help on compiling postgres source code from cloned repo

, Rajan. -- View this message in context: http://www.postgresql-archive.org/Need-help-on-compiling-postgres-source-code-from-cloned-repo-tp5969667.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-genera

Re: [GENERAL] have trouble understanding xmin and xmax with update operations from two different sessions

View this message in context: http://www.postgresql-archive.org/have-trouble-understanding-xmin-and-xmax-with-update-operations-from-two-different-sessions-tp5969629.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via p

Re: [GENERAL] duplicate key value violates unique constraint and duplicated records

ld be helpful though: Postgres version? OS and version? The pg_basebackup command line invocation? Why you don't think it is index corruption? 2017-07-01 7:30 GMT+08:00 Adrian Klaver <mailto:adrian.kla...@aklaver.com>>: On 06/30/2017 07:33 AM, Timokhin Maxim wrote:

Re: [GENERAL] duplicate key value violates unique constraint and duplicated records

. https://www.postgresql.org/docs/9.6/static/pgupgrade.html "pg_upgrade supports upgrades from 8.4.X and later to the current major release of PostgreSQL, including snapshot and alpha releases." after that server starts normally. -- Timokhin 'maf' Maxim -- Adri

Re: [GENERAL] PostGreSQL Timeout, auto shutdown and Pkey errors

Machine: DIRELIANT2, Thread Name: Process Name: C:\Program Files\Dynamic Instruments, Inc\Digital Recorder\DICSInterface\DICSInterface.exe Niel Smith - Support Technician -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] duplicate key value violates unique constraint and duplicated records

k you. -- Timokhin 'maf' Maxim -- Adrian Klaver adrian.kla...@aklaver.com -- 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] duplicate key value violates unique constraint and duplicated records

Also where are you getting Postgres from? I ask because 9.6.3.1 is not a community version or was that just a typo? Everything would be not bad if in the table weren't appeared duplicated records in url column. Any idea how is it possible? Thank you! -- Timokhin 'maf' Maxim

Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting

nks for your help! - Dame un poco de fe, eso me bastará. Rozvo Ware Solutions -- View this message in context: http://www.postgresql-archive.org/postgres-dbname-dbuser-9-9-9-9--PARSE-waiting-tp5968923p5969262.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. --

Re: [GENERAL] PostGreSQL Timeout, auto shutdown and Pkey errors

ory. Process Name: w3wp Process ID: 10672 The only thing I understand in the above is: "...the free memory (89677824 bytes) is less than 5% of total memory." Whatever it is wants more memory. if anyone can help me out with these errors that would be very much appreciated. Thank

Re: [GENERAL] PostGreSQL Timeout, auto shutdown and Pkey errors

ery much appreciated. Thank you Niel Smith - Support Technician Equature -- Adrian Klaver adrian.kla...@aklaver.com -- 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] 9.6 parameters messing up my 9.2 pg_dump/pg_restore

in most cases that I have run across ERROR's are more informational then data affecting. Cheers, Ken -- -- Adrian Klaver adrian.kla...@aklaver.com -- 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] CREATE TABLE & composite type

On 06/28/2017 06:52 AM, Merlin Moncure wrote: On Wed, Jun 28, 2017 at 8:37 AM, Adrian Klaver wrote: On 06/28/2017 06:27 AM, gmb wrote: CREATE TABLE inventory_item_table AS ( SELECT some_func( ) limit 0); I think it's better to use the (somewhat arcane but designed for this exact pu

Re: [GENERAL] Which process is actually doing the WAL writes/calls XLogFlush?

les(UNLOGGED tables excepted). Maybe it is worth to enhance the documentation for this, at least for synchronous_commit=true? The asynchronous behavior is well documented here: https://www.postgresql.org/docs/current/static/wal-async-commit.html. Again, thanks David and Adrian for your help K

Re: [GENERAL] CREATE TABLE & composite type

site type <http://www.postgresql-archive.org/CREATE-TABLE-composite-type-tp5969032.html> Sent from the PostgreSQL - general mailing list archive <http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html> at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via

Re: [GENERAL] Accessing DB2 tables from postgresql

make use of the extension ODBC drivers for the data sources to be used must be installed in the system and reflected in the /etc/odbcinst.ini file." See also: https://github.com/CartoDB/odbc_fdw/issues/45 I would ask there, by either responding to existing issue or starting a new issue.

Re: [GENERAL] Unknown lvalue 'PIDFILE' in section 'Service'

ectly valid, because the data dir is Environment=PGDATA=/opt/PostgreSQL/9.4/data What is going wrong? I am no systemd expert by any means, but I have to believe that it should be: Environment=PIDFILE=/opt/PostgreSQL/9.4/data/postmaster.pid TIA Marcelo -- Adrian Klaver adrian.kla

Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting

that need to be managed. To better able to do that is going to require some detective work to determine what is generating the connections and for what purpose. Thanks for your help! - Dame un poco de fe, eso me bastará. Rozvo Ware Solutions -- Adrian Klaver adrian.kla...@aklaver

Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting

On 06/27/2017 03:41 PM, Melvin Davidson wrote: On Tue, Jun 27, 2017 at 6:32 PM, Adrian Klaver *His problem is NOT 'idle in transaction' per se. It is all connections are used up.* Not following. The 'idle in transaction' queries are coming in through a connection s

Re: [GENERAL] Which process is actually doing the WAL writes/calls XLogFlush?

pointer process \_ postgres: writer process \_ postgres: wal writer process \_ postgres: autovacuum launcher process \_ postgres: stats collector process \_ postgres: bgworker: pglogical supervisor AFAIK the wal writer process. > > Thanks > Daniel > > --

Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting

ge in context: http://www.postgresql-archive.org/postgres-dbname-dbuser-9-9-9-9--PARSE-waiting-tp5968923.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Accessing DB2 tables from postgresql

artoDB/odbc_fdw From the examples above you need to prefix some settings with odbc_. In your example that would be odbc_database 'TESTV9' instead of database 'TESTV9'. How can I access DB2 LUW or zOS database tables from postgres? -- Thanks & Regards, Swapnil Vaze

Re: [GENERAL] ERROR: query returned no rows

On 06/26/2017 01:10 PM, Paul A Jungwirth wrote: On Mon, Jun 26, 2017 at 12:47 PM, Adrian Klaver wrote: On 06/26/2017 12:03 PM, Paul Jungwirth wrote: Perhaps you should see what is line 85 when you do `\sf words_skip_game` (rather than line 85 in your own source code). Or easier yet: https

Re: [GENERAL] ERROR: query returned no rows

On 06/26/2017 01:10 PM, Paul A Jungwirth wrote: On Mon, Jun 26, 2017 at 12:47 PM, Adrian Klaver wrote: On 06/26/2017 12:03 PM, Paul Jungwirth wrote: Perhaps you should see what is line 85 when you do `\sf words_skip_game` (rather than line 85 in your own source code). Or easier yet: https

Re: [GENERAL] ERROR: query returned no rows

ain `INTO`. I see from your gist that your function *does* have some queries that are `INTO STRICT`, so I would focus on those. That page also describes how to use `print_strict_params` to get a little more info about the details of the error. I hope that helps! Paul -- Adrian Klav

Re: [GENERAL] Configure Qt Creator to work with PostgreSQL to extensions development

On 06/25/2017 01:34 PM, Andreas Joseph Krogh wrote: På søndag 25. juni 2017 kl. 17:04:02, skrev Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 06/25/2017 07:34 AM, Fabiana Zioti wrote: > I'm creating an extension to PostgreSQL, with user-defined types and

Re: [GENERAL] Configure Qt Creator to work with PostgreSQL to extensions development

Not seeing how Qt will work in a Postgres extension? PostgreSQL provides the tutorial for working with eclipse: https://wiki.postgresql.org/wiki/Working_with_Eclipse# Is there any tutorial for Qt? Or are the setup steps similar to Eclipse? Thank you very much in advance. -- Adrian K

Re: [GENERAL] Left join help

members.id <http://members.id/>= 1 ONmissions.id <http://missions.id/>= submissions.mission_id WHERE missions.track_id = 7 -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Download 9.6.3 Binaries

buttons you will be taken to 9.6.3 binaries for the OS/Arch. Thanks, Igal Sapir Lucee Core Developer Lucee.org <http://lucee.org/> -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] PostgreSQL Cookbook Testing

ssue. >>>>>> -- >>>>>> Please see .kitchen/logs/kitchen.log for more details >>>>>> Also try running `kitchen diagnose --all` for configuration -Server type: VMware OS: Redhat 6 or Redhat 7 PostgreSQL Version: 9.5.7 -Pawan

Re: [GENERAL] Which process is actually doing the WAL writes/calls XLogFlush?

to be true, right? Why do I need the wal_writer at all then when synchronous_commit is set to something else than off? See here: https://www.postgresql.org/docs/9.6/static/wal-async-commit.html Thanks for your help Daniel -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql

Re: [GENERAL] 10beta1 role

ut in the process, it leaves a message behind in the server's log file. Basically it pings the server with whatever information it has at that stage in the startup procedure until hopefully it has the complete information needed. Cheers, Jeff -- Adrian Klaver adrian.kla...@aklaver.com

Re: [GENERAL] 10beta1 role

On 06/22/2017 01:41 PM, Ray Stell wrote: On 6/22/17 4:36 PM, Adrian Klaver wrote: On 06/22/2017 01:16 PM, Ray Stell wrote: On 6/22/17 4:07 PM, Adrian Klaver wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Ca

Re: [GENERAL] 10beta1 role

On 06/22/2017 01:16 PM, Ray Stell wrote: On 6/22/17 4:07 PM, Adrian Klaver wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Can you show your complete initdb command? throws these msgs: 2017-06-22 14:36:34 EDT

Re: [GENERAL] 10beta1 role

On 06/22/2017 01:29 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 06/22/2017 01:13 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell mailto:ste...@vt.edu> <mailto:ste...@vt.edu

Re: [GENERAL] 10beta1 role

so it just uses the default. Cheers, Jeff -- Adrian Klaver adrian.kla...@aklaver.com -- 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] 10beta1 role

:36:34 EDT,0,startup LOCATION: InitializeSessionUserId, miscinit.c:503 -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Error when building new db using pg_restore

y, all the interesting stuff is done by CREATE LANGUAGE. * Later we will probably "dumb down" that command and put more of the * knowledge into this script. */ CREATE PROCEDURAL LANGUAGE plpgsql; COMMENT ON PROCEDURAL LANGUAGE plpgsql IS 'PL/pgSQL procedural language';

Re: [GENERAL] enable PostgreSQL SSL from RPM package installation

l/pgsql96' If you have more then one version of Postgres installed then you will need to use the pg_config from that version: /usr/local/pgsql94/bin/pg_config --version --configure PostgreSQL 9.4.11 '--with-python' '--with-openssl' '--with-libxml' '--

Re: [GENERAL] Error when building new db using pg_restore

-- plpgsql | postgres | t | PL/pgSQL procedural language plpythonu | postgres | f | PL/PythonU untrusted procedural language I won't worry about this much more, but if the system identifies it as an error then I thought it was at least worth making the inqu

Re: [GENERAL] Invalidation of cached plans for stored procedures ?

the wrong plan until I forced a new function version. Hence my questioning, is there more than just «plpgsql cache plans» in that issue… If there is nothing else, then I'll start digging the code… I don't know, which is why I am returning this to list. Pierre -- Adri

Re: [GENERAL] Invalidation of cached plans for stored procedures ?

found a workaround using event triggers to rewrite every function when an > alter occurs on such a table, but this seems… odd to me. I don't think we are > doing anything very complicated here, so I'm surprised that nothing has been > done yet to fix that issue. https://ww

Re: [GENERAL] PostgreSQL Source Control Integration

On 06/21/2017 05:08 AM, Günce Kaya wrote: Hi, I work on PostgreSQL 9.6 and I'm looking for a source code control tool. Is there anyone who give a suggest about that? http://sqitch.org/ Best Regards, -- Gunce Kaya -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-ge

Re: [GENERAL] Schedule

On 06/20/2017 01:23 PM, Alban Hertroys wrote: On 20 Jun 2017, at 18:46, Adrian Klaver wrote: Yes this could be become complicated if for no other reason then it is being driven from the customer end and there will need to be a process to verify and incorporate their changes. There

Re: [GENERAL] Schedule

On 06/20/2017 08:12 AM, Steve Clark wrote: On 06/20/2017 10:38 AM, Adrian Klaver wrote: On 06/20/2017 07:00 AM, Steve Clark wrote: We already have a monitoring system in place that has been in operation circa 2003. Just recently we have added a new class of customer whose operation is not

Re: [GENERAL] Schedule

On 06/20/2017 07:00 AM, Steve Clark wrote: On 06/20/2017 09:02 AM, Adrian Klaver wrote: On 06/20/2017 05:35 AM, Steve Clark wrote: Hello, We have customers whose equipment we monitor. Some of the customers don't run a 24/7 operation and turn their equipment off when the go home. We ne

Re: [GENERAL] Schedule

pment and do you or the customer provide it? Thanks in advance, Steve -- Adrian Klaver adrian.kla...@aklaver.com -- 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] storing postgres data on dropbox

ake things difficult. Many thanks for your help, which is exceptionally clear and detailed. MM -- Adrian Klaver adrian.kla...@aklaver.com -- 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] storing postgres data on dropbox

ember, how are you installing/updating Postgres on your machines? -- Adrian Klaver adrian.kla...@aklaver.com -- 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] storing postgres data on dropbox

. 5) The above is valid for Steve Atkins suggestion of using the external drive as the sole data directory. The only thing I would be concerned about is that external hard drives I have worked with are not all that fast, you will have to see if that is a problem in your case. -- Adrian K

Re: [GENERAL] storing postgres data on dropbox

the difference being you do not have Dropbox trying to sync while you are using the database. That I am pretty sure will not end well. The above does depend on familiarity with programs like rsync or Unison for the syncing portion. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via p

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

/ There is one for RHEL7 Workstation, but not for RHEL6. Thanks, Sari -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Connection options

interface it is confusing. Maybe this will help: https://www.postgresql.org/docs/9.6/static/libpq-example.html Thank you. David J. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Connection options

On 06/15/2017 01:23 PM, Igor Korot wrote: Hi, Adrian, On Thu, Jun 15, 2017 at 4:13 PM, Adrian Klaver wrote: On 06/15/2017 12:02 PM, Igor Korot wrote: Hi, again, On Thu, Jun 15, 2017 at 2:59 PM, Igor Korot wrote: Hi, ALL, I'm looking at the documentation at www.postgresql.org

Re: [GENERAL] Connection options

connection to the server? https://www.postgresql.org/docs/9.6/static/multibyte.html Thank you. Thank you. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Trigger problems/questions

oid != new_zoid then NEW.state := NEW.state || ('{"community_zoid": ' || zoid || '}')::jsonb; end if; end if; ... Not sure what happens if zoid is null and new_zoid is null also? Or if it matters? Jim -- Jim Fulton http://jimfulton.info --

Re: [GENERAL] CREATE FOREIGN TABLE difficulties

’t complain if the database, never mind the schema, doesn’t exist. If this turns out to be a bug, I’ll happily move to the bug mailing list to discuss further. But under the possibility I’m missing the obvious, I’d thought I’d try here first. I’m going to go try the 10.0 beta now… Thanks! - Paul

Re: [GENERAL] Strange port in pg_upgrade output

the same time. However, when checking an old running server, the old and new port numbers must be different." Thanks Armand -- Adrian Klaver adrian.kla...@aklaver.com -- 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] ERROR: type " " does not exist

x27;2', $2 = '1' ERROR: type " " does not exist at character 149 What are you using to execute the above query and how are the parameters being supplied to $1 and $2? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@p

Re: [GENERAL] Create extension C using IDE

On 06/12/2017 11:03 AM, Fabiana Zioti wrote: I already have postgresql 9.6 installed. I'm developing extensions for it in C. What would be the best IDE to debug the code? Eclipse has many errors. The errors are? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general ma

Re: [GENERAL] Timezone locale consistency for functional indexes

that also take summer time into consideration? And using the immutable function wrapper is wrong? By correct approach, you mean setting timezone to 'UTC'? If by immutable function wrapper, you mean faking the immutability of a function, then yes I would see that as wrong. -- Adrian Kl

Re: [GENERAL] Timezone locale consistency for functional indexes

stem settings could cause this behaviour? We run Ubuntu Linux 16.04 and Postgresql 9.6 Another question is, should I just create immutable functions wrappers for this instead? -- Kind Regards / Med Vennlig Hilsen Olav Grønås Gjerde -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via p

Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

ke Dropbox. regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Vacuum and state_change

On 06/09/2017 02:26 PM, armand pirvu wrote: On Jun 9, 2017, at 4:20 PM, Adrian Klaver wrote: On 06/09/2017 02:01 PM, armand pirvu wrote: On Jun 9, 2017, at 3:52 PM, Adrian Klaver wrote: On 06/09/2017 01:31 PM, armand pirvu wrote: By temporary tables I mean just regular table not

Re: [GENERAL] Vacuum and state_change

On 06/09/2017 02:01 PM, armand pirvu wrote: On Jun 9, 2017, at 3:52 PM, Adrian Klaver wrote: On 06/09/2017 01:31 PM, armand pirvu wrote: By temporary tables I mean just regular table not tables created by "create temporary table" . I should have been more precise. We

Re: [GENERAL] Vacuum and state_change

/docs/9.6/static/progress-reporting.html Aside that there are vacuum improvements and such, any other strong compelling reason to upgrade to 9.6 ? That would depend on what version you are on now. If it is out of support then there would be a reason to upgrade, not necessarily to 9.6 t

Re: [GENERAL] Performance issue with Pointcloud extension

UNTIME-CONFIG-LOGGING-WHEN log_min_messages (enum) https://www.postgresql.org/docs/9.6/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT log_connections (boolean) log_disconnections (boolean) log_duration (boolean) -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general m

Re: [GENERAL] Vacuum and state_change

On 06/09/2017 09:13 AM, armand pirvu wrote: On Jun 9, 2017, at 11:01 AM, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 06/09/2017 08:45 AM, armand pirvu wrote: Hi Had a couple of processes blocking the vacuum so I terminated them using select pg_terminate_backend(pid)

Re: [GENERAL] Vacuum and state_change

/docs/9.6/static/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW Thank you Armand -- Adrian Klaver adrian.kla...@aklaver.com -- 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_upgrade --link on Windows

aa363860(VS.85).aspx 307 */ 308 if (CreateHardLinkA(dst, src, NULL) == 0) 309 { 310 _dosmaperr(GetLastError()); 311 return -1; 312 } 313 else 314 return 0; 315 } 316 #endif Regards -- Arnaud -- Adrian Klaver adrian.kla...@aklaver.com

Re: [GENERAL] pg_upgrade --link on Windows

e junction and then the directory it points to. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Performance issue with Pointcloud extension

been able to debug this up to now. Oops on my part. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Performance issue with Pointcloud extension

g this? This has been driving us crazy for some time now. Looks like you also have postgis and pointcloud_postgis in mix. I would say this may get an answer sooner here: http://lists.osgeo.org/mailman/listinfo/pgpointcloud/ Thanks. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via

Re: [GENERAL] Weirdness with "not in" query

irdness-with-not-in-query-tp5965573.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

On 06/08/2017 08:13 AM, ADSJ (Adam Sjøgren) wrote: Achilleas writes: Anyone has a handy little script lying around? http://www.databasesoup.com/2013/10/de-corrupting-toast-tables.html Thanks for the response! Adam -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via

Re: [GENERAL] Redo the filenode link in tablespace

also think about moving the tables to a new tablespace to get a clean tablespace directory. Again this assumes space available. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Redo the filenode link in tablespace

I am betting. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Advisory lock deadlock issue

. While this move is happening it takes a standard Postgres advisory locks ..." Thanks, DR -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Redo the filenode link in tablespace

35.183.360 5214495.4 422 File(s) 445.600.333.824 bytes 2 Dir(s) 198.487.891.968 bytes free 2017-06-06 16:37 GMT-03:00 Adrian Klaver <mailto:adrian.kla...@aklaver.com>>: On 06/06/2017 11:09 AM, tel medola wrote: I will not be able to recover my informat

Re: [GENERAL] Redo the filenode link in tablespace

ode is for the TOAST table and then have you look for it or maybe change it. 2017-06-06 10:37 GMT-03:00 Adrian Klaver <mailto:adrian.kla...@aklaver.com>>: On 06/06/2017 04:40 AM, tel medola wrote: Lets go: In my plsql: rai=# select oid, * from pg_clas

Re: [GENERAL] Redo the filenode link in tablespace

| 0 | t | f | p | r |7 | 0 | f | t | f | f | f | t | 9360288 | 1 || (1 registro) Ok? -- Adrian Klaver adrian.kla...@aklaver.com

  1   2   3   4   5   6   7   8   9   10   >