Unexpected trouble from pg_basebackup

From: otheus uibk <otheus(dot)uibk(at)gmail(dot)com>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Unexpected trouble from pg_basebackup
Date: 2016-10-04 20:28:13
Message-ID: CALbQNd0yBXSTY2p3CsxiZKWSk9bCXQRvC=weXdQ90QTRhq5szQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I recently updated my systems from pg 9.1.8 to 9.5.3. A pg_dumpall was used
to migrate the data. Now I'm trying to re-establish replication between
master and slave. I'm getting stuck.

When I run pg_basebackup (via a script which worked flawlessly on 9.1.8,
AND via command line, ala "manual mode"), it creates the PGDATA directory
structure, some files, but soon gets stuck. It writes fewer than 40 MB of a
20GB database. Further, using tcpdump to watch packets on the wire, I
confirm no data is going across.

However, it's clear a connection has been made and the process was started.
On the master, I see the process table:

postgres: wal sender process pgsync A.B.C.D(42821) sending backup

Meanwhile, on the client, I see no output updates. Here's the command:

pg_basebackup -x -P -v -D $PGDATA -w

PGUSER, PGPASSWORD and PGHOST are set accordingly. The User is a user with
the REPLICATION attribute. Just in case, I dropped and re-created the user.

So that's question A.

Question B is related. In attempting to verify that the permissions and HBA
were set correctly, I attempted to do a pg_dump using the same PGUSER and
PGHOST. What I got surprised me:

$ pg_dump -s onyxeditor
pg_dump: [archiver (db)] query failed: ERROR: permission denied for
relation licence
pg_dump: [archiver (db)] query was: LOCK TABLE public.licence IN ACCESS
SHARE MODE

This is the replication user. Other schemas worked just fine, but not this
one. Is this expected behavior?

Kind regards,
Otheus

--
Otheus
otheus(dot)uibk(at)gmail(dot)com
otheus(dot)shelling(at)uibk(dot)ac(dot)at

Responses

Browse pgsql-general by date

  From Date Subject
Next Message otheus uibk 2016-10-04 20:42:59 Re: Unexpected trouble from pg_basebackup
Previous Message Shaun McCready 2016-10-04 19:46:48 postgresql 9.5 upsert issue with nulls