Re: pg_dump empty tables - Mailing list pgsql-general
| From | Edu Gargiulo |
|---|---|
| Subject | Re: pg_dump empty tables |
| Date | |
| Msg-id | CAD_UXMYzaXfT-qcUzXeE-Wpi+CobzL=fdzKtsL=dXNbuMMdYVg@mail.gmail.com Whole thread Raw |
| In response to | Re: pg_dump empty tables (Adrian Klaver <adrian.klaver@aklaver.com>) |
| List | pgsql-general |
On Tue, Jun 23, 2020 at 2:25 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 6/23/20 9:44 AM, Edu Gargiulo wrote:
>
> On Tue, Jun 23, 2020 at 11:45 AM Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
> On 6/23/20 7:37 AM, Edu Gargiulo wrote:
> >
> >
> > On Tue, Jun 23, 2020 at 10:56 AM Adrian Klaver
> > <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>> wrote:
> >
> > On 6/23/20 6:48 AM, Edu Gargiulo wrote:
> > > On Tue, Jun 23, 2020 at 10:34 AM Adrian Klaver
> > > <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com> <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>
> > <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>
> > <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>>> wrote:
> > >
> > > On 6/23/20 6:30 AM, Edu Gargiulo wrote:
> > > > Hi all,
> > > >
> > > > We are using postgresql 11.7 on Debian.
> > > > I noticed that pg_dump is not including records on
> tables with
> > > fields
> > > > defined as array type (integer[] and real[]). The table
> > structure is
> > > > normally restored but they have 0 records on restoring.
> > >
> > > What is the complete command you are using when
> running pg_dump?
> > >
> > >
> > > /usr/bin/pg_dump -d historic -Z 9 -Fc -f srvtsdb01.dmp
> >
> > Coffee has kicked in and I realized I should have asked for the
> > pg_restore command as well. So what is that?
> >
> >
> > pg_restore -d historic -h localhost --clean srvtsdb01.dmp
> > pg_restore -d historic --schema well --verbose srvtsdb01.dmp
> > pg_restore -d historic --schema well --clean --verbose srvtsdb01.dmp
> >
>
> With --verbose are you seeing any errors?
>
> What does pg_restore -V show?
>
>
> Thanks for your response Adrian, looking at the pg_restore output I saw
> issues with triggers and timescaledb extension on restoring those empty
> tables.
I'm going to bet that is the problem.
What where the errors?
Is the timescaledb extension installed on the database you are restoring to?
It was not installed on the restoring database. After install and execute timescaledb_pre_restore() and timescaledb_post_restore() before and after pg_restore it was restored normally.
Thank you very much
pgsql-general by date: