Hi All,
I am using postgresql 12. As part of streaming replication setup, I run
pg_basebackup on the slave which copies the database from master to slave.
But the database is huge and it takes around 2 to 3 days for the
pg_basebackup to finish. When pg_basebackup is running, a huge number of
w
Hi All,
I have a primary postgresql 12 server which is being continuously used
for transaction processing. For reporting purposes, I want to set up a
secondary server which has got previous day data. Everyday night, I want
the data from primary to be shifted to secondary. I can achieve this
m
Hi,
I have the following in my log files:
2020-11-20 11:20:46.216 IST [38207] LOG: execute S_1/C_2: SELECT
"gid",encode(ST_AsBinary(ST_Simplify(ST_Force2D("shape"),
14.929338247701526, true)),'base64') as "shape" FROM
"ami_smart_new"."aoi_boundary" WHERE ("sectioncode" IN ('4683', '4587') AND
"
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
>> logi
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 serve
Hi All,
Is it possible to have both type of replications (streaming and logical)
from a single server?
If I have 3 servers A,B and C, then I want to have streaming replication
from A to B whereas logical replication from A to C. Is it possible?
Regards,
Seenu.
On Thu, Oct 1, 2020 at 2:47 PM Alban Hertroys <
alban.hertr...@apollovredestein.com> wrote:
> Hi all,
>
> We're seeing the FATAL error message from the subject pop up in our logs
> at regular intervals, but I haven't been able to pinpoint what is causing
> it. I'm hoping for some insights here.
>
On Tue, Aug 18, 2020, 8:04 PM Stephen Frost wrote:
> Greetings,
>
> * Adam Sjøgren (a...@koldfront.dk) wrote:
> > We have a PostgreSQL 11.3¹ running on an Ubuntu 16.04 server, which
> > sometimes exhibits a behaviour I can't quite understand: simply logging
> > into the database starts to take mi
There may be lot of wal files or the size of log files in pg_log might be
huge. "du -sh *" of data directory holding the database might help.
Regards,
Seenu.
On Tue, Aug 4, 2020 at 2:09 PM Chris Borckholder <
chris.borckhol...@bitpanda.com> wrote:
> Hi!
>
> We are experiencing a strange situat
On Tue, Jul 21, 2020 at 10:46 PM Vasu Madhineni
wrote:
> Hi All,
>
> Planning to build standalone postgres and with pgpool as connection pooler
> in docker containers.
> Shall we try option like installing pgpool in one docker container and
> postgres in another docker container, is it possible?
On Mon, Jul 13, 2020, 7:16 PM FOUTE K. Jaurès wrote:
> Hello,
>
> How can i solve this error
>
More info required
Regards,
Seenu.
>
> --
> Jaurès FOUTE
>
4 repo).
>
Any problem reverting to older version of systemd?
Regards,
Seenu.
>
>>
> On Sun, Jun 21, 2020 at 6:05 AM Srinivasa T N wrote:
>
>>
>>
>> On Sun, Jun 21, 2020, 8:57 AM Vishal Agrawal
>> wrote:
>>
>>> Hello,
>>>
>>&
On Sun, Jun 21, 2020, 8:57 AM Vishal Agrawal
wrote:
> Hello,
>
> I'm trying to install postgresql 12 on CentOS 8.2 as following -
>
> First I run docker container on the host -
> # docker run --privileged -dit --name pgdg centos:8.2.2004 /sbin/init
>
> Then inside the container, I run the comman
On Fri, Jun 19, 2020, 5:45 PM Amul Sul wrote:
> On Fri, Jun 19, 2020 at 3:50 PM Srinivasa T N wrote:
> >
> >
> >
> > On Fri, Jun 19, 2020 at 3:09 PM Amul Sul wrote:
> >>
> >> On Fri, Jun 19, 2020 at 1:28 PM Srinivasa T N
> wrote:
> >&g
On Fri, Jun 19, 2020 at 3:09 PM Amul Sul wrote:
> On Fri, Jun 19, 2020 at 1:28 PM Srinivasa T N wrote:
> >
> > On Fri, Jun 19, 2020 at 12:34 PM Laurenz Albe
> wrote:
> >>
> >> On Fri, 2020-06-19 at 12:12 +0530, Srinivasa T N wrote:
> >> > On Fri
On Fri, Jun 19, 2020 at 12:34 PM Laurenz Albe
wrote:
> On Fri, 2020-06-19 at 12:12 +0530, Srinivasa T N wrote:
> > On Fri, Jun 19, 2020 at 11:44 AM David Rowley
> wrote:
> > > On Fri, 19 Jun 2020 at 17:42, Srinivasa T N wrote:
> > > >After seeing the
On Fri, Jun 19, 2020 at 11:44 AM David Rowley wrote:
> On Fri, 19 Jun 2020 at 17:42, Srinivasa T N wrote:
> >After seeing the below, I feel partitioning is not working properly
> or it maybe case that my understanding is wrong. Can somebody explain me
> what is happening?
Hi,
After seeing the below, I feel partitioning is not working properly or
it maybe case that my understanding is wrong. Can somebody explain me what
is happening?
postgres=# create table busbar_version (objectid int, ver_id int) partition
by hash(ver_id);
CREATE TABLE
postgres=# CREATE TABLE
I am using declarative partitioning on some other field of the same table
in which gid also exists.
Regards,
Seenu.
On Thu, Jun 18, 2020 at 12:31 PM amul sul wrote:
> On Thu, Jun 18, 2020 at 12:22 PM Srinivasa T N wrote:
> >
> > Hi,
> >I have a parent table with one
be any race condition
causing two child tables getting the same sequence value for gid?
Regards,
Seenu.
On Thu, Jun 18, 2020 at 12:09 PM amul sul wrote:
> On Thu, Jun 18, 2020 at 12:00 PM Srinivasa T N wrote:
> >
> > Hi,
> >Partitioning of a table with sequence id as
Hi,
Partitioning of a table with sequence id as one of its fields is
supported in postgresql12?
Regards,
Seenu.
21 matches
Mail list logo
