pg_dump -s dumps data?! - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject pg_dump -s dumps data?!
Date
Msg-id 20120127221918.GA25467@depesz.com
Whole thread Raw
Responses Re: pg_dump -s dumps data?!
Re: pg_dump -s dumps data?!
List pgsql-general
hiu
I have weird situation.
pg 9.1.2, compilet by our own script from source, on 10+ machines.
on fours machines, pg_dump -s <database_name> - dumps with data!:

postgres@machine:~$ pg_dump --verbose  --schema-only dbname > q
...
pg_dump: creating TABLE x1
pg_dump: restoring data for table "x2"
pg_dump: dumping contents of table x2
pg_dump: restoring data for table "x3"
pg_dump: dumping contents of table x3
...

What could be wrong?

Same pg_dump call on the same host, but for different database dumps just schema!?

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

pgsql-general by date:

Previous
From: Giuseppe Sacco
Date:
Subject: Re: error "permission denied for relation" on postgresql 9.0.6 during CREATE TABLE
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump -s dumps data?!