Re: pg_restore and create FK without verification check

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_restore and create FK without verification check
Дата
Msg-id 16070.1069869159@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_restore and create FK without verification check  (Andreas Pflug <pgadmin@pse-consulting.de>)
Ответы Re: pg_restore and create FK without verification check
Re: pg_restore and create FK without verification check
Список pgsql-hackers
Andreas Pflug <pgadmin@pse-consulting.de> writes:
>> In principle you could do this today, but we don't have enough
>> support code in place to make it work smoothly, eg WAL segment files
>> aren't labeled with enough identifying information to let you manage
>> an archive full of 'em.  Still it doesn't seem that far away.

> So I issue CHECKPOINT, and tar the cluster or database. Still, I got two 
> questions:
> - how to restore a single database

You don't.  As I said, any physical backup is going to be
all-or-nothing.  These techniques are not a replacement for pg_dump.

> - while tar is running, CHECKPOINT(n+1) might be recorded in some files, 
> while others have CHECKPOINT(n). How does the backend know to rollback 
> to CHECKPOINT(n)?

That's part of the management code that we need to write before this
will really be very useful; you need to be able to associate the
starting time of a tar dump with the most recent previous CHECKPOINT
in the WAL logs.  Not hard in principle, just takes some code we ain't
got yet.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: pg_restore and create FK without verification check
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Providing anonymous mmap as an option of sharing memory