Re: Both type of replications from a single server?

On Thu, Oct 8, 2020 at 12:19 PM Michael Paquier wrote: > On Thu, Oct 08, 2020 at 11:43:26AM +0530, Srinivasa T N wrote: > >Is it possible to have both type of replications (streaming and > logical) > > from a single server? > > Yes. > > >If I have 3 servers A,B and C, then I want to have

pgadmin4 error

Hello, I use pgadmin4 with server installation, on Centos7, installed from official postgresql yum repo. Since v4.24, IIRC, I got error when I try to visualize the SQL for a table: INTERNAL SERVER ERROR ... expected token 'end of statement block', got '.' For views, foreign tables or any o

Re: Both type of replications from a single server?

On Thu, Oct 8, 2020 at 12:50 PM Srinivasa T N wrote: > On Thu, Oct 8, 2020 at 12:19 PM Michael Paquier > wrote: > >> On Thu, Oct 08, 2020 at 11:43:26AM +0530, Srinivasa T N wrote: >> >Is it possible to have both type of replications (streaming and >> logical) >> > from a single server? >> >>

Re: Both type of replications from a single server?

On Thu, Oct 08, 2020 at 01:25:14PM +0530, Srinivasa T N wrote: > For streaming replication, I need to set wal_level to replica in A whereas > for logical_replication we need to set wal_level to replica in the same A > server. So, was wondering how to go about? A logical replica needs wal_level =

Re: How to migrate column type from uuid to serial

On Thu, Oct 8, 2020 at 6:14 AM Hemil Ruparel wrote: > I was thinking UUID was not a very good choice for id. Serial would be a > better one because I don't have a billion customers. It is more like a > thousand. So when I saw the customer ID of the payment gateway cannot accept > more than 32 c

Does the work made by vaccum in the current pass is lost when interrupted?

I have a large table (billions of records) which has not been vacuum and bloated. Vacuum scale factor was left at the default. I ran a vacuum on a DEV system and it makes several passes (scanning heap/vacuuming indexes/vacumming heap) which take more than an hour each. On a PROD system, I may ha

Version10.8 startup issue

Hi all Please help me to fix the start up issues. I want postgresql to start when server reboots on linux 7.6 environment-Rhel Systemctl start postgresql-10 will turn on but not while reboot. Postgres 9.4.5 starts during startup . Please help Thanks Deepthi

Re: Version10.8 startup issue

Udaya Deepthi writes: > I want postgresql to start when server reboots on linux 7.6 environment-Rhel > Systemctl start postgresql-10 will turn on but not while reboot. > Postgres 9.4.5 starts during startup . You probably want to read about "systemctl enable" and "systemctl disable".

Re: Version10.8 startup issue

On 10/8/20 2:19 PM, Udaya Deepthi wrote: Hi all Please help me to fix the start up issues. I want postgresql to start when server reboots on linux 7.6 environment-Rhel Systemctl start postgresql-10 will turn on but not while reboot. If you installed from the community repos see bottom of thi

Re: Gurjeet Singh Index Adviser User Interface

Goodnight, I apologize please that today I was able to test the directory, since I had a health problem in recent days. Well, I actually found the files corresponding to the pg_advise_index interface. But I was surprised that the executable is not present, but apparently this interface must be com

Re: Gurjeet Singh Index Adviser User Interface

I also clarify that I tried to install the libpq-dev package already but could not install it because it depends on a non-installable package called libss10.9.8. And I had to apply apt --fix-broken install to fix the problem.

rum index supported on pg13?

will rum index from postgrespro be supported in pg13? numerous errors occur when compiling rum in pg13 and no replies from github. the differences from pg12 to pg13 seem to be significant https://github.com/postgrespro/rum thanks for such a brilliant extension. perhaps i should jump in and