Skip site navigation (1) Skip section navigation (2)

Re: pg_dump -s dumps data?!

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: depesz(at)depesz(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump -s dumps data?!
Date: 2012-01-27 23:00:24
Message-ID: 4F232C88.2010605@gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On 01/27/2012 02:19 PM, hubert depesz lubaczewski wrote:
> 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!:

Are those 4 machines different from the other 6+?
What does the script do?
I am guessing you have not seen this in previous versions of postgres?

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


-- 
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

pgsql-hackers by date

Next:From: hubert depesz lubaczewskiDate: 2012-01-27 23:05:30
Subject: Re: pg_dump -s dumps data?!
Previous:From: Alvaro HerreraDate: 2012-01-27 22:55:55
Subject: Re: Dry-run mode for pg_archivecleanup

pgsql-general by date

Next:From: hubert depesz lubaczewskiDate: 2012-01-27 23:05:30
Subject: Re: pg_dump -s dumps data?!
Previous:From: hubert depesz lubaczewskiDate: 2012-01-27 22:19:18
Subject: pg_dump -s dumps data?!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group