Horton

Re: pg_dump -s dumps data?!

Adrian Klaver <adrian.klaver@gmail.com>

View thread
From: Adrian Klaver <adrian.klaver@gmail.com>
To: depesz@depesz.com
Cc: pgsql-general@postgresql.org
Date: 2012-01-27T23:11:32Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add --section option to pg_dump and pg_restore.

  2. Add --exclude-table-data option to pg_dump.

On 01/27/2012 03:05 PM, hubert depesz lubaczewski wrote:
> On Fri, Jan 27, 2012 at 03:00:24PM -0800, Adrian Klaver wrote:
>> 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+?
>
> no idea. same os, same installation of pg.

So much for that idea:)

>
>> What does the script do?
>
> the compilation? just runs ./conmfigure with some options, make and make
> install.

Not sure that it makes a difference, but on the chance it does, what are 
the options and are they the same for all machines?

>
>> I am guessing you have not seen this in previous versions of postgres?
>
> that's the first time I saw this. and we never had older pg on thess
> machines.
>
> there is some suggestion that it might be related to extensions ... but
> I am not sure what/how to check.

I am not going to much help here, as I am still learning the extension 
mechanism. For the sake of others that might have a clue, what are the 
extensions involved?
Also, are all the tables having their data dumped or only those that 
relate to extensions?

>
> Best regards,
>
> depesz
>


-- 
Adrian Klaver
adrian.klaver@gmail.com