Postgres - search for value throughout many tables?

Hi everyone, I want to aks if anyone knows is there a way to search for specific "value" throughout list of tables OR all tables in databse? Cheers, czezz

Re: Postgres - search for value throughout many tables?

On Wednesday, August 8, 2018, czezz wrote: > Hi everyone, > I want to aks if anyone knows is there a way to search for specific > "value" throughout list of tables OR all tables in databse? > Can you pg_dump your database to plain text and search that? Nothing built in provides that ability tho

FW: Pg_rewind cannot load history wal

We think we have found our missing step. We needed to do an ordered shutdown of the original primary before promoting the standby I.e. >1. Make some changes to the A (the primary) and check that they are replicated >to the B (the standby) Missing step: Perform ordered shutdown of A (the pr

Re: Postgres - search for value throughout many tables?

If the num of tables is smallish you could run smth like select * from ( select table1::text as thecol from table1 UNION select table2::text FROM table2 UNION select table3::text FROM table3 UNION . ) as qry WHERE thecol ~* 'some pattern'; On 08/08/2018 17:09, czezz wrote: Hi everyone, I wa

Odp: Re: Postgres - search for value throughout many tables?

Hi, thanks that is actually a good hint :) Dnia 8 sierpnia 2018 16:13 David G. Johnston napisał(a): On Wednesday, August 8, 2018, czezz < cz...@o2.pl > wrote: Hi everyone, I want to aks if anyone knows is there a way to s

Postgres replication -- .done file in slave

Hello Everyone, I have a postgres 9.5 with Master slave setup. The slave is a streaming replication client. I have a lot ( >100k ) of .done files in my slave's pg_xlog/archive_status/ directory Since this is a streaming replication I have disabled archive_mode in both master & slave. Also,

Re: Postgres - search for value throughout many tables?

On Wed, 8 Aug 2018 at 10:14, David G. Johnston wrote: > > On Wednesday, August 8, 2018, czezz wrote: >> >> Hi everyone, >> I want to aks if anyone knows is there a way to search for specific "value" >> throughout list of tables OR all tables in databse? > > > Can you pg_dump your database to pla

Re: Pg_rewind cannot load history wal

Yes, consider using Repmgr. > On 08-Aug-2018, at 3:20 AM, Richard Schmidt > wrote: > > We think we have found our missing step. We needed to do an ordered shutdown > of the original primary before promoting the standby > I.e. > > >1. Make some changes to the A (the primary) and check that th