pg_dump -s dumps data?!

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump -s dumps data?!
Date: 2012-01-27 22:19:18
Message-ID: 20120127221918.GA25467@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(at)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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-01-27 23:00:24 Re: pg_dump -s dumps data?!
Previous Message Giuseppe Sacco 2012-01-27 18:28:44 Re: error "permission denied for relation" on postgresql 9.0.6 during CREATE TABLE

Browse pgsql-hackers by date

  From Date Subject
Next Message Dan Scales 2012-01-27 22:31:54 double writes using "double-write buffer" approach [WIP]
Previous Message Jeff Janes 2012-01-27 22:05:41 Re: CLOG contention, part 2