| From: | Sathish Kumar <satcse88(at)gmail(dot)com> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Import Database |
| Date: | 2019-05-07 01:22:44 |
| Message-ID: | CANa_DOhr1M1bS1MjxJ5LHDF1naMj8-iNevjnD9=RqjH6=MZOOA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)a-kretschmer(dot)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
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steven Schlansker | 2019-05-07 01:26:17 | Re: Computed index on transformation of jsonb key set |
| Previous Message | Michel Pelletier | 2019-05-06 22:52:15 | Re: Postgres for SQL Server users |