Re: pg_dump fundenental question

Поиск
Список
Период
Сортировка
От trafdev
Тема Re: pg_dump fundenental question
Дата
Msg-id 25a37d95-a304-8a8c-c873-c6f683d53ceb@mail.ru
обсуждение исходный текст
Ответ на Re: pg_dump fundenental question  ("Christofer C. Bell" <christofer.c.bell@gmail.com>)
Список pgsql-general
"less" is much better for opening huge text files in *nix for reading.

On 07/05/16 15:13, Christofer C. Bell wrote:
> On Tue, Jul 5, 2016 at 3:17 PM, Paul Linehan <linehanp@tcd.ie
> <mailto:linehanp@tcd.ie>> wrote:
>
>     > a good point, but I would prefer NOT to open a 324GB backup file in a text
>     > editor. I can however cat/less/head/tail the file in Linux.
>
>     Use vi (or flavour thereof) - it doesn't load the entire file in
>     order to
>     read the contents of lines 1 - 100 (say).
>
>
> What Paul says is very true, but if you are doing this, do be cognizant
> of where your fingers are.  If you press any key that will put vi into
> edit mode, it will then make a copy of the file for backup purposes.
> Your 324GB file will become 648GB of disk usage and you'll have to wait
> while the backup copy is written out to disk.  It will not load the
> whole file into memory (ever) nor will it make a copy of the file as
> long as you stay in command mode.
>
> If you want to use vi or equivalent for viewing the file without any
> danger of accidentally putting the editor into edit mode (and thus
> triggering the backup copy), you may want to invoke vi as "view(1)".
> This opens vi read-only and you'll be able to use vi style hotkeys for
> navigation.
>
>
>     Paul...
>
>
> Chris
>
> "If you wish to make an apple pie from scratch, you must first invent
> the Universe." -- Carl Sagan
>
>



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

Предыдущее
От: "Christofer C. Bell"
Дата:
Сообщение: Re: pg_dump fundenental question
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Possible to create canonicalized range type without being superuser?