From: | Shrikant Bhende <shrikantbhende(dot)net(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: FATAL: terminating connection because protocol synchronization was lost |
Date: | 2018-10-16 15:36:53 |
Message-ID: | CADrerVU2XoEcDm23cc5EH9KdWVhSbxhCA3TAtWn09rL63N_b4w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Adrian,
Thanks for your reply.
O/S is centos 6.7 on AWS EC2 ,
this is happening when system starts copying data for the biggest table, so
just to reconfirm I have taken a pg_dump with Fp for that single table and
tried to restore the same into PG cluster which was successful, and then
again when I tried to restore the complete cluster dump taken using
pg_dumpall it failed again.
Table structure :
cloud=# \d+ t_3ecc35f89a0c485eb365744bde452408.jx_objectstore_journal
Table
"t_3ecc35f89a0c485eb365744bde452408.jx_objectstore_journal"
Column | Type | Modifiers | Storage |
Stats target | Description
----------------+-----------------------------+-----------+----------+--------------+-------------
did | integer | not null | plain |
|
start | timestamp without time zone | not null | plain |
|
ending | timestamp without time zone | not null | plain |
|
deltas | text | | extended |
|
deltacount | integer | | plain |
|
finalstate | text | | extended |
|
measure_start | timestamp without time zone | | plain |
|
measure_ending | timestamp without time zone | | plain |
|
Indexes:
"jx_objectstore_journal_pkey" PRIMARY KEY, btree (did, start, ending)
"idx_jx_objectstore_journal_did" btree (did)
"idx_jx_objectstore_journal_ending" btree (ending)
"idx_jx_objectstore_journal_start" btree (did, start)
Has OIDs: no
Actual table size is around 2GB and toast table size is 288 GB which might
have around 80 GB of dead rows.
Thanks
On Tue 16 Oct, 2018, 20:23 Adrian Klaver, <adrian(dot)klaver(at)aklaver(dot)com> wrote:
> On 10/16/18 7:29 AM, Shrikant Bhende wrote:
> > Hi Adrian,
> >
> > Its a PostgreSQL binary and installer was downloaded from enterprisedb
> site.
> > Binary version : psql (PostgreSQL) 9.6.10
> >
> > Command to restore the dump is :
> > ./psql -p 5434 -d cloud -f <path of the file>
>
> Hmm.
>
> What OS is this?
>
> Does the error always happen in the same place in the restore?
>
> >
> > Thanks
> >
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2018-10-16 18:13:28 | judging acceptable discrepancy in row count v. estimate |
Previous Message | Scot Kreienkamp | 2018-10-16 15:35:30 | RE: Pgbouncer discard all |