Re: PG12 autovac issues

On Thu, Mar 26, 2020 at 09:46:47AM -0500, Justin King wrote: > Nope, it was just these tables that were looping over and over while > nothing else was getting autovac'd. I'm happy to share the full log > if you'd like. Thanks, that could help. If that's very large, it could be a problem to send

Re: Ident authentication failed

Thanks for the many responses I've gotten!  What a useful and welcoming community! I finally managed to get it configured following: https://github.com/miniflux/miniflux/issues/80#issuecomment-375996546 On 3/26/20 4:24 PM, Adrian Klaver wrote: On 3/26/20 12:40 PM, Ted To wrote: Thank you --

Re: Ident authentication failed

## Ted To (t...@theo.to): > Thank you -- I added two lines to the hba file to allow for ident > authentication, restarted postgres and still the same errors. You probably don't want "ident" authentication - that's the thing with "identd" (see RfC 1413), which even 20 years ago was only used in co

Re: Ident authentication failed

On 3/26/20 12:40 PM, Ted To wrote: Thank you -- I added two lines to the hba file to allow for ident authentication, restarted postgres and still the same errors. Alright from here: https://miniflux.app/docs/configuration.html The Golang Postgres client pq is being used and: "The default valu

Re: Ident authentication failed

> On Mar 26, 2020, at 1:43 PM, Ted To wrote: > > > > On 3/26/20 3:35 PM, Adrian Klaver wrote: >> Can you show the entire connection string used by miniflux? > The miniflux command is binary so, no, not easily. >> >> Did you reload/restart the server after making the changes below? > Yes. >

Re: Ident authentication failed

On 3/26/20 3:35 PM, Adrian Klaver wrote: Can you show the entire connection string used by miniflux? The miniflux command is binary so, no, not easily. Did you reload/restart the server after making the changes below? Yes. My /var/opt/rh/rh-postgresql96/lib/pgsql/data/pg_hba.conf file in

Re: How can I recreate a view in a new schema such that the view def references tables in the new schema ?

On 3/26/20 11:38 AM, David Gauthier wrote: sqf-> SELECT sr.project, sqf->     sr.sqf_id, sqf->     wa.wa_path, sqf->     sr.cbwa_type, sqf->     sr.status, sqf->     sr.nightly_rg_cl, sqf->     ( SELECT max(fse.end_datetime) AS max sqf(>            FROM public.flow_step_events fse sqf(>          

Re: Ident authentication failed

On 3/26/20 12:40 PM, Ted To wrote: Thank you -- I added two lines to the hba file to allow for ident authentication, restarted postgres and still the same errors. Without knowing how the client is trying to connect to the server this issue will be difficult to solve. On 3/26/20 3:35 PM, Ro

Re: Ident authentication failed

Thank you -- I added two lines to the hba file to allow for ident authentication, restarted postgres and still the same errors. On 3/26/20 3:35 PM, Ron wrote: You're only allowing "trust" authentication, not "ident" authentication. On 3/26/20 2:29 PM, Ted To wrote: Hi, I'm trying to configu

Re: Ident authentication failed

On 3/26/20 12:29 PM, Ted To wrote: Hi, I'm trying to configure miniflux and am struggling to figure out how to configure postgres for that purpose.  (The miniflux instructions are very terse.)  Regardless of whether I run the command as the postgres user or the miniflux user, I get similar er

Re: Ident authentication failed

You're only allowing "trust" authentication, not "ident" authentication. On 3/26/20 2:29 PM, Ted To wrote: Hi, I'm trying to configure miniflux and am struggling to figure out how to configure postgres for that purpose.  (The miniflux instructions are very terse.)  Regardless of whether I ru

Ident authentication failed

Hi, I'm trying to configure miniflux and am struggling to figure out how to configure postgres for that purpose.  (The miniflux instructions are very terse.)  Regardless of whether I run the command as the postgres user or the miniflux user, I get similar errors.  I am running Centos 7 using

Re: Duplicate key violation on upsert

> On 27/03/2020, at 5:26 AM, Adrian Klaver wrote: > > Well morning and coffee helped some, but not enough to offer blinding > insight. Reviewing the function above, the TimescaleDB insert block function > and the overview of the TimescaleDB hypertable architecture leads me to > believe there

Re: How can I recreate a view in a new schema such that the view def references tables in the new schema ?

sqf-> SELECT sr.project, sqf-> sr.sqf_id, sqf-> wa.wa_path, sqf-> sr.cbwa_type, sqf-> sr.status, sqf-> sr.nightly_rg_cl, sqf-> ( SELECT max(fse.end_datetime) AS max sqf(>FROM public.flow_step_events fse sqf(> WHERE fse.sqf_id = sr.sqf_id) AS last_sqf_st

Re: Replacing Apache Solr with Postgre Full Text Search?

On 26.03.20 17:05, J2eeInside J2eeInside wrote: >> P.S. I need to index .pdf, .html and MS Word .doc/.docx files, is >> there any constraints in Ful Text search regarding those file types? > > - Can you recommend those tools you mention above/any useful resource on how to do that? For PDFs, I

Re: How can I recreate a view in a new schema such that the view def references tables in the new schema ?

On 3/26/20 10:55 AM, David Gauthier wrote: Thanks Adrian for the quick reply. I don't have a lot of choice regarding PG version.  I work for a large corp with an IT dept which offers the version I have.  They create VMs which are DB servers and this is the best they offer.  But I could request

Re: How can I recreate a view in a new schema such that the view def references tables in the new schema ?

Thanks Adrian for the quick reply. I don't have a lot of choice regarding PG version. I work for a large corp with an IT dept which offers the version I have. They create VMs which are DB servers and this is the best they offer. But I could request something newer. Never hurts to try. Ya, I ki

Re: How can I recreate a view in a new schema such that the view def references tables in the new schema ?

On 3/26/20 10:16 AM, David Gauthier wrote: Here's an interesting one for you... psql (9.6.7, server 11.3) on linux I have 2 DBs, differnet servers/instances.  I want to take all the metadata and data for a set of tables/views in the public schema of one DB and move it all over to be inside a s

How can I recreate a view in a new schema such that the view def references tables in the new schema ?

Here's an interesting one for you... psql (9.6.7, server 11.3) on linux I have 2 DBs, differnet servers/instances. I want to take all the metadata and data for a set of tables/views in the public schema of one DB and move it all over to be inside a schema of a second DB/instance. I'm using pg_du

Re: Duplicate key violation on upsert

On 3/25/20 5:23 PM, Matt Magoffin wrote: On 23/03/2020, at 1:10 PM, Adrian Klaver > wrote: So the query is in the function solardatum.store_datum()? If so what is it doing? Yes. This function first performs the INSERT INTO the solardatum.da_datum table tha

Re: Replacing Apache Solr with Postgre Full Text Search?

You are wellcome Andreas, and thanks for useful answer ;-) On Thu, Mar 26, 2020 at 4:33 PM Andreas Joseph Krogh wrote: > På onsdag 25. mars 2020 kl. 13:36:38, skrev J2eeInside J2eeInside < > j2eeins...@gmail.com>: > > Hi all, > > I hope someone can help/suggest: > I'm currently maintaining a pr

Re: Replacing Apache Solr with Postgre Full Text Search?

Thanks again. For the end, the finally question: On Thu, Mar 26, 2020 at 4:18 PM Mike Rylander wrote: > On Thu, Mar 26, 2020 at 4:03 AM J2eeInside J2eeInside > wrote: > > > > > P.S. I need to index .pdf, .html and MS Word .doc/.docx files, is there > any constraints in Ful Text search regarding

Sv: Replacing Apache Solr with Postgre Full Text Search?

På onsdag 25. mars 2020 kl. 13:36:38, skrev J2eeInside J2eeInside < j2eeins...@gmail.com >: Hi all, I hope someone can help/suggest: I'm currently maintaining a project that uses Apache Solr /Lucene. To be honest, I wold like to replace Solr with Postgre Full Text

Re: Replacing Apache Solr with Postgre Full Text Search?

On Thu, Mar 26, 2020 at 4:03 AM J2eeInside J2eeInside wrote: > > Hi Mike, and thanks for valuable answer! > In short, you think a PG Full Text Search can do the same as Apache Solr? > Can it? I mean, it does today. Whether it would for you depends on your needs and how much effort you can affor

Re: PG12 autovac issues

On Wed, Mar 25, 2020 at 8:43 PM Michael Paquier wrote: > > On Wed, Mar 25, 2020 at 10:39:17AM -0500, Justin King wrote: > > This started happening again. DEBUG1 is enabled: > > Thanks for enabling DEBUG1 logs while this happened. > > > Mar 25 14:48:26 cowtn postgres[39875]: [35298-1] 2020-03-25 >

Re: PostgreSQL 10 not archiving some WAL files

> > >>On Wed, Mar 18, 2020 at 10:57:22AM -0300, Norberto Dellê wrote: >> This setup worked very well for a long time, but since we upgraded >> PostgreSQL to newer versions (10.x), sometimes it just skips archiving some >> wal files. This seems to happen mainly when the server is shut down. >> There

Re: core. files inside base directory

On 2020-03-26 10:42:46 +, Daulat Ram wrote: > Hello, I have the core. Files inside the base directory of my postgres 10 > setup > . Would you please let me know the importance of these files . When they > generate . Can we delete them ? Core files are created by the kernel when a process cras

core. files inside base directory

Hello, I have the core. Files inside the base directory of my postgres 10 setup . Would you please let me know the importance of these files . When they generate . Can we delete them ? /base/ du -sh * 24M base 8.1Gcore.26166 1.5Gcore.26258 8.1Gcore.27849 12M core.27951 4.3G

Re: PostgreSQL 13: native JavaScript Procedural Language support ?

чт, 26 мар. 2020 г. в 10:08, Ivan E. Panchenko : > > > On 26.03.2020 03:50, Bruce Momjian wrote: > > On Wed, Mar 25, 2020 at 05:46:27PM +0200, Marius Andreiana wrote: > >> Thanks Tom, that makes sense. Appreciate your time to explain the context. > >> > >> I'll followup with Heroku. > > Also, I hav

Re: PostgreSQL 13: native JavaScript Procedural Language support ?

On Thu, Mar 26, 2020 at 10:07:48AM +0300, Ivan Panchenko wrote: > > On 26.03.2020 03:50, Bruce Momjian wrote: > > On Wed, Mar 25, 2020 at 05:46:27PM +0200, Marius Andreiana wrote: > > > Thanks Tom, that makes sense. Appreciate your time to explain the context. > > > > > > I'll followup with Herok

Re: Replacing Apache Solr with Postgre Full Text Search?

Hi Mike, and thanks for valuable answer! In short, you think a PG Full Text Search can do the same as Apache Solr? P.S. I need to index .pdf, .html and MS Word .doc/.docx files, is there any constraints in Ful Text search regarding those file types? On Wed, Mar 25, 2020 at 3:36 PM Mike Rylander

Re: PostgreSQL 13: native JavaScript Procedural Language support ?

On 26.03.2020 03:50, Bruce Momjian wrote: On Wed, Mar 25, 2020 at 05:46:27PM +0200, Marius Andreiana wrote: Thanks Tom, that makes sense. Appreciate your time to explain the context. I'll followup with Heroku. Also, I have heard PL/V8 is very hard to build for packagers (because of changes b