2009/10/22 Grzegorz Jaśkiewicz :
>
>
> On Thu, Oct 22, 2009 at 3:42 PM, Scot Kreienkamp
> wrote:
>>
>> Hi everyone,
>>
>>
>>
>> I have a question about pg_dump backups. Will changes made in the
>> database made during a pg_dump operation be reflected in the dumped
>> datafile? Or is the data the
On Thu, Oct 22, 2009 at 3:42 PM, Scot Kreienkamp wrote:
> Hi everyone,
>
>
>
> I have a question about pg_dump backups. Will changes made in the database
> made during a pg_dump operation be reflected in the dumped datafile? Or is
> the data the exact dataset that was in the database as of the
Hi everyone,
I have a question about pg_dump backups. Will changes made in the
database made during a pg_dump operation be reflected in the dumped
datafile? Or is the data the exact dataset that was in the database as
of the start of the backup?
>From what I understand of the documentatio
Vivek Khera ha scritto:
>
> On Sep 28, 2007, at 9:07 AM, Ottavio Campana wrote:
>
>> But why does pg_dump does not already exports data such that previous
>> tables do not depend on successive ones?
>
> Because you can't always sort your tables that way. The restore
> procedure is responsible f
On Sep 28, 2007, at 9:07 AM, Ottavio Campana wrote:
But why does pg_dump does not already exports data such that previous
tables do not depend on successive ones?
Because you can't always sort your tables that way. The restore
procedure is responsible for either sorting or disabling the FK
Ottavio Campana wrote:
> Richard Huxton ha scritto:
> > Ottavio Campana wrote:
> >>
> >> Is there a way to export tables in order, so that dependencies are
> >> always met? reading the manpage of pg_dump I found the -Fc flag, but I
> >> haven't understood if it is good for me and how it works. Or i
Richard Huxton ha scritto:
> Ottavio Campana wrote:
>>
>> Is there a way to export tables in order, so that dependencies are
>> always met? reading the manpage of pg_dump I found the -Fc flag, but I
>> haven't understood if it is good for me and how it works. Or is there a
>> way to relax constrain
Ottavio Campana wrote:
Is there a way to export tables in order, so that dependencies are
always met? reading the manpage of pg_dump I found the -Fc flag, but I
haven't understood if it is good for me and how it works. Or is there a
way to relax constraints while loading data?
Try a pg_dump wi
I have a database which I create using dia and tedia2sql.
I developed another version with more tables, without changing anything
that was already present in the first version.
Now I want to copy the data from one database to another, so I thought
about pg_dump -a, assuming that since there is no
At 00:10 14/10/00 -0400, Tom Lane wrote:
>I think the slides for that
>talk are fairly self-contained and might be of general interest;
>shall I brace Vince about putting them up on the website?
This would be good to see. Would it fit in the documentation hierarchy
somewhere?
--
On Sat, 14 Oct 2000, Tom Lane wrote:
> I've just finished putting together a talk about MVCC transaction
> processing --- both how it behaves and how it's implemented --- for
> the upcoming OSDN database conference. I think the slides for that
> talk are fairly self-contained and might be of gen
"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> Well, all you're doing with pg_dump is getting a snapshot of the database at
> a single point in time -- as pg_dump reads the data out of the tables, I'm
> sure that it won't go back and re-read tables that have changed since it was
> first started. On
At 16:53 13/10/00 -0200, Vilson farias wrote:
>Hi.
>
>I started testing pg_dump and I have a little question :
>
>What does pg_dump with data arrived while its running?
>
pg_dump runs in a single transaction, so in theory it dumps a consistent
view of the data, not necessarily the absolute latest
13 matches
Mail list logo
