Re: Import Database

Поиск
Список
Период
Сортировка
От Sathish Kumar
Тема Re: Import Database
Дата
Msg-id CANa_DOhr1M1bS1MjxJ5LHDF1naMj8-iNevjnD9=RqjH6=MZOOA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Import Database  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-general
Дерево обсуждения
Hi All,

Is there any other option to restore faster using psql, since I have to export it as plain text dump.

--format=plain

Only plain SQL format is supported by Cloud SQL.



I cannot use pgrestore option for plain text sql dump restore.

On Mon, May 6, 2019, 6:35 PM Andreas Kretschmer <andreas@a-kretschmer.de> wrote:


Am 05.05.19 um 19:26 schrieb Ron:
> On 5/5/19 12:20 PM, Andreas Kretschmer wrote:
>>
>>
>> Am 05.05.19 um 18:47 schrieb Sathish Kumar:
>>> Is there a way to speed up the importing process by tweaking
>>> Postgresql config like maintenance_workmem, work_mem, shared_buffers
>>> etc.,
>>
>> sure, take the dump in custom-format and use pg_restore with -j
>> <number_of_jobs>.
>
> Custom format or directory format?

both are possible for that.

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



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

Предыдущее
От: Michel Pelletier
Дата:
Сообщение: Re: Postgres for SQL Server users
Следующее
От: Steven Schlansker
Дата:
Сообщение: Re: Computed index on transformation of jsonb key set