Home > mailing lists

Re: Restore after using pg_dumpall - Mailing list pgsql-admin

From	raghu ram
Subject	Re: Restore after using pg_dumpall
Date	July 29, 2013 16:34:17
Msg-id	CALnrrJS75KM9rq8sEmWWTq-QZERh-H=vL=EMYP5es7Cvuxf=ZA@mail.gmail.com Whole thread Raw
In response to	Restore after using pg_dumpall (Asmus Reinhard <Reinhard.Asmus@spdfraktion.de>)
List	pgsql-admin

On Mon, Jul 29, 2013 at 6:49 PM, Asmus Reinhard <Reinhard.Asmus@spdfraktion.de> wrote:

Hallo,

between

pg_dumpall > alldb.sql (store)

According above command,you are taking all databases dump in plain text format which are available in PostgreSQL cluster running on 5432 port number.

and

psql –f alldb.sql postgres (restore)

is it necessary to drop existing objects (for example roles, …) ?

According to above command,Restoring plain text dumpfile into same PostgreSQL cluster running on 5432 port number.

If my assumptions are correct then you should drop existing database objects.

Thanks & Regards

Raghu Ram

From: Asmus Reinhard
Date: 29 July 2013, 16:19:43
Subject: Restore after using pg_dumpall

From: German Becker
Date: 29 July 2013, 17:17:16
Subject: Re: Disk latency goes up during certaing pediods