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/
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 |
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 |