pg_dump not dumping all tables

From: Stefan Schwarzer <stefan(dot)schwarzer(at)unep(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump not dumping all tables
Date: 2012-06-22 08:45:35
Message-ID: B763E8DA-86A3-4B65-8A3C-9E37984A32F6@unep.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,

I am pg_dump-ing all tables from schema public on the server

/usr/local/pgsql/bin/pg_dump -U user my_database --schema=public --encoding=UTF-8 > dump.sql

and re-loading it via psql on my local machine.

But instead of having 708 tables as on the server, I end up with only 570 on my local machine.

When trying to search for the name of a missing table in the dump file, it is indeed not there. Owner of the table is the same as on all other tables…

What could that be?

Thanks for any hint!

Stef

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2012-06-22 10:02:42 Re: pg_dump not dumping all tables
Previous Message Stefan Schwarzer 2012-06-22 07:19:52 Re: Problem installing extensions on Lion