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
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 cust
Hi All,
Postgresql version: 9.6
On Mon, May 6, 2019, 7:14 AM Sathish Kumar wrote:
> Hi,
>
> I am trying to export our database in GCE instance to Google Cloud SQL.
>
> Below are the commands used to export/import the database. I am exporting
> only 1 database which is required.
>
> Export:
>
>
Hi,
I am trying to export our database in GCE instance to Google Cloud SQL.
Below are the commands used to export/import the database. I am exporting
only 1 database which is required.
Export:
pg_dump -h olddbserver -U dbuser --format=plain --no-owner --no-acl
production | sed -E 's/(DROP|C
Yes.
I do bump up maintenance_work_mem temporarily during a restore.
it helps in rebuilding on indexes a little faster.
Turning fsync off during restore will help the restore a little fast too
but in case of any crash you may have to restart the restore from scratch.
Also do have the option to take
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
.
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
. You can increase maintenance_work_mem maybe t
IMO you are using the slowest tool to import.
Just one quick question: Why can't you take cluster backup using any of the
tools available and then drop all
unwanted databases after you import the cluster.
pg_basebackup will do a good job.
