Re: Logical replication failed recovery

Hi Lou, Try setting wal_keep_segments parameter to a higher value. I think it will suffice to solve the problem. Regards, Pavan Teja, 9841380956 On Sun, 7 Apr, 2019, 6:53 PM Lou Tseng, wrote: > Hi folks, > > Is there a good tutorial to recover from logical replication out of sync?

Re: Seeded Replication

approach. Kindly revert back if any queries. Regards, Pavan Teja, 9841380956 On Wed, 3 Apr, 2019, 5:15 PM Lou Tseng, wrote: > Hi, > > We are working on a project to set up replication from on premises > Postgresql 10.4 to Azure Postgresql services. However, our database is > about 2

Re: logical replication problem

15 AM Pavan Teja > wrote: > > > > Does the db_server_B has data in it?? > > Yes, it has -- about 51GiByte ... Changed frequently. > > > Regards, > > Pavan > > > > On Mon 28 Jan, 2019, 3:42 PM Thomas Schweikle wrote: > >> > >> Hi! >

Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup.

Hi, You can use -j jobs option to speed up the process. Hope it works. Regards, Pavan On Thu, Oct 11, 2018, 8:02 AM Raghavendra Rao J S V < raghavendra...@gmail.com> wrote: > Hi All, > > pg_dump is taking more time. Please let me know which configuration > setting we need to modify to speedup

Re: Schema/Data conversion opensource tools from MySQL to PostgreSQL

Hi Chiru, You can use MySQL foreign data wrapper to achieve this. Regards, Pavan On Mon, Jun 25, 2018, 10:18 PM chiru r wrote: > Hi All, > > > Please suggest Schema/Data conversion opensource tools from MySQL to > PostgreSQL. > > > Thanks, > Chiranjeevi >

Re: Drop Default Privileges?

Hi Louis, In order to remove the default privileges for any particular user/role, we should know the list of default privileges. If we know them we can revoke them as a super user. Once I tried finding the list of default privileges, but left with no clue. But I strongly believe that if we know t

Re: Merging two database dumps

Hi Alex, For storing duplicate rows, dropping primary and unique indexes is the only way. One alternative is create a column with timestamp which updates on every insert/update so that timestamp will be primary. Hope it helps. Regards, Pavan On Wed, Jun 13, 2018, 4:47 PM Alex O'Ree wrote: > I

Re: First query on each connection is too slow

Hi Vadim, Too much of shared buffers allocation also causes problem. Read the documentation. Regards, Pavan On Wed, Jun 13, 2018, 3:23 PM Vadim Nevorotin wrote: > I have a very strange problem. I'm using PostgreSQL 9.6 with PostGIS 2.3 > (both from Debian Strecth repos) to store DB for OSM se

Re: Performance problem postgresql 9.5

Could you please give more briefing about the queries executed. Let me know whether they are dml or ddl. Provide information like how long and from what time the queries are in running state, so that we can find a way to find the exact pain area. What is the size of the database?? When were the s

Re: How to get postmaster shut down time in postgres?

Thank you so much for your replies.😀 On Mon, Jun 4, 2018, 7:25 PM Adrian Klaver wrote: > On 06/04/2018 06:44 AM, pavan95 wrote: > > Hi Adrian/Melvin, > > > > Thanks for your prompt replies. Yeah, I'm aware of that way. > > > > But my requirement is to get the server shutdown time whenever that e

Re: Tracking DDL and DML changes in Postgresql and different versions of database (advance)

On Wed, May 30, 2018, 11:03 AM Łukasz Jarych wrote: > Hi Guys, > > i am using Access FE and Postgresql BE. > To track DML changes i have history log table wotking like here: > > https://www.fontstuff.com/access/acctut21.htm > > It is ok but this doesnt solve the problem with trakich DDL changes.

Re: Upgrading from Postgresql 9.1 to 10

Yeah David, Even I'm thinking the same Regards, Pavan On Feb 14, 2018 8:34 PM, "David G. Johnston" wrote: > > > On Wednesday, February 14, 2018, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Wednesday, February 14, 2018, pavan95 >> wrote: >> >>> Hi all, >>> >>> Is it possib

Re: Upgrading from Postgresql 9.1 to 10

Thank you for your timely response 😊 On Feb 14, 2018 8:18 PM, "Melvin Davidson" wrote: > > > On Wed, Feb 14, 2018 at 9:42 AM, pavan95 > wrote: > >> Hi all, >> >> Is it possible to upgrade an existing postgresql 9.1 production system to >> latest Postgres 10.0 version? >> >> The main requirement

Re: FATAL: failed to create a backend connection

On Feb 2, 2018 5:57 PM, "Vikas Sharma" wrote: Hi There, We are using Postgresql 9.3 with pgpool-II-93-3.5.10. One Master replicating to 3 Standbys using streaming replication. Pgpool is used for load balancing only. Lately we are seeing below on application servers. Caused by: org.postgresql.u

Re: FW: Setting up streaming replication problems

On Jan 23, 2018 11:34 PM, "Martin Goodson" wrote: On 23/01/2018 07:36, Thiemo Kellner, NHC Barhufpflege wrote: > 1) I am not sure whether to put the md5 value of the repuser password > >> into primary conninfo or the plain one. I don't feel the documentation >>> or the book is clear on that. >