[GENERAL] starting PG command line options vs postgresql.con

-archive.org/PostgreSQL-general-f1843780.html -- 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] Fwd: SPI_palloc problem

On Sun, Oct 29, 2017, at 07:40 PM, Aron Widforss wrote: > I mailed this from my main email address instead of the one I'm > subscribed to pgsql-general with. So, here goes. > > - Original message - > From: Aron Widforss > To: pgsql-general@postgresql.org > S

Re: [GENERAL] Comparing epoch to timestamp

Sorry, I probably had to call: # EXPLAIN SELECT ARRAY_AGG(hashed) FROM words_nouns WHERE EXTRACT(EPOCH FROM added) > 0 UNION SELECT ARRAY_AGG(hashed) FROM words_verbs WHERE EXTRACT(EPOCH FROM adde

[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 caught/c

[GENERAL] Comparing epoch to timestamp

Hello, in PostgreSQL 9.5 I have a table with 67000 records: # \d words_nouns Table "public.words_nouns" Column | Type | Modifiers -+--+--- word| text | not null hashed | text |

Re: [GENERAL] Old pg_clog files

On 10/29/2017 03:37 PM, David G. Johnston wrote: On Sunday, October 29, 2017, Ron Johnson > wrote: Hi, v8.4.17 http://www.postgresql-archive.org/pg-clog-questions-td2080911.html

Re: [GENERAL] Old pg_clog files

On Sunday, October 29, 2017, Ron Johnson wrote: > Hi, > > v8.4.17 > > http://www.postgresql-archive.org/pg-clog-questions-td2080911.html > > According to this old thread, doing a VACUUM on every table in the > postgres, template1 and TAPd databases should remove old pg_clog files. > > > However,

[GENERAL] Old pg_clog files

Hi, v8.4.17 http://www.postgresql-archive.org/pg-clog-questions-td2080911.html According to this old thread,  doing a VACUUM on every table in the postgres, template1 and TAPd databases should remove old pg_clog files. postgres=# SELECT datname, age(datfrozenxid) FROM pg_database;   datname 

[GENERAL] Fwd: SPI_palloc problem

I mailed this from my main email address instead of the one I'm subscribed to pgsql-general with. So, here goes. - Original message - From: Aron Widforss To: pgsql-general@postgresql.org Subject: SPI_palloc problem Date: Sun, 29 Oct 2017 19:35:30 +0100 Good evening, I'm rea

Re: [GENERAL] Where to find development builds of pg for windows

On Sat, Oct 28, 2017 at 02:18:52AM -0700, legrand legrand wrote: > Subject: Re: [GENERAL] Where to find development builds of pg for windows ... > I will be [...] pg 10 new features testing You can't because it's released. If you need dev builds of PG10 you'll probably have

Re: [GENERAL] Where to find development builds of pg for windows

Thanks, Yes I will be busy with pg 10 new features testing ;o) Nb: I also have installed a unix partition to be able to test non-core extensions and prototypes Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing

Re: [GENERAL] Where to find development builds of pg for windows

On Sat, Oct 14, 2017 at 12:18 AM, legrand legrand < legrand_legr...@hotmail.com> wrote: > Hello, > > Using PG mainly on windows, I would have liked to test new releases / > development versions before they are available in > https://www.postgresql.org/download/windows/ > > Are there some build far

Re: [GENERAL] Why does a SELECT query cause "dirtied" buffers?

On Fri, Oct 27, 2017 at 09:24:40PM +0200, Thomas Kellerer wrote: > Under which situation does a SELECT query change a block? https://wiki.postgresql.org/wiki/Hint_Bits -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: h

[GENERAL] Why does a SELECT query cause "dirtied" buffers?

surprised why a SELECT (read-only) query would cause buffers to be dirtied? Under which situation does a SELECT query change a block? Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] BDR question on dboid conflicts

mydb | t | 9602 | | 7750 | 0/2D4E780 | 0/2D4E7B8 bdr_20227_6480169638493465053_1_20225__ | bdr| logical | 20227 | mydb | t | 9601 | | 7750 | 0/2D4E780 | 0/2D4E7B8 -Original Message- From: pgsql-general-ow...@postgresq

[GENERAL] controlling users to audit in pgaudit

users. thanks -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- 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] Announcing PostgreSQL SLES RPM Repository

ardware, and let me to use my time for these packages, so I want to thank > EDB. Thanks to both you and EDB! -- 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] query not scaling

ng > to prove. This is extremely obnoxious. Is it possible to raise a warning on function creation? > (In any case, it's usually easy enough to tell from EXPLAIN output > whether inlining has happened.) No it isn't. The explain syntax is arcane and inlining as a general con

Re: [GENERAL] Question regarding logical replication

evict the log pages early after sync. Francisco Olarte. -- 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

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

[GENERAL] Function

Good morning for all I´m beginer in PL/pgSQL functions and I have one difficulty. The function bellow should return many records but return just one. The loop just do the first INSERT INTO and get out. CREATE OR REPLACE FUNCTION geo_output.funcao30(num integer) RETURNS TABLE (quadro_id integer,

Re: [GENERAL] Question regarding logical replication

(ship) it and for log based replication slots ), but postgres recycles segments ( which can have an impact on big memory machines ). I do not know to what extent a modern OS can detect the access pattern and do things like evict the log pages early after sync. Francisco Olarte. -- Sent via pgsql

Re: [GENERAL] Question regarding logical replication

little lag but being forced to read from disk (make the server do it ) when it falls behind. Francisco Olarte. -- 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] Question regarding logical replication

t; which leads to higher throughput. Have you accounted for disk caching? Your CDC may be getting log from the cache when going with little lag but being forced to read from disk (make the server do it ) when it falls behind. Francisco Olarte. -- Sent via pgsql-general mailing list (pgsql-gener

Re: [GENERAL] Can't build ODBC -- odbc_config not found

On 10/27/2017 12:39 AM, Devrim Gündüz wrote: On Thu, 2017-10-26 at 23:40 -0700, Chris Albertson wrote: I just tried to build Postgres ODBC from source (psqlodbc-10.00..tar.gz) I type "./configure" Then get this message: configure: error: odbc_config not found (required for unixODBC build)

Re: [GENERAL] Can't build ODBC -- odbc_config not found

Hi, On Thu, 2017-10-26 at 23:40 -0700, Chris Albertson wrote: > I just tried to build Postgres ODBC from source (psqlodbc-10.00..tar.gz) > > I type "./configure" > > Then get this message: > configure: error: odbc_config not found (required for unixODBC build) > > So it must be looking for

Re: [GENERAL] Can't build ODBC -- odbc_config not found

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

[GENERAL] Can't build ODBC -- odbc_config not found

t is needed. -- Chris Albertson Redondo Beach, California -- 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] BDR question on dboid conflicts

the rest of the (sysid,timeline,dboid) tuple. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- 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] 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 at all --- not with IMMUTABL

[GENERAL] Combing row returning functions using "ROWS FROM"?

I just noticed the reference to combining set returning functions using “ROWS FROM” at https://www.postgresql.org/docs/10/static/queries-table-expressions.html#queries-tablefunctions I have not pr

Re: [GENERAL] Bucardo syncrun

er of rows deleted, you should also: vacuum full bucardo.syncrun; The data in that table is not critical to Bucardo running - it is mostly used for the output of "bucardo status" and for auditing of past syncs. P.S. Bucardo has its own mailing list: bucardo-gene...@bucardo.org, which in gener

[GENERAL] Announcing PostgreSQL SLES RPM Repository

Hi, I am proud to announce the new and shiny PostgreSQL RPM repository for SLES 12: https://zypp.postgresql.org/. The new repo contains (almost) all of the packages that the PostgreSQL YUM repository has (https://yum.PostgreSQL.org) . Currently. we support PostgreSQL 10, 9.6 and 9.5, along with

Re: [GENERAL] Question regarding logical replication

enough free space, you could get your partition full of xlog. Regards, Alvaro Aguayo Operations Manager Open Comb Systems E.I.R.L. Office: (+51-1) 3377813 | Mobile: (+51) 995540103 | (+51) 954183248 Web: www.ocs.pe - Original Message ----- From: "Weiping Qu" To: "PostgreS

Re: [GENERAL] Question regarding logical replication

rds, Alvaro Aguayo Operations Manager Open Comb Systems E.I.R.L. Office: (+51-1) 3377813 | Mobile: (+51) 995540103 | (+51) 954183248 Web: www.ocs.pe - Original Message - From: "Weiping Qu" To: "PostgreSql-general" Sent: Thursday, 26 October, 2017 14:07:54 Subjec

[GENERAL] Question regarding logical replication

no slave reading/dequeuing data out of this slot or very slowly, thus incurring high I/Os and slow down the transaction throughput? Looking forward to your explanation. Kindly review and please share your comments on this matter. -- Sent via pgsql-general mailing list (pgsql-general

[GENERAL] Bucardo syncrun

Hi, Can I purge data on Postgrebucardo table syncrun ? If I will follow this steps: bucardo stop psql bucardo truncate bucardo.syncrun ; \q bucardo start The steps to purge all past data that table. Is correct? Is this Simple method? -- *Atenciosamente,Emanuel Araújo* *Linux Certified, D

[GENERAL] BDR question on dboid conflicts

Database oid is used in both bdr.bdr_nodes, as node_dboid, and bdr.bdr_connections, as conn_dboid, also used in construction of replication slot names. I noticed that when trying to join a bdr group, if the database oid on the new node happens to be the same as that of an node already in the bd

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 at all --- not with IMMUTAB

Re: [GENERAL] query not scaling

ther inlining has happened.) regards, tom lane -- 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] query not scaling

MMUTABLE. > > Yours, > Laurenz Albe The explain analyze was (maybe is)still running but without buffers. Thought of the immutable bit. Will be doing that test. All tables vacuumed and analyzed with each structural change. Thanks -- 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] Making subscribers read only in Postgres 10 logical replication

t http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- 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] query not scaling

e all optimizer database parameters identical? Also, to have PostgreSQL inline the function, which would be good for performance, it should be declared IMMUTABLE. Yours, Laurenz Albe -- 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 do I insert and update into a table of arrays of composite types via a select command?

Yes, thanks - that's nicer - I am now using: insert into t_array select array[data_comp]::mytype[] from t_composite; On Wed, Oct 25, 2017 at 5:25 PM, Tom Lane wrote: > "David G. Johnston" writes: > > On Wed, Oct 25, 2017 at 2:16 PM, Celia McInnis > >> Got it, finally... > >> insert into t_a

Re: [GENERAL] How do I insert and update into a table of arrays of composite types via a select command?

umn of a composite type, you probably don't need all that notation anyway --- seems like array[data_comp::my_type] or array[data_comp]::my_type[] ought to work. regards, tom lane -- 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 do I insert and update into a table of arrays of composite types via a select command?

On Wed, Oct 25, 2017 at 2:16 PM, Celia McInnis wrote: > Got it, finally... > > insert into t_array select array[row((data_comp).*)::mytype[] from > t_composite; > > I'm not sure why I need (data_comp).* rather than some of the other things > that I tried and failed with... > > ​The ​unusual set o

Re: [GENERAL] How do I insert and update into a table of arrays of composite types via a select command?

Got it, finally... insert into t_array select array[row((data_comp).*)::mytype[] from t_composite; I'm not sure why I need (data_comp).* rather than some of the other things that I tried and failed with... On Wed, Oct 25, 2017 at 3:47 PM, Tom Lane wrote: > Celia McInnis writes: > > My first q

[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 p

Re: [GENERAL] How do I insert and update into a table of arrays of composite types via a select command?

Thanks Tom - I saw how to do that for specified data, but I want to select the elements from a table of composite and don't know how to do that. I can't do insertions manually of each row separately! So how do I get material from my table of composite values into my table of array values? I am run

Re: [GENERAL] How do I insert and update into a table of arrays of composite types via a select command?

27;c')::mytype,row('d','e','f')::mytype]; INSERT 0 1 or just cast the whole ARRAY[] construct: regression=# insert into t_array select array[row('a','b','c'),row('d','e','f')]::mytype[]; INSERT 0 1 alt

[GENERAL] How do I insert and update into a table of arrays of composite types via a select command?

I have a composite type like this, for example: create type mytype(a text, b text, c text); and a table create table t_cols(a text,b text,c text); containing some data. I have a table with my composite type: create table t_composite(data_comp mytype); and loaded data into it like so: insert

Re: [GENERAL] Installing PostgreSQL 10 on Mac OSX Undefined Symbol _heap_modify_tuple_by_cols

to clarify, I commented them out, hence the # - it wasn't that I removed lines that were already commented out :) On 25 October 2017 at 22:21, Ben Madin wrote: > G'day Tom, > > Thanks for the feedback. I couldn't find anywhere that suggested that I > had set the CPPFLAGS or CFLAGS environment va

Re: [GENERAL] Installing PostgreSQL 10 on Mac OSX Undefined Symbol _heap_modify_tuple_by_cols

G'day Tom, Thanks for the feedback. I couldn't find anywhere that suggested that I had set the CPPFLAGS or CFLAGS environment variables, so I removed the following lines from my profile: #export USE_PGXS=1 #export PG_LIB_DIR="/usr/local/pgsql/lib" #export PG_CONFIG="/usr/local/pgsql/bin/pg_config

Re: [GENERAL] libpq: PQreset not reconnecting connection, even though server is running

send" on this email light dawned: the code that calls our "creates db connection" function is not checking the return value correctly, and PQreset fails because our that function wipes out the connection object (assuming that it cannot be used). Sorry to waste bandwidth. Geoff

[GENERAL] libpq: PQreset not reconnecting connection, even though server is running

eeded, is that the problem? Will PQreset only work on a connection that had previously connected successfully? If that _is_ the case, is there a way to tell up-front whether this is the case (so I can retry PQconnectdb instead of calling PQreset)? Thanks Geoff -- Sent via pgsql-general m

Re: [GENERAL] Allow only certain query on replication slave

On Tue, Oct 24, 2017 at 8:12 AM, basti wrote: > > > Is there a way to allow only the above query and deny all other? > Probably easiest to just configure your HBA to restrict all connections/uses except the one that does your xlog query checks. Don. -- Don Seiler www.seiler.us

[GENERAL] Create database from template and include comment

Hi all If when creating a database I use another user-defined database as a template I would like the option for the comment on the template database to also exist for the new database. Am I correct in thinking there is no feature for this, perhaps because the global nature of pg_shdescription?

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

y of grief for my use case. Consider this question resolved ( -- 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 conda environment for plpython3u?

complex > external systems, and would generally prefer to do that sort of thing in an > app server context outside the DB server. > > > > -- > john r pierce, recycling bits in santa cruz > > > > -- > 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] Allow only certain query on replication slave

can be used in the planner hook to check for those functions and accept them. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Allow only certain query on replication slave

and deny all other? Best Regards, basti -- 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] Backup strategy using 'wal_keep_segments'

Thanks very much for your reply Michael. I note that it looks like pgbarman employs pg_receivexlog; I will check it out. Regards, Ruan From: Michael Paquier Sent: 22 October 2017 22:17:01 To: Rhhh Lin Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL

Re: [GENERAL] Two versions of an extension in the same cluster?

te. There was a thread not too long ago concerning somebody who was putting version numbers in his shlib name, and it was breaking things, and the general recommendation was "so don't do that". I don't recall the details but you'd be well advised to check the archives bef

[GENERAL] Two versions of an extension in the same cluster?

teger AS 'example', 'myfunc_v2_0_0' LANGUAGE c IMMUTABLE; # example--3.0.0.sql CREATE OR REPLACE FUNCTION myfunc(anyarray) RETURNS integer AS 'example', 'myfunc_v3_0_0' LANGUAGE c IMMUTABLE; Thanks, Paul -- Sent via pgsql-gener

Re: [GENERAL] multiple sql results to shell

On Oct 23, 2017, at 08:37, pgsql-general-ow...@postgresql.org<mailto:pgsql-general-ow...@postgresql.org> wrote: psql . | while read a; do #some code done The only problem I find with this is that you can't pass variables out of the while loop, To get input from a file w/o

Re: [GENERAL] using conda environment for plpython3u?

context outside the DB server. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] using conda environment for plpython3u?

Is it possible for users to use their conda environment for plpython, complete with the modules that they have loaded in that environment? If so, what do I do? I am running postgres 9.6.2 and would like to use a conda environment for python 3.6 which contrains a fair number of modules that I want

Re: [GENERAL] Installing PostgreSQL 10 on Mac OSX Undefined Symbol _heap_modify_tuple_by_cols

rocess) or is something else unusual? I believe the configure script *does* pay attention to environment variables, particularly CPPFLAGS and CFLAGS. Most likely you had version-specific values in those when you ran configure, and they got absorbed into src/Makefile.global. re

Re: [GENERAL] table corruption

e most important check here. -- Peter Geoghegan -- 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] table corruption

in mind, since that's such a can > of worms, but it might still help you. > > -- > Peter Geoghegan > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-gen

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

7;ll have to reload your databases from backups. But I would be concerned that the disk structure is damaged. I would run e2fsck on it - and if there are lots of errors found I wouldn't use it. George -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

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

OK, cheers. How can I remove the db so I can restore it properly? From: Scott Mead Date: Monday, 23 October 2017 at 16:35 To: Martin Moore Cc: Michael Nolan , "pgsql-general@postgresql.org" Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare On Mon, Oct 2

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

52 > *To: *Martin Moore > *Cc: *rob stone , "pgsql-general@postgresql.org" < > pgsql-general@postgresql.org> > *Subject: *Re: [GENERAL] Postgres 9.6 fails to start on VMWare > > > > > > > > On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore > wrote:

Re: [GENERAL] table corruption

gt; backup/source data, instead of restoring the whole table? You might find the latest version of amcheck helpful here: https://github.com/petergeoghegan/amcheck It's not really written with repair in mind, since that's such a can of worms, but it might still help you. -- Peter Geoghegan --

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

It was running – not sure how dd handles this. Maybe badly… ☺ From: Michael Nolan Date: Monday, 23 October 2017 at 15:52 To: Martin Moore Cc: rob stone , "pgsql-general@postgresql.org" Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare On Mon, Oct 23, 2017

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

On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore wrote: > Same server. I tried a few times. > > I didn’t move the db separately, but did a ‘dd’ to copy the disk to an > imagefile which was converted and loaded into VMWare. > > I ‘believed’ that this should keep the low level disk structure the same,

[GENERAL] table corruption

Hi, we have a table with around 1.6 billion rows having quite lot of big binary data toasted. Today we started getting: WIB > ERROR: invalid page in block 1288868309 of relation base/96031/96201 Which is a toast reltype. I know that zero_damaged_pages and vacuum (or restore the table from back

[GENERAL] Matching statement and duration log lines

Hello! I am sending PG logs to Elasticsearch and want to merge a line with statement and a line with duration into one document. Having a statement line and a duration line, can I assume that if a session ids (%c) of these lines match, and numbers of log lines (%l) are consecutive, then the dura

[GENERAL] Is it safe to create foreign keys beforehand when logical replication is used?

Hi, I'm trying to figure out whether the following is safe or not on all conditions with logical replication: -- on the source (localhost:5432), create the tables which have foreign keys among them -- load some data and create publication CREATE TABLE rep_test (a int PRIMARY KEY); CREATE TABLE

Re: [GENERAL] A question on pg_stat_subscription view

Hi, Thanks for the reply, however, the documentation does not mention about that clearly. It only mentions that 'latest_end_lsn' is the `Last write-ahead log location reported to origin WAL sender`. However, what I'm particularly interested is that whether the reported log is the flushed or appl

Re: [GENERAL] multiple sql results to shell

ents where source_id = $SOURCE_ID and ineffective_date is null" | while true; do if [ $a -gt $biga ] ; then biga=$a fi if ! read a; then echo $biga; break; fi done ) A mess, but it works. To be honest, by the time you've got to this level of complexity you probably sho

Re: [GENERAL] multiple sql results to shell

On Mon, Oct 23, 2017 at 7:08 AM, Mark Lybarger wrote: > 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. >

[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] Postgres 9.6 fails to start on VMWare

exactly how you moved the database from Google Compute to this VM machine. Cheers, robert -- 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] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)

Great! No worries, after work I will start with some surveys about how to package Postgres extension, and get it onto pgxn. Thanks Juliano Original Message > Subject: Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support > pgagent (jobs) > Local Time

[GENERAL] Installing PostgreSQL 10 on Mac OSX Undefined Symbol _heap_modify_tuple_by_cols

G'day, we are quite excited about the parallelisation enhancements, and keen to try, but trying to build (using the same configure as we have used for 9.6) is giving some warnings and errors. The detail is below, but the oddity I'm really wondering about is the reference in the command to /usr/lo

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

mpting to start it at 2017-10-22 14:08:28 UTC? One minute and eight seconds later. It might also help if you explained exactly how you moved the database from Google Compute to this VM machine. Cheers, robert -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

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

n this world (I am referring to quiesced snapshot & co). -- Michael -- 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] Backup strategy using 'wal_keep_segments'

logic is copying. So I would advise to not do that. Instead of using the archive command, you should also consider using pg_receivexlog combined with a replication slot. This brings way more control with the error handling. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgres

[GENERAL] Backup strategy using 'wal_keep_segments'

Hi, Version 9.4... Per the PG docs, to facilitate continuous WAL archiving and PITR recovery... "To enable WAL archiving, set the wal_level configuration parameter to archive (or hot_standby), archive_mode to on, and specify the shell command to use in the archive_command configuration paramet

Re: [GENERAL] parray_gin and \d errors in PG10

I wrote: > Or maybe what we should do is to avoid @> in favor of using > ('d' = any(stxkind)) Pushed that way. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http:/

Re: [GENERAL] tgrm index for word_similarity

al: http://www.postgrespro.com Russian Postgres Company -- 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 login user name and host name in pgaudit

pgaudit/pgaudit#format 2 - https://www.postgresql.org/docs/10/static/runtime-config-logging.html#guc-log-line-prefix -- Arthur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make c

Re: [GENERAL] parray_gin and \d errors in PG10

this is such a mess points up why trying to alias polymorphic operators isn't such a hot idea. parray_gin really ought to get rid of that operator. regards, tom lane -- 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] parray_gin and \d errors in PG10

Y 1; ERROR: operator is not unique: "char"[] @> "char"[] LINE 6: (stxkind @> '{d}'::pg_catalog."char"[]) AS ndist_enabled, ^ HINT: Could not choose a best candidate operator. You might need to add explicit type casts. Justin -- 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] parray_gin and \d errors in PG10

for me without parray_gin installed, but I wonder whether it fails due to ambiguity if you do have parray_gin installed. In principle this'd still match the text[] @> text[] operator, and I'm not sure whether we have an ambiguity resolution rule that would prefer one over the

[GENERAL] parray_gin and \d errors in PG10

---+-- (0 rows) Is this to be considered an issue with parray_gin or with psql ? I don't think that's an urgent problem to fix, but if someone has a workaround for \d I would appreciate if you'd pass it along :) Thanks in advance Justin -- 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] Re: Restoring tables with circular references dumped to separate files

mented as compressed BY DEFAULT, but you can use options to avoid compression, and it is the only one which supports paralell dumps. Also, custom and tar can be made uncompressed, but I do not think that's a great idea. Francisco Olarte. -- Sent via pgsql-general mailing list (pgsq

[GENERAL] Postgres 9.6 fails to start on VMWare

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

[GENERAL] How to get login user name and host name in pgaudit

joined with pg_ views to convert it into login user name and host name. any pointers on how to get it done. thanks. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

<    1   2   3   4   5   6   7   8   9   10   >