[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

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

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

ut with correlation between 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

termine 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

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 .

e ap.validate_crtr_line_items$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

. -- 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

s wrong if the library is preloaded, 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 .

You probably need an explicit cast to the rowtype. That is, declare myarray rowtypename[]; ... select array(select row(col1, ...)::rowtypename from ...) into myarray; regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresq

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

gworkers () 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 0x006a93c0 in PostmasterMain (argc=ar

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.

[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

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 subscription

Re: [GENERAL] mild modification to pg_dump

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: http

Re: [GENERAL] mild modification to pg_dump

ommon 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 <mailto:pgsql-general@postgresql.org>) To make

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. >> >> >> > > > -- >

Re: [GENERAL] mild modification to pg_dump

o 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

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: http

Re: [GENERAL] mild modification to pg_dump

hich 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. >> >> >

Re: [GENERAL] mild modification to pg_dump

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 subscrip

Re: [GENERAL] mild modification to pg_dump

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

to 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

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-general

Re: [GENERAL] mild modification to pg_dump

really want to modify the 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.

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

des + 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

ange? Most likely, there is a quick 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 mailin

[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

t make the problem worse... 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@postg

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

the problem worse... Andres -- Sent from my Android device with K-9 Mail. Please excuse my brevity. -- 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

k 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

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

it does seem like a situation that could arise from time to time. 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

r the confusion. -- 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] postmaster deadlock while logging after syslogger exited

they all 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

ched to true 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 th

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

ituation 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 o

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

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,

Re: [GENERAL] pg_restore load data

The command is COPY, not load. Sent via the Samsung Galaxy S® 6, an AT 4G LTE smartphone Original message From: Ron Johnson <ron.l.john...@cox.net> Date: 11/16/17 16:07 (GMT-05:00) To: pgsql-general@postgresql.org Subject: [GENERAL] pg_restore load data Hi, v9.2.7  (

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 >

[GENERAL] pg_restore load data

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

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' >>

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

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

bs/Email-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-t

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

- Original Message - From: "Nick Dro" <postgre...@walla.co.il> 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 need

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

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@postgresql.org) To make changes

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

[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

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,

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

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

have >> been importing 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

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

to 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-general mailing

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

GPool 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 >> &g

[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=#

[GENERAL] problem changing jsonb attribute to null value

o 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, when I hope it leaves it with the null value in attribute "v": {

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

Re: [GENERAL] Query on pg_settings view

urenz 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?

tchdog. > > 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.pg

[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

Re: [GENERAL] archive_command not being executed

in the WAL files. From: Jeremy Schneider <schnei...@ardentperf.com> 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 9

Re: [GENERAL] jsonb

s 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

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

ogging in postgresql.conf and watching the log. merlin -- 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?

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

Re: [GENERAL] jsonb

paste the query you are trying to execute along with the results vs. expectation? thanks merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[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

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

Re: [GENERAL] pg 10 crashes on int8_avg_combine

int8_avg_combine (fcinfo=0x55bdb92472d8) 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,

Re: [GENERAL] pg_basebackup running from a remote machine

output 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

me issue being discussed 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

[GENERAL] pg 10 crashes on int8_avg_combine

ld/../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

rent 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

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

'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?

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 subscription: http

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

[GENERAL] Retrieve the server's time zone

"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-general ma

Re: [GENERAL] archive_command not being executed

_ From: Michael Paquier <michael.paqu...@gmail.com> 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 &

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

ng. The previous coding could wait indefinitely if 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.1498

Re: [GENERAL] archive_command not being executed

for example connecting it to a standby 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

ng standby." Are 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 >: 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

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

here? Yes, they'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

ed 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.org) To make changes to your su

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

På mandag 13. november 2017 kl. 22:28:40, skrev Peter Geoghegan >: 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

  1   2   3   4   5   6   7   8   9   10   >