pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRestore after using pg_dumpall
3+ messages / 3 participants
[nested] [flat]
* Restore after using pg_dumpall
@ 2013-07-29 13:19 Asmus Reinhard <Reinhard.Asmus@spdfraktion.de>
0 siblings, 2 replies; 3+ messages in thread
From: Asmus Reinhard @ 2013-07-29 13:19 UTC (permalink / raw)
To: pgsql-admin
Hallo,
between
pg_dumpall > alldb.sql (store)
and
psql -f alldb.sql postgres (restore)
is it necessary to drop existing objects (for example roles, ...) ?
Any help is appreciated.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Restore after using pg_dumpall
@ 2013-07-29 13:33 raghu ram <raghuchennuru@gmail.com>
parent: Asmus Reinhard <Reinhard.Asmus@spdfraktion.de>
1 sibling, 0 replies; 3+ messages in thread
From: raghu ram @ 2013-07-29 13:33 UTC (permalink / raw)
To: Asmus Reinhard <Reinhard.Asmus@spdfraktion.de>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Restore after using pg_dumpall
@ 2013-07-31 07:00 Samrat Revagade <revagade.samrat@gmail.com>
parent: Asmus Reinhard <Reinhard.Asmus@spdfraktion.de>
1 sibling, 0 replies; 3+ messages in thread
From: Samrat Revagade @ 2013-07-31 07:00 UTC (permalink / raw)
To: pgsql-admin
>pg_dumpall > alldb.sql (store)
>and
>psql -f alldb.sql postgres (restore)
>is it necessary to drop existing objects (for example roles, ...) ?
>Any help is appreciated.
I think it is not necessary. pg_dumpall supports dumping of the entire
contents of a database cluster, It backs up each database in a given
cluster, and also *preserves cluster-wide data such as role and tablespace
definition*s. hence if you want to take backup for entire cluster then you
can directly use pg_dumpall.
or if you have any specific need then you can use pg_dump and manually
preserve/delete other database objects .
-----
Greetings,
Samrat Revagade,
NTT-DATA-OSS Center (Pune)
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Restore-after-using-pg-dumpall-tp5765452p5765716.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-07-31 07:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-07-29 13:19 Restore after using pg_dumpall Asmus Reinhard <Reinhard.Asmus@spdfraktion.de>
2013-07-29 13:33 ` raghu ram <raghuchennuru@gmail.com>
2013-07-31 07:00 ` Samrat Revagade <revagade.samrat@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox