Hi,
Partitioning of a table with sequence id as one of its fields is
supported in postgresql12?
Regards,
Seenu.
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
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
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
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?
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 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, 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 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
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 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
>
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?
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, 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
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.
>
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 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
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
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
"
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 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
21 matches
Mail list logo
