[GENERAL] Migration to pglister - Before

Greetings, We will be migrating these lists to pglister in the next few minutes. This final email on the old list system is intended to let you know that future emails will have different headers and you will need to adjust your filters. The changes which we expect to be most significant to user

Re: [GENERAL] Query Using Massive Temp Space

by limiting the number of lines from candidates by ... *FROM match_candidate_address WHERE account_id NOT IN (:exclude_ids) limit 100 * ) Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list (pgsql-general

[GENERAL] Registering Event Log on Windows

Hi Guys, I'm trying to register the event log on Windows ( Windows Server 2012 64-bit ) with the following command: regsvr32.exe C:\PostgreSQL\pg96\lib\postgresql\pgevent.dll and I'm recieving an error message: The modoule "C:\PostgreSQL\pg96\lib\postgesql\pgevent.dll" was loaded but the entry po

Re: [GENERAL] Query Using Massive Temp Space

columns) out of this named query on this ids if it is possible. You also avoid of hash indexing of these nine columns so you will save certain ammount of memory. Miloslav From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Cory Tucker Sent: Monday

Re: [GENERAL] unnest-like pg_stats.most_common_values and pg_stats.most_common_freqs

tween the two array indexes. Is it something achievable in SQL? Or should I use a plpgsql loop with an index? Luca -- 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 Using Massive Temp Space

Do determine what is going on, EXPLAIN (ANALYZE, BUFFERS) output would be useful. 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

[GENERAL] Query Using Massive Temp Space

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 store multiple rows in array .

tems$inv_lines_rt composite type, that type is what determines the column names. 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 to store multiple rows in array .

uot; LINE 73: COL1,COL2, COUNT(*) AS txn_cnt... Why "AS" is throwing an error ? -- 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] parallel query in 9.6.6 + oracle_fdw -> ERROR: invalid cache ID: 41

Thanks, Chris. -- 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] parallel query in 9.6.6 + oracle_fdw -> ERROR: invalid cache ID: 41

d, for example. (I'd bet that adding oracle_fdw to shared_preload_libraries would fail badly, though perhaps not with this exact error message.) So I'd call this an oracle_fdw bug. It needs to postpone what it's doing here to the first normal FDW function call in a session.

Re: [GENERAL] How to store multiple rows in array .

, declare myarray rowtypename[]; ... select array(select row(col1, ...)::rowtypename from ...) into myarray; regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postg

[GENERAL] parallel query in 9.6.6 + oracle_fdw -> ERROR: invalid cache ID: 41

#11 0x006a722a in maybe_start_bgworkers () at postmaster.c:5809 #12 0x006a7cf3 in sigusr1_handler (postgres_signal_arg=) at postmaster.c:4990 #13 #14 0x7f16a1007783 in __select_nocancel () from /lib64/libc.so.6 #15 0x006a80e5 in ServerLoop () at postmaster.c:1683 #16 0x000

Re: [GENERAL] How to store multiple rows in array .

2017-11-19 18:57 GMT+01:00 Brahmam Eswar : > Hi , > > System is migrating from Oracle to Postgre SQL. > Oracle is providing BULK COLLECT INTO function to collect the multiple > records from table . > > Select COL1,COL2 ,COL3 BULK COLLECT INTO LINES from Distinct_Records. > > LINES IS TABLE OF TA

[GENERAL] How to store multiple rows in array .

Hi , System is migrating from Oracle to Postgre SQL. Oracle is providing BULK COLLECT INTO function to collect the multiple records from table . Select COL1,COL2 ,COL3 BULK COLLECT INTO LINES from Distinct_Records. LINES IS TABLE OF TABLE1 (Defined lines as IS TABLE OF type). In PotGres:

Re: [GENERAL] mild modification to pg_dump

On Fri, Nov 17, 2017 at 3:58 PM, marcelo wrote: > Again: knowing of .pgpass (thank you Scott) this is what I will do. > > Just in case you might not know. The perms of the .pgpass file need to not have group or all write access. For instance: chmod 0600 .pgpass -m

[GENERAL] Changing the location of the default data directory on PG 9.6.6 (CentOS 7)?

I'm trying to identify which postgresql.conf file I should be editing, in order to change the default database files location for Postgres 9.6.6, when installed on CentOS 7.x/ Is the bet method for changing the default data directory at the time of database init, to include the $PGDATA variable

Re: [GENERAL] mild modification to pg_dump

On 2017-11-17 18:56:45 -0300, marcelo wrote: > Truly, I'm catched in a very big app, so I have no time to read all > the docs. People on this list also have jobs. - Andres -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

Re: [GENERAL] mild modification to pg_dump

ctual dump rather than try and incorporate its source code into your app. Specifically, do you mean to write a simple daemon which forks pg_dump at the appropriate time? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] mild modification to pg_dump

). I would just fork pg_dump to do the actual dump rather than try and incorporate its source code into your app. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org <mailto:pgsql-general@postgresql.org>) To make changes to your sub

Re: [GENERAL] mild modification to pg_dump

t same data, >>> of course, encripted to the common users). >>> >> >> >> I would just fork pg_dump to do the actual dump rather than try and >> incorporate its source code into your app. >> >> >> > > > -- > Sent via pgsql-general

Re: [GENERAL] mild modification to pg_dump

e code into your app. -- World Peace Through Nuclear Pacification -- 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] mild modification to pg_dump

ctual dump rather than try and incorporate its source code into your app. Specifically, do you mean to write a simple daemon which forks pg_dump at the appropriate time? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] mild modification to pg_dump

My apps are using that same data, >>> of course, encripted to the common users). >>> >> >> >> I would just fork pg_dump to do the actual dump rather than try and >> incorporate its source code into your app. >> >> >> > > > -- > 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] mild modification to pg_dump

apps are using that same data, of course, encripted to the common users). I would just fork pg_dump to do the actual dump rather than try and incorporate its source code into your app. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

Re: [GENERAL] mild modification to pg_dump

write a simple daemon which forks pg_dump at the appropriate time? -- World Peace Through Nuclear Pacification -- 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] unnest-like pg_stats.most_common_values and pg_stats.most_common_freqs

pgsql_call_handler,plpython2_call_handler,plpython3_call_handler,plpython_call_handler,pltcl_cal l_handler,pltclu_call_handler} Justin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] unnest-like pg_stats.most_common_values and pg_stats.most_common_freqs

the right type array) Thanks, Luca -- 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] mild modification to pg_dump

ch do that, and his password. (My apps are using that same data, of course, encripted to the common users). I would just fork pg_dump to do the actual dump rather than try and incorporate its source code into your app. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-ge

Re: [GENERAL] mild modification to pg_dump

he source, download the source tarball: https://www.postgresql.org/ftp/source/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org <mailto:pgsql-general@postgresql.org>) To make changes to your subscription: http://www.postgresql.org/mailpre

[GENERAL] explain analyze output with parallel workers - question about meaning of information for explain.depesz.com

+ 1". Is that really the case? Should I, for explain.depesz.com, when dealing with partial* and parallel* nodes, use "loops=1" for calculation of exclusive/inclusive time? always? some other nodes? or am I missing something in here? Best regards, depesz -- Sent via p

Re: [GENERAL] mild modification to pg_dump

ick and easy fix for whatever you're doing without modifying pg_dump itself. That being said, if you really want to modify the source, download the source tarball: https://www.postgresql.org/ftp/source/ > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgr

[GENERAL] mild modification to pg_dump

I would need to do a mild change to pg_dump, working against a 9.4 server on linux. Which source tree do I need? Have gcc 4.9.2 in my Lubuntu installation. TIA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

.. Hm, so that's another angle David didn't report on: is it possible that his workload could have resulted in a very large volume of incomplete in-progress log messages? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

. (That doesn't >preclude other mitigation measures.) It doesn't seem impossible to get into a situation where syslogger is the source of the OOM. Just enabling a lot of logging in a workload with many large query strings might do it. So making it less likely to be killed might

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

I think we'd be better off trying to prevent OOM kills on the syslogger. (That doesn't preclude other mitigation measures.) 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] postmaster deadlock while logging after syslogger exited

fair amount of memory. Note that we're using plain stringinfos that ereport(ERROR) out of memory situations, rather than failing more gracefully. - Andres -- 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] postmaster deadlock while logging after syslogger exited

ight be worth thinking about is allowing the syslogger process to inherit the postmaster's OOM-kill-proofness setting, instead of dropping down to the same vulnerability as the postmaster's other child processes. That presumes that this was an otherwise-unjustified OOM kill, which I

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

t; > I can't follow. The syslogger pipe is created when the first syslogger > is started (before it's forked!). Which happens before other processes > are created, because they all need to inherit that file descriptor. Ah, OK. I didn't recall this dependency. Sorry for the con

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

need to inherit that file descriptor. > So you'd need proper locking to save from race conditions. I completely fail to see why this'd be the case. All I'm talking about is using another pipe between syslogger and postmaster than between other-processes and syslogger. Greetings, Andres Freund -- 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] postmaster deadlock while logging after syslogger exited

ue because the first process generating a message to the syslogger pipe needs to open it first if not done yet? So you'd need proper locking to save from race conditions. Or is the first message redirected message always generated by the postmaster or the syslogger? I don't recall that this

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

ion like that if we made postmaster use a *different* pipe as stderr than the one we're handing to normal backends. If postmaster created a new pipe and closed the read end whenever forking a syslogger, we should get EPIPEs when writing after syslogger died and could fall back to proper stderr or

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

On Mon, Nov 6, 2017 at 12:35 PM, Tom Lane wrote: > David Pacheco writes: > > I ran into what appears to be a deadlock in the logging subsystem. It > > looks like what happened was that the syslogger process exited because it > > ran out of memory. But before the postmaster got a chance to hand

Re: [GENERAL] pg_restore load data

On 11/16/2017 03:13 PM, bricklen wrote: On Thu, Nov 16, 2017 at 1:07 PM, Ron Johnson > wrote: v9.2.7  (Yes, I know, it's old.  Nothing I can do about it.) During a "whole database" restore using pg_restore of a custom dump, when is the data actually l

Re: [GENERAL] pg_restore load data

The command is COPY, not load. Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone Original message From: Ron Johnson Date: 11/16/17 16:07 (GMT-05:00) To: pgsql-general@postgresql.org Subject: [GENERAL] pg_restore load data Hi, v9.2.7  (Yes, I know, it&#

Re: [GENERAL] pg_restore load data

On Thu, Nov 16, 2017 at 1:07 PM, Ron Johnson wrote: > v9.2.7 (Yes, I know, it's old. Nothing I can do about it.) > > During a "whole database" restore using pg_restore of a custom dump, when > is the data actually loaded? I've looked in the list output and don't see > any "load" statements. >

[GENERAL] pg_restore load data

Peace Through Nuclear Pacification -- 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] expanded auto and header linestyle double

2017-11-16 21:16 GMT+01:00 Matt Zagrabelny : > Thanks for the reply, Pavel! > > On Thu, Nov 16, 2017 at 1:01 AM, Pavel Stehule > wrote: > >> Hi >> >> 2017-11-15 23:37 GMT+01:00 Matt Zagrabelny : >> >>> Greetings, >>> >>> Using PG 10.1. >>> >>> In my .psqlrc I have: >>> >>> \x auto >>> \pset lines

Re: [GENERAL] expanded auto and header linestyle double

Thanks for the reply, Pavel! On Thu, Nov 16, 2017 at 1:01 AM, Pavel Stehule wrote: > Hi > > 2017-11-15 23:37 GMT+01:00 Matt Zagrabelny : > >> Greetings, >> >> Using PG 10.1. >> >> In my .psqlrc I have: >> >> \x auto >> \pset linestyle 'unicode' >> \pset unicode_header_linestyle double >> >> and

Re: [GENERAL] Build in function to verify email addresses

On Thu, Nov 16, 2017 at 1:56 AM, Nick Dro wrote: > I beleieve that every information system has the needs to send emails. > Currently PostgreSQL doesn't have a function which gets TEXT and return > true if it's valid email address (x...@yyy.com / .co.ZZ) > Do you believe such function should exis

Re: [GENERAL] Build in function to verify email addresses

-Valid-1.202/lib/Email/Valid.pm <http://search.cpan.org/~rjbs/Email-Valid-1.202/lib/Email/Valid.pm>   Regards   Pavel   In general, I see no reason for a modern RDBMS not to provide an email-datatype. IMV that's no different from other types which also could have been plain-text but ar

Re: [GENERAL] Build in function to verify email addresses

- Original Message - From: "Nick Dro" To: pgsql-general@postgresql.org Sent: Thursday, November 16, 2017 2:56:42 AM Subject: [GENERAL] Build in function to verify email addresses I beleieve that every information system has the needs to send emails. Currently PostgreS

Re: [GENERAL] Build in function to verify email addresses

doesn't have a function which gets TEXT and return true if it's valid email address (x...@yyy.com / .co.ZZ) Do you believe such function should exist in PostgreSQL or it's best to let every user to implement his own function? -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] Build in function to verify email addresses

Hi 2017-11-16 8:56 GMT+01:00 Nick Dro : > I beleieve that every information system has the needs to send emails. > Currently PostgreSQL doesn't have a function which gets TEXT and return > true if it's valid email address (x...@yyy.com / .co.ZZ) > Do you believe such function should exist in Post

[GENERAL] Build in function to verify email addresses

I beleieve that every information system has the needs to send emails. Currently PostgreSQL doesn't have a function which gets TEXT and return true if it's valid email address (x...@yyy.com / .co.ZZ) Do you believe such function should exist in PostgreSQL or it's best to let every user to implement

Re: [GENERAL] expanded auto and header linestyle double

Hi 2017-11-15 23:37 GMT+01:00 Matt Zagrabelny : > Greetings, > > Using PG 10.1. > > In my .psqlrc I have: > > \x auto > \pset linestyle 'unicode' > \pset unicode_header_linestyle double > > and when the output is expanded, I do not see a double line for the first > record, but I do for all subseq

Re: [GENERAL] pg_basebackup running from a remote machine

On Tue, Nov 14, 2017 at 8:28 AM, Laurenz Albe wrote: > rakeshkumar464 wrote: > > If pg_basebackup is run from a remote machine with compress option > --gzip , > > compress level 9, > > will the compression occur prior to the data being sent on the network or > > after it has been received > > at

Re: [GENERAL] Setting up replication slave on remote high latency host

ng the current db as a test and after 90 minutes it seems to >> have only got 2/3 of the way. I am not confident this will work but it >> seems like the most efficient way to start. >> > > > you can't use pg_dump to create a slave, as it won't have the same &

Re: [GENERAL] Setting up replication slave on remote high latency host

start. you can't use pg_dump to create a slave, as it won't have the same timeline. I would use pg_basebackup, but in general streaming replication over a high latency erratic link will never work real well. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-gener

[GENERAL] Setting up replication slave on remote high latency host

Hi, Thoughts and opinions on this please - I have a db (data dir is 90gb) that I am trying to setup on a replication slave. The slave is on a host which maintains latency over 300ms at all times (wan link). Other times I have done this setup, I have simply rsync'ed the data dir to another host,

Re: [GENERAL] PGPool in Master-Master mode, is it possible?

First thing I >> want to know, is it possible? >> >> I know we can setup 2 PGPool servers in master-slave mode using watchdog. >> http://www.pgpool.net/pgpool- web/contrib_docs/watchdog_ >> master_slave_3.3/en.html >> >> Could anyone please enlighten me and a

[GENERAL] expanded auto and header linestyle double

Greetings, Using PG 10.1. In my .psqlrc I have: \x auto \pset linestyle 'unicode' \pset unicode_header_linestyle double and when the output is expanded, I do not see a double line for the first record, but I do for all subsequent records. For example: % select * from artist; ─[ RECORD 1 ]

Re: [GENERAL] problem changing jsonb attribute to null value

> On 15 November 2017 at 22:54, RODRIGUEZ CORTES MARIO IGNACIO < ignacio.cor...@inegi.org.mx> wrote: > > I have a problem with a record in a jsonb type table, I'm trying to > change the value of an attribute to null but it leaves me all the > content in null and not just the value > > prueba=# sele

[GENERAL] problem changing jsonb attribute to null value

no se pudo determinar el tipo polimórfico porque el tipo de entrada es «unknown» defining null value as a text type: prueba=# select jsonb_set('{"v" : 0}'::jsonb, '{"v"}', to_jsonb(null::text));  jsonb_set  ---   (1 fila) it leaves the record in null,

Re: [GENERAL] pg_basebackup running from a remote machine

ent protocol. -- 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] Query on pg_settings view

Greetings, * Laurenz Albe (laurenz.a...@cybertec.at) wrote: > Ronen Nofar wrote: > > I have a weird case when running a query on the pg_settings view. > > I have two users, first one is the default user - postgres which is a > > superuser > > and another one is a role which i had created, i call

Re: [GENERAL] Query on pg_settings view

s, 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] PGPool in Master-Master mode, is it possible?

gpool.net/pgpool-web/contrib_docs/watchdog_ > master_slave_3.3/en.html > > > > Could anyone please enlighten me and any workaround for this? > > This is not an appropriate list. You should go to the Pgpool mailing > list: > > https://www.pgpool.net/mailman/listin

[GENERAL] Query on pg_settings view

Hi, I have a weird case when running a query on the pg_settings view. I have two users, first one is the default user - postgres which is a superuser and another one is a role which i had created, i called it test_role and it's not a superuser. When I run a select on pg_settings with these two us

Re: [GENERAL] archive_command not being executed

pick up the activity covered in the WAL files. From: Jeremy Schneider Sent: Monday, November 13, 2017 3:56 PM To: eric...@hotmail.com Cc: PostgreSQL General; Paul Jungwirth Subject: Re: [GENERAL] archive_command not being executed Hi Eric, Thanks for using PostgreSQL! On Fri, Nov 10, 2017 at

Re: [GENERAL] jsonb

onb never heard of your ORM... does it even know what postgres jsonb is ?   do you know what actual SQL query that piece of ORMism generates ? -- 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] jsonb

rts a string into a JSON object that consist of that string. I guess what you intend to accomplish is rather: select jsonb_build_object('key1', 'text1', 'key2', 'text2'); -- 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] jsonb

the type > was a string and not a jsonb Still not quite following. My advice would be to: #1) work out the SQL you want the database to be running and verify the results are correct #2) figure out out to get the ORM to send that SQL If you need help figuring out that SQL the ORM is actuall

Re: [GENERAL] PGPool in Master-Master mode, is it possible?

ing watchdog. > http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html > > Could anyone please enlighten me and any workaround for this? This is not an appropriate list. You should go to the Pgpool mailing list: https://www.pgpool.net/mailman/listinfo/pgpool-general Any

Re: [GENERAL] jsonb

I'm trying to use the function to_jsonb and create the name: to_jsonb ('{"key1":" ' || 'text1' || '","key2":" ' || 'text2' || '"}'); But after that I used Objection.js ORM to get data using the query: Product.query().where('id',1).then(prod => {console.log(prod)}) I think that the problem maybe wit

Re: [GENERAL] jsonb

rom the table I got this format: > name: '{"key1": "text1", "key2": "text2"}' > > Why does postgresql returns the name such as string type and not jsonb? is > it a bug or is there something else to add? not quite following. Can you paste t

[GENERAL] jsonb

I have a column name of type 'jsonb' on my table named product. The format of the column: name: {"key1": "text1", "key2": "text2"} When I make a query to fetch data from the table I got this format: name: '{"key1": "text1", "key2": "text2"}' Why does postgresql returns the name such as string typ

Re: [GENERAL] missing public on schema public

Tom, all, * Tom Lane (t...@sss.pgh.pa.us) wrote: > =?iso-8859-1?Q?Bo_Thorbj=F8rn_Jensen?= writes: > > I have some additional info and a fix. > > Firstly steps to reproduce: > > Yeah, I can reproduce this. I suspect it got broken by Stephen's hacking > around with default ACLs. A simple example

Re: [GENERAL] pg 10 crashes on int8_avg_combine

5bdb92472d8) at >> ./build/../src/backend/utils/adt/numeric.c:4285 > > I think this is the same issue being discussed at > > https://www.postgresql.org/message-id/flat/20171110185747.31519.28038%40wrigleys.postgresql.org > > regards, tom lane >

Re: [GENERAL] pg_basebackup running from a remote machine

t TAR file will be compressed, it has nothing to do with the data transfered from the server. If you want to compress the data sent over the network, use pg_basebackup over an SSL connection with SSL compression enabled. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] pg 10 crashes on int8_avg_combine

iscussed at https://www.postgresql.org/message-id/flat/20171110185747.31519.28038%40wrigleys.postgresql.org 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

[GENERAL] PGPool in Master-Master mode, is it possible?

Hello There, I need to setup two PGPool Servers in Master-Master mode, First thing I want to know, is it possible? I know we can setup 2 PGPool servers in master-slave mode using watchdog. http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html Could anyone please enlight

[GENERAL] pg 10 crashes on int8_avg_combine

argv=0x55bdb9133e40) at ./build/../src/backend/postmaster/postmaster.c:1361 #17 0x55bdb721e834 in main (argc=5, argv=0x55bdb9133e40) at ./build/../src/backend/main/main.c:228 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] pg_basebackup running from a remote machine

If pg_basebackup is run from a remote machine with compress option --gzip , compress level 9, will the compression occur prior to the data being sent on the network or after it has been received at the remote machine. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780

Re: [GENERAL] missing public on schema public

erent results. Stephen, you put some filtering logic in the wrong place in pg_dump. 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] Retrieve the server's time zone

s" this setting. I will take this to the JDBC mailing list then, thanks. Thomas -- 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] Retrieve the server's time zone

7;t want to change it, you could try select reset_val from pg_settings where name = 'TimeZone'; 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

[GENERAL] Re: PostgreSQL walsender process doesn't exist after "pg_ctl stop -m fast"

Thank you for the explanation. We shall try the latest PostgreSQL 9.6.6 version. -- 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

Re: [GENERAL] Because PostgreSQL is compiling in old versions of OS?

ou're right!. Is the GGC version, not the OS version Great! I think that I compiling in a GGC 4.X version is good for most SO distribution right? Thanks! You're welcome! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

Re: [GENERAL] missing public on schema public

I have some additional info and a fix. Firstly steps to reproduce: 1. create database: CREATE DATABASE test WITH ENCODING='UTF8' OWNER=postgres CONNECTION LIMIT=-1; -- here public has access to public 2. dump: pg_dump -f testfile.dump -F c -h localhost -U postgres test 3. restore: pg_restore -

[GENERAL] Connection loosing at some places - caused by firewall

Dear Members! Windows 10, PGSQL 9.4 and 9.6 (Debian with SSL, and Windows without it - it doesn't matter). When I (or my boss) work(s) at home, I got connection lost errors from PGAdmin (3/4) or from other applications too. server closed the connection unexpectedly This probably means the ser

[GENERAL] Retrieve the server's time zone

defined by "timezone") log_timezone is also unreliable as it can be changed to anything. I am looking for something along the lines of: "show server_timezone" or "select current_timestamp at time zone server_timezone" Is that possible? -- Sent via pgsql-gene

Re: [GENERAL] archive_command not being executed

before. From: Michael Paquier Sent: Monday, November 13, 2017 6:01 PM To: Jeremy Schneider Cc: eric...@hotmail.com; PostgreSQL General; Paul Jungwirth Subject: Re: [GENERAL] archive_command not being executed On Tue, Nov 14, 2017 at 8:56 AM, Jeremy Schneider wrot

Re: [GENERAL] PostgreSQL walsender process doesn't exist after "pg_ctl stop -m fast"

f the source server was idle. In passing, improve the rather weak comments in this area, and slightly rearrange some related code for better readability. Back-patch to 9.4 where this code was introduced. Discussion: https://postgr.es/m/14154.1498781...@sss.pgh.pa.us -- Michael -- Sent via pgs

Re: [GENERAL] archive_command not being executed

andby you'd like to get the archives from. -- 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] archive_command not being executed

you able to configure a cascading replica by using streaming replication on your 9.3 system, without WAL archiving on the standby? -Jeremy -- http://about.me/jeremy_schneider -- 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-10 + ICU and abbreviated keys

På tirsdag 14. november 2017 kl. 00:44:11, skrev Peter Geoghegan mailto:p...@bowt.ie>>: On Mon, Nov 13, 2017 at 2:05 PM, Andreas Joseph Krogh wrote: > When sorting on text, we're usually doing so using an multi-column index, like for instance "CREATE INDEX xxx ON my_table (lower(name) ASC, crea

Re: [GENERAL] PG-10 + ICU and abbreviated keys

'll help with that, even though the leading column might be low cardinality. -- 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

[GENERAL] "Cascading Logical Replication" from a physical replica

ems to be quite complex compared to just reading the WAL off the standby where it already is, ideally using the logical output plugin interface to format the data. Thanks for any insights! Best regards, -hannes erven -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

Re: [GENERAL] PG-10 + ICU and abbreviated keys

På mandag 13. november 2017 kl. 22:28:40, skrev Peter Geoghegan mailto:p...@bowt.ie>>: On Mon, Nov 13, 2017 at 12:48 PM, Andreas Joseph Krogh wrote: > Thanks. As the person that worked on abbreviated keys, I'd like to hear about how you get with this. How much faster is it for you? I don't

  1   2   3   4   5   6   7   8   9   10   >