pg_dump not dumping all tables - Mailing list pgsql-general

From Stefan Schwarzer
Subject pg_dump not dumping all tables
Date
Msg-id B763E8DA-86A3-4B65-8A3C-9E37984A32F6@unep.org
Whole thread Raw
Responses Re: pg_dump not dumping all tables
Re: pg_dump not dumping all tables
List 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
thesame as on all other tables… 

What could that be?

Thanks for any hint!

Stef

pgsql-general by date:

Previous
From: Stefan Schwarzer
Date:
Subject: Re: Problem installing extensions on Lion
Next
From: Alban Hertroys
Date:
Subject: Re: pg_dump not dumping all tables