Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction

2020-05-12 Thread Adrian Klaver
On 5/12/20 12:14 PM, Matthias Apitz wrote: To answer also the question of Adrian Klaver: The database in question has ~400 tables and the ESQL/C application has for each table its own ESQL/C source file. It would be possible but a nightmare to share the code and it's better to discus

Re: Enforcing uniqueness on [real estate/postal] addresses

2020-05-12 Thread Adrian Klaver
see that there are provisions for geographic reference grids. Is that an option? I haven't yet had the opportunity to try out the above suggestions but I will post again when I have. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrade Process Says "The database server was not shut down cleanly" but it was

2020-05-12 Thread Adrian Klaver
On 5/12/20 2:51 PM, TalGloz wrote: Adrian Klaver-4 wrote On 5/11/20 2:45 PM, TalGloz wrote: Well I tried your steps, both Postgres 10 and 12 are in perfect running conditions and were shut down using the "systemctl" command. When I execute: /usr/pgsql-12/bin/pg_upgrade --old-bindir=

Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction

2020-05-12 Thread Adrian Klaver
On 5/12/20 4:52 PM, Matthias Apitz wrote: El día Dienstag, Mai 12, 2020 a las 12:30:17 -0700, Adrian Klaver escribió: On 5/12/20 12:14 PM, Matthias Apitz wrote: To answer also the question of Adrian Klaver: The database in question has ~400 tables and the ESQL/C application has for each

Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction

2020-05-13 Thread Adrian Klaver
On 5/12/20 10:34 PM, Matthias Apitz wrote: El día Dienstag, Mai 12, 2020 a las 05:17:33 -0700, Adrian Klaver escribió: insert into swd_auftrag .. COMMIT? This question (if it was a question) I don't understand. From your original message: "The INSERT of 1 row into table swd_da

Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction

2020-05-13 Thread Adrian Klaver
On 5/13/20 11:16 AM, Matthias Apitz wrote: El día Mittwoch, Mai 13, 2020 a las 08:15:40 -0700, Adrian Klaver escribió: In your original post you had: "We're facing in our ESQL/C written application a situation where a commit'ed INSERT into a table is rolled back. I have

Re: vacuumdb --jobs deadlock: how to avoid pg_catalog ?

2020-05-14 Thread Adrian Klaver
nt lost ERROR:  canceling statement due to user request STATEMENT:  VACUUM (FULL) mycompanydata.cpc_tag_score2; LOG:  could not send data to client: Broken pipe STATEMENT:  VACUUM (FULL) mycompanydata.cpc_tag_score2; LOG:  could not send data to client: Broken pipe FATAL:  connection to client lost FATAL:  connection to client lost LOG:  received SIGHUP, reloading configuration files LOG:  received SIGHUP, reloading configuration files -- Adrian Klaver adrian.kla...@aklaver.com

Re: vacuumdb --jobs deadlock: how to avoid pg_catalog ?

2020-05-14 Thread Adrian Klaver
ck. Only method I'm aware of is to list each table individually with "-t table1 -t table2..." to "vacuum db --jobs" which is not pleasant and not exceedingly beautiful. Thanks. -- Adrian Klaver adrian.kla...@aklaver.com

Re: vacuumdb --jobs deadlock: how to avoid pg_catalog ?

2020-05-14 Thread Adrian Klaver
found the option of using "vacuumdb --jobs" which sounded like the perfect solution except for "well you can't actually use --jobs because you'll run into a deadlock and everybody knows that and nobody has a (good) solution for it" :). --Ed On May 14, 2020, at 11:

Re: Bug on version 12 ?

2020-05-15 Thread Adrian Klaver
05/15/2020 10:54:58.649859 PDT works on 11.7 but not on 12.3. -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Bug on version 12 ?

2020-05-15 Thread Adrian Klaver
eSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: schema agnostic functions in language sql

2020-05-15 Thread Adrian Klaver
second schema.  My "build the world" scripting has so far avoided needing to know/use any specific role.  Another pipe dream vaporized? Thanks, rjs -- Adrian Klaver adrian.kla...@aklaver.com

Re: schema agnostic functions in language sql

2020-05-15 Thread Adrian Klaver
On 5/15/20 3:53 PM, Rob Sargent wrote: On 5/15/20 4:43 PM, Adrian Klaver wrote: On 5/15/20 3:26 PM, Rob Sargent wrote: I'm using postgres 12.2, with multiple identical schema per database (each with a matching role).  I can write public plpgsql functions without using a schema ident

Re: schema agnostic functions in language sql

2020-05-15 Thread Adrian Klaver
d); work? I'm ok(ish) with that, unless I've missed some detail. rjs -- Adrian Klaver adrian.kla...@aklaver.com

Re: Removing Last field from CSV string

2020-05-16 Thread Adrian Klaver
III Regards - Météo-France - PALAYRET JACQUES DCSC/MBD jacques.palay...@meteo.fr Fixe : +33 561078319 -- Adrian Klaver adrian.kla...@aklaver.com

Re: Ubuntu 20.04: apt.postgresql.org/pub/repos/apt focal-pgdg InRelease' doesn't support architecture 'i386'

2020-05-16 Thread Adrian Klaver
. Done Building dependency tree Reading state information... Done All packages are up to date. N: Skipping acquire of configured file 'main/binary-i386/Packages' as repository 'http://apt.postgresql.org/pub/repos/apt focal-pgdg InRelease' doesn't support architecture 'i386' Thanks, Hugh -- Adrian Klaver adrian.kla...@aklaver.com

Re: template0 needing vacuum freeze?

2020-05-18 Thread Adrian Klaver
the 12.3 release. Do you have an idea why autovac was failing to clear the issue on that one problem table, though? regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: idle_in_transaction_session_timeout not getting log in PG v12.2

2020-05-19 Thread Adrian Klaver
tial and subject to the Amdocs Email Terms of Service, which you may review at**https://www.amdocs.com/about/email-terms-of-service* -- Adrian Klaver adrian.kla...@aklaver.com

Re: idle_in_transaction_session_timeout not getting log in PG v12.2

2020-05-19 Thread Adrian Klaver
l Message----- From: Adrian Klaver Sent: Tuesday, May 19, 2020 7:28 PM To: Ishan Joshi ; pgsql-gene...@postgresql.org Subject: Re: idle_in_transaction_session_timeout not getting log in PG v12.2 On 5/19/20 2:08 AM, Ishan Joshi wrote: > Hi Team, > > I have set idle_in_transaction_

Re: idle_in_transaction_session_timeout not getting log in PG v12.2

2020-05-19 Thread Adrian Klaver
logged to the file e.g. connections/disconnects, etc? Thanks & Regards, Ishan Joshi -- Adrian Klaver adrian.kla...@aklaver.com

Re: idle_in_transaction_session_timeout not getting log in PG v12.2

2020-05-19 Thread Adrian Klaver
you see anything relevant in the logs when the session is killed? 2) Is the transaction actually being killed? In other words does it still show up in?: https://www.postgresql.org/docs/12/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW Thanks & Regards, Ishan Joshi -Original Message

Re: idle_in_transaction_session_timeout not getting log in PG v12.2

2020-05-19 Thread Adrian Klaver
Thanks & Regards, Ishan Joshi -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to recover from compressed wal archieve in windows

2020-05-20 Thread Adrian Klaver
restored. is used. Restore shows "file not found" errors in console. Thi sis probably because %f argument is WAL file name without extension. How to use compressed WAL files for WAL archieve and restore in windows ? Andrus. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to recover from compressed wal archieve in windows

2020-05-20 Thread Adrian Klaver
works on Windows. In the past I have had luck with: https://www.7-zip.org/ Not sure how well it works with redirects/pipes. Cheers, Paul On 20. May, 2020, at 20:36, Adrian Klaver wrote: On 5/20/20 8:08 AM, Andrus wrote: In windows 10 pg_receivewal --directory="d:\wallog"

Re: How to recover from compressed wal archieve in windows

2020-05-20 Thread Adrian Klaver
files to additional compression is not needed? Yes. Not sure how it will play with the streaming that pg_receivewal does. Maybe the best thing is to back up a bit and let us know what it is you are trying to achieve? Andrus. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to recover from compressed wal archieve in windows

2020-05-20 Thread Adrian Klaver
On 5/20/20 6:27 PM, Michael Paquier wrote: On Wed, May 20, 2020 at 11:36:09AM -0700, Adrian Klaver wrote: The next problem is that I'm pretty sure a WAL file with *.gz extension will not be able to be processed directly by the server. So you are going to have to uncompress it at some

Re: Suggestion on table analyze

2020-05-21 Thread Adrian Klaver
pute statistics"); stats->stats_valid = false; return; } You might find more information from here: https://postgis.net/support/ Though FYI PostGIS 2.2.7 is past EOL: https://postgis.net/source/ Thanks for your support. Regards, PostgAnn. -- A

Re: Suggestion on index creation for TEXT data field

2020-05-21 Thread Adrian Klaver
indexing.^^ Hint supplies answer to 1) and 2) below. Could you please suggest on below queries. 1. How to solve the issue?. 2. What type of index is the best suited for this type of data?. Thanks for your support. Regards, PostgAnn. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Table partitioning for cloud service?

2020-05-21 Thread Adrian Klaver
aving to be VERY careful with my SQL to make sure no customer could access another’s data. How is this typically done? --- Israel Brewster BrewsterSoft Development http://www.brewstersoft.com <http://www.brewstersoft.com/> Home of EZPunch and Lyrics Presenter -- Adrian Klaver

Re: Should I use JSON?

2020-05-21 Thread Adrian Klaver
array of objects maps so nicely to a Python list of dicts that I just do the parsing in Python and INSERT the parsed data into the table. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Table partitioning for cloud service?

2020-05-21 Thread Adrian Klaver
On 5/21/20 8:53 AM, Israel Brewster wrote: On May 21, 2020, at 7:36 AM, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 5/21/20 8:29 AM, Israel Brewster wrote: I’m working on my first cloud service, which will be backed by a postgresql database. Currently I only have

Re: Table partitioning for cloud service?

2020-05-21 Thread Adrian Klaver
lt;http://www.brewstersoft.com/> Home of EZPunch and Lyrics Presenter Regards, Sándor -- Adrian Klaver adrian.kla...@aklaver.com

Re: Query returns no rows in pg_basebackup cluster

2020-05-21 Thread Adrian Klaver
27;Estonian_Estonia.1257' IF so how to to fix windows cluster so that query returns proper result in windows also? Database in Windows is in read-only (recovery) mode so it cannot changed. Postgres 12 is used. Andrus. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Query returns no rows in pg_basebackup cluster

2020-05-21 Thread Adrian Klaver
On 5/21/20 3:47 PM, Tom Lane wrote: Adrian Klaver writes: On 5/21/20 1:20 PM, Andrus wrote: In windows pg_basebackup was used to create base backup from Linux server. Are you referring to two different instances of Postgres on Windows? No, what it sounds like is the OP tried to

Re: Query returns no rows in pg_basebackup cluster

2020-05-21 Thread Adrian Klaver
On 5/21/20 4:06 PM, David G. Johnston wrote: On Thu, May 21, 2020 at 3:57 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 5/21/20 3:47 PM, Tom Lane wrote: > Adrian Klaver mailto:adrian.kla...@aklaver.com>> writes: >> On 5/21/20 1:20 PM, A

Re: pg_dump crashes

2020-05-22 Thread Adrian Klaver
** <http://www.esaturnus.com/> *For Service & Support :* Support Line Belgium: +32 2 2009897 Support Line International: +44 12 56 68 38 78 Or via email : medical.services...@sony.com <mailto:medical.services...@sony.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump crashes

2020-05-22 Thread Adrian Klaver
12 56 68 38 78 Or via email : medical.services...@sony.com <mailto:medical.services...@sony.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump crashes

2020-05-22 Thread Adrian Klaver
89 5405605 14507502 0 0 P4B Bb8c/ IGk L BOS BOP A Lfh BAA Bg BeMj+2 Bd1LVN BehUAl rlx ABA TOR It looks suspicious however there are about 837 more lines before the output stops. Nico On Fri, May 22, 2020 at 3:27 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 5/22/

Re: pg_dump crashes

2020-05-22 Thread Adrian Klaver
deltaseq, markid, lstat, md5) the '' would be for the md5 field. I'm going to say that is important. Nico -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump crashes

2020-05-22 Thread Adrian Klaver
esaturnus.com/> *For Service & Support :* Support Line Belgium: +32 2 2009897 Support Line International: +44 12 56 68 38 78 Or via email : medical.services...@sony.com <mailto:medical.services...@sony.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump crashes

2020-05-22 Thread Adrian Klaver
On 5/22/20 8:05 AM, Nico De Ranter wrote: On Fri, May 22, 2020 at 5:02 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 5/22/20 7:55 AM, Nico De Ranter wrote: > Correct. > > If I run 'pg_dumpall --cluster 11/main --file=dump.sq

Re: pg_dump crashes

2020-05-22 Thread Adrian Klaver
ant. But that would be content of the database only. The should matter for the application but not for a dump of the database, right? Also what does: \d public.file show? In particular are there any triggers on the table? -- Nico De Ranter -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump crashes

2020-05-22 Thread Adrian Klaver
row) It means it cannot find that fileid. I putting that down to file corruption. -- Nico De Ranter -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump crashes

2020-05-22 Thread Adrian Klaver
On 5/22/20 8:17 AM, Nico De Ranter wrote: On Fri, May 22, 2020 at 5:14 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 5/22/20 8:05 AM, Nico De Ranter wrote: > > >     Assuming the above matches: > >     COPY public.file (

Re: pg_dump crashes

2020-05-22 Thread Adrian Klaver
On 5/22/20 8:17 AM, Nico De Ranter wrote: On Fri, May 22, 2020 at 5:14 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 5/22/20 8:05 AM, Nico De Ranter wrote: > > >     Assuming the above matches: > >     COPY public.file (

Re: How to get the OID of a view

2020-05-22 Thread Adrian Klaver
re relkind = 'v' means view: https://www.postgresql.org/docs/12/catalog-pg-class.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: libgeotiff missing

2020-05-23 Thread Adrian Klaver
round the problem  You could try running: rpm -Va --nofiles --nodigest Richard Suematsu Development Manager SYNCADD Systems, Inc. 677 Ala Moana Blvd Suite 901 Honolulu, HI 96813 o: 808.941.8286 x 206 -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump crashes

2020-05-25 Thread Adrian Klaver
those entries are killing it.  Now for the > million-dollar question: how do I get them out? Do you have recent previous backup? > > Nico > > -- > > Nico De Ranter > > Operations Engineer > -- Adrian Kl

Re: Advise on how to install pl/perl on existing DB.

2020-05-26 Thread Adrian Klaver
in Advance ! -- Adrian Klaver adrian.kla...@aklaver.com

Re: GPG signing

2020-05-26 Thread Adrian Klaver
APIs, and it is not obvious to me which of the many different gpg-ish packages I should choose. Any other options? Am I missing something? https://www.postgresql.org/docs/12/pgcrypto.html#id-1.11.7.34.7 Thanks. __ Marc -- Adrian Klaver adrian.kla...@aklaver.com

Re: Can't remove default permissions entry

2020-05-27 Thread Adrian Klaver
Schema | Type |Access privileges +---+--+-- xyuser | | table| db=> -- -- Christophe Pettus x...@thebuild.com -- Adrian Klaver adrian.kla...@aklaver.com

Re: Suggest the Schedular for activities

2020-05-27 Thread Adrian Klaver
scheduler for DB specific activities as well instead of corn. Maybe?: https://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/ Thanks & Regards, Postgann. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Linux Update Experience

2020-05-28 Thread Adrian Klaver
kus -- Adrian Klaver adrian.kla...@aklaver.com

Re: AW: Linux Update Experience

2020-05-28 Thread Adrian Klaver
On 5/28/20 7:36 AM, Zwettler Markus (OIZ) wrote: -Ursprüngliche Nachricht- Von: Adrian Klaver Gesendet: Donnerstag, 28. Mai 2020 16:15 An: Zwettler Markus (OIZ) ; PostgreSQL General Betreff: Re: Linux Update Experience On 5/28/20 12:59 AM, Zwettler Markus (OIZ) wrote: We are running

Re: psql12.3 + jdbc_fdw - return wrong query results by using OR

2020-05-28 Thread Adrian Klaver
AND/OR/NOT combinations) in those clauses can be reorganized in any manner allowed by the laws of Boolean algebra." It would help to see the EXPLAIN ANALYZE for the queries above. Thanks a lot. -- Adrian Klaver adrian.kla...@aklaver.com

Re: psql12.3 + jdbc_fdw - return wrong query results by using OR

2020-05-28 Thread Adrian Klaver
". Boolean expressions (AND/OR/NOT combinations) in those clauses can be reorganized in any manner allowed by the laws of Boolean algebra." It would help to see the EXPLAIN ANALYZE for the queries above. -- Adrian Klaver adrian.kla...@aklaver.com -- Adrian Klaver adrian.kla...@aklaver.com

Re: problem with self built postgres 9.0.9

2020-05-29 Thread Adrian Klaver
TAL: column is not in index". Any idea where the problem may be? Thanks! Gabriele *Sonicle S.r.l. *: http://www.sonicle.com <http://www.sonicle.com/> *Music: *http://www.gabrielebulfon.com <http://www.gabrielebulfon.com/> *Quantum Mechanics : *http://www.cdbaby.com/cd/gabrielebulfon -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_ctl can't start db server

2020-05-29 Thread Adrian Klaver
what does the below show?: pg_lsclusters If it shows clusters then do: sudo pg_ctlcluster 12 main start If the above is not correct, then what user where you doing: pg_ctl start as? Thank you, Tanja -- Adrian Klaver adrian.kla...@aklaver.com

Re: Trigger not firing

2020-05-31 Thread Adrian Klaver
nabled if that helps in understanding this problem. What would be helpful in troubleshooting this? Thanks in advance for any insight you may have, Hans -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump of database with numerous objects

2020-05-31 Thread Adrian Klaver
that will creep up on me. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated

2020-05-31 Thread Adrian Klaver
p a WAL archive that's accessible from the standby, these solutions are not required, since the standby can always use the archive to catch up provided it retains enough segments." Why those parameters are duplicated? Andrus. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump of database with numerous objects

2020-05-31 Thread Adrian Klaver
reSQL version you are upgrading *to* (which is recommended practice, anyway) to see if that improves matters. Just a reminder that the OP's original issue was with using pg_upgrade. -- -- Christophe Pettus x...@thebuild.com -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump of database with numerous objects

2020-05-31 Thread Adrian Klaver
On 5/31/20 1:38 PM, Christophe Pettus wrote: On May 31, 2020, at 13:37, Adrian Klaver wrote: Just a reminder that the OP's original issue was with using pg_upgrade. True, although IIRC pg_ugprade uses pg_dump under the hood to do the schema migration. Again true, but pg_upgrade

Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated

2020-05-31 Thread Adrian Klaver
re using a replication slot there is no point in using wal_keep_segments. Slots where created in, part at least, so you did not have to guess at a wal_keep_segments number. To really answer this we will need to see the exact commands you are using and the sequence they are done in. Andrus.

Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated

2020-05-31 Thread Adrian Klaver
to my most recent questions: What are you trying to achieve? In other words why do a pg_basebackup if you have a standby receiving WALs? Andrus. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated

2020-05-31 Thread Adrian Klaver
f you have a standby receiving WALs? I dont receive WALs. If you are doing binary replication then you are receiving WALs. It just a matter of whether you are streaming them or shipping them over complete. Andrus. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_ctl can't start db server

2020-06-01 Thread Adrian Klaver
derstands this way, even though theoretically the postmaster can deal with other approaches to setting up an external config file.) regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Trigger not firing

2020-06-01 Thread Adrian Klaver
END; $$ LANGUAGE plpgsql; and then CREATE TRIGGER update_usergrouptest_from_test AFTER UPDATE ON generic.test FOR EACH ROW EXECUTE PROCEDURE generic.update_usergrouptest_from_test(); Hans -- Adrian Klaver adrian.kla...@aklaver.com

Re: Pglogical 2.3.0 in AWS RDS 12.2

2020-06-01 Thread Adrian Klaver
dQuadrant's support agreements/offerings, and whether there's something there that could give general advice about the open source pgLogical extension. Hope this helps, Jeremy -- Adrian Klaver adrian.kla...@aklaver.com

Re: LOG: could not send data to client: Broken pipe

2020-06-02 Thread Adrian Klaver
+not+send+data+to+client%3A+Broken+pipe&l=2&d=-1&s=i checked  11,12,13,14,15,16,17,18 mail replies Let me know if you need any more details from my end. Is there anything relevant in the OS system log around the time period 2020-06-02 02:09:21.333 CEST? Regards, Narresh

Re: LOG: could not send data to client: Broken pipe

2020-06-02 Thread Adrian Klaver
? Client OS? What is the network distance between the client/application and the server? -- Adrian Klaver adrian.kla...@aklaver.com

Re: LOG: could not send data to client: Broken pipe

2020-06-02 Thread Adrian Klaver
On 6/2/20 11:18 AM, TALLURI Nareshkumar wrote: Hello Adrian Klaver, Here is the answers What version of JDBC? : 9.3-1104-jdbc41 What is the application stack? : Java That is the programming language. I was looking for the actual

Re: LOG: could not send data to client: Broken pipe

2020-06-02 Thread Adrian Klaver
- From: Adrian Klaver Sent: Wednesday, June 3, 2020 12:38 AM To: TALLURI Nareshkumar SgscGtsPasDre ; pgsql-gene...@postgresql.org Subject: Re: LOG: could not send data to client: Broken pipe On 6/2/20 11:18 AM, TALLURI Nareshkumar wrote: Hello Adrian Klaver, Here is the answers What

Re: Unable to find the details of bug fix in 9.6.x minor version.

2020-06-03 Thread Adrian Klaver
tempts to fetch non-existent WAL files from archive storage, which is helpful if archive access is slow._ _ Regards, Sameer Malve -- Adrian Klaver adrian.kla...@aklaver.com

Re: Shared memory error

2020-06-03 Thread Adrian Klaver
again the issue is repeating. Can someone please help To get any useful help you will need to provide: 1) Postgres version 2) JDBC driver version 3) OS and version 4) Is this only with one query and if so what is it doing? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Fine grained permissions on User Mapping

2020-06-03 Thread Adrian Klaver
e file: https://www.postgresql.org/docs/12/libpq-pgservice.html Then the user mapping could use information the end user can't see unless they had permissions on the file system. Thanks again ! Paul ** -- Adrian Klaver adrian.kla...@aklaver.com

Re: Oracle vs. PostgreSQL - a comment on Mysql

2020-06-03 Thread Adrian Klaver
DBMS-vendors seem to provide. I love PG, have been using it professionally since 6.5, and our company depends on it, but there are things other RDBMS-vendors do better... -- Andreas Joseph Krogh -- Adrian Klaver adrian.kla...@aklaver.com

Re: Index no longer being used, destroying and recreating it restores use.

2020-06-04 Thread Adrian Klaver
ch this table belongs, undergoes a "vacuum analyze" every single night, which takes about 8 minutes. Do I perhaps need to do something additional in terms of cleanup/maintenance? I've tried altering statistics, to very large values even, but no changes there either. Any help or s

Re: Index no longer being used, destroying and recreating it restores use.

2020-06-04 Thread Adrian Klaver
r: 8610174 Buffers: shared hit=1014 read=1798652 Planning time: 0.807 ms Execution time: 159720.208 ms regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Monitoring for long running transactions

2020-06-04 Thread Adrian Klaver
ting a fast-path function. disabled: This state is reported if track_activities is disabled in this backend. " Regards, -- Adrian Klaver adrian.kla...@aklaver.com

Re: Monitoring for long running transactions

2020-06-04 Thread Adrian Klaver
On 6/4/20 12:59 PM, Samuel Smith wrote: On 6/4/20 2:29 PM, Adrian Klaver wrote: Sorry, I should have clarified that I was aware of the pg_stat_activity table. That is how we found the problem in the first place. And yes I could just write a bash script and run it in cron. I just didn&#

Re: Move configuration files with pg_upgrade

2020-06-04 Thread Adrian Klaver
nt to manage in the include file. Then copy that over and set the include 'some_file' in the new postgresql.conf and you are good. Is it possible somehow to migrate these old configuration files with pg_upgrade or it shall be done manually? Cheers, Tanja -- Adrian Klaver adrian.kla...@aklaver.com

Re: Index no longer being used, destroying and recreating it restores use.

2020-06-05 Thread Adrian Klaver
oesn't wish to decloak his data a bit more ... but a reasonable guess is that those filter conditions are correlated.  With late-model Postgres you might be able to improve matters by creating extended statistics for this table.                         regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Logical Replication and table bloat

2020-06-05 Thread Adrian Klaver
better how the logical replication is affecting the vacuuming. A question for the AWS folks: https://forums.aws.amazon.com/forum.jspa?forumID=60 Thanks before hand! Best, Martín -- Adrian Klaver adrian.kla...@aklaver.com

Re: Question on full vacuum clearing waste space

2020-06-07 Thread Adrian Klaver
Thank you What "waste query" are you running? Those tend to be estimates only. Vacuum Full clearly did its job from that log you shared. -- Wenjun Che VP of Engineering | OpenFin wen...@openfin.co <mailto:wen...@openfin.co> *Move Fast.  Break Nothing.* www.openfin.co <http://www.openfin.co> | @openfintech -- Adrian Klaver adrian.kla...@aklaver.com

Re: "INSERT ON CONFLICT UPDATE" - Use of indexes ?

2020-06-08 Thread Adrian Klaver
ual index definition 3) Complete ON CONFLICT definition 4) Error message returned. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS [...]

2020-06-08 Thread Adrian Klaver
nsion that offers that: https://www.postgresql.org/message-id/4a390375-0a69-8901-fc5a-4a0336c5c6b4%40darold.net -- Adrian Klaver adrian.kla...@aklaver.com

Re: Is it possible to use keywords (date units) in a function definition?

2020-06-08 Thread Adrian Klaver
de, but the OP also wants this to run on BigQuery and unfortunately it won't work there. David J. -- Adrian Klaver adrian.kla...@aklaver.com

Re: 12.2: Why do my Redo Logs disappear??

2020-06-08 Thread Adrian Klaver
ere? It is unlikely to be the "FE", and the "FF" would be currently in use - and the archive_status directory was not written since 17:09. But the "FF" has disappeared. So what is going on here? cheerio, PMc -- Adrian Klaver adrian.kla...@aklaver.com

Re: 12.2: Why do my Redo Logs disappear??

2020-06-08 Thread Adrian Klaver
On 6/8/20 6:38 PM, Peter wrote: On Mon, Jun 08, 2020 at 05:40:20PM -0700, Peter Geoghegan wrote: And now for the nitpicking part :) On Mon, Jun 08, 2020 at 05:35:40PM -0700, Adrian Klaver wrote: ! > I am doing RedoLog Archiving according to Docs Chapter 25.1. ! ! There is no ReDo logg

Re: Something else about Redo Logs disappearing

2020-06-08 Thread Adrian Klaver
mode might be a good idea. (UFS: "-o sync", ZFS: "set sync=always") cheerio, PMc -- Adrian Klaver adrian.kla...@aklaver.com

Re: Something else about Redo Logs disappearing

2020-06-09 Thread Adrian Klaver
On 6/9/20 4:15 AM, Stephen Frost wrote: Greetings, * Adrian Klaver (adrian.kla...@aklaver.com) wrote: I use pg_backrest, but it does not look promising for running on BSD: https://fluca1978.github.io/2019/03/04/pgbackrest_FreeBSD.html That's an unfortunately ancient post, really, consid

Re: Something else about Redo Logs disappearing

2020-06-09 Thread Adrian Klaver
On 6/9/20 10:55 AM, Peter wrote: On Mon, Jun 08, 2020 at 09:21:47PM -0700, Adrian Klaver wrote: ! ! On 6/8/20 7:33 PM, Peter wrote: ! > ! > Actually, the affair had some good side: as usual I was checking ! > my own designs first and looking for flaws, and indeed I found one: ! > If

Re: Something else about Redo Logs disappearing

2020-06-09 Thread Adrian Klaver
On 6/9/20 12:02 PM, Peter wrote: On Tue, Jun 09, 2020 at 01:27:20AM -0400, Tom Lane wrote: ! Adrian Klaver writes: ! > On 6/8/20 7:33 PM, Peter wrote: ! >> That "cp" is usually not synchronous. So there is the possibility ! >> that this command terminates successfully,

Re: Help with plpython3u

2020-06-09 Thread Adrian Klaver
dll above are you talking about a system installed one or one from within the Anaconda environment? - Postgres version is 12.2-1. pgAdmin is 4.18 Please, help me :( Regards, PS -- Adrian Klaver adrian.kla...@aklaver.com

Re: Something else about Redo Logs disappearing

2020-06-09 Thread Adrian Klaver
On 6/9/20 4:35 PM, Peter wrote: On Tue, Jun 09, 2020 at 12:34:38PM -0700, Adrian Klaver wrote: And that can very well be done properly with an incremental filesystem backup software plus some 20 lines of shellscript. Read the caveats here: https://www.postgresql.org/docs/12/backup

Re: Help with plpython3u

2020-06-09 Thread Adrian Klaver
. 2020 a las 20:17, Adrian Klaver (mailto:adrian.kla...@aklaver.com>>) escribió: On 6/9/20 5:09 PM, PEDRO PABLO SEVERIN HONORATO wrote: > Hello! > > I'm cracking my head while trying to make python language work within > postges. I executed "

Re: Help with plpython3u

2020-06-09 Thread Adrian Klaver
nda forum: https://groups.google.com/a/anaconda.com/forum/#!forum/anaconda Thank you so much for your help!! :D PS El mar., 9 jun. 2020 a las 20:37, Adrian Klaver (mailto:adrian.kla...@aklaver.com>>) escribió: On 6/9/20 5:26 PM, PEDRO PABLO SEVERIN HONORATO wrote: > Hi Adrian,

Re: Help with plpython3u

2020-06-10 Thread Adrian Klaver
ht for the same variable name? Is there a way to set it to two different names? See below for more information: https://docs.anaconda.com/anaconda/user-guide/faq/#installing-anaconda Thanks, PS -- Adrian Klaver adrian.kla...@aklaver.com

Re: [HELP] Reset postgres server

2020-06-10 Thread Adrian Klaver
, * *K S Praveen Kumar * -- Adrian Klaver adrian.kla...@aklaver.com

<    11   12   13   14   15   16   17   18   19   20   >