On 6/23/20 9:44 AM, Edu Gargiulo wrote:
On Tue, Jun 23, 2020 at 11:45 AM Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:On 6/23/20 7:37 AM, Edu Gargiulo wrote: > > > On Tue, Jun 23, 2020 at 10:56 AM Adrian Klaver > <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx> <mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>>> wrote: > > On 6/23/20 6:48 AM, Edu Gargiulo wrote: > > On Tue, Jun 23, 2020 at 10:34 AM Adrian Klaver > > <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx> <mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> > <mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx> > <mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>>>> 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?
-- edugarg
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
