From: | Scott Mead <scott(dot)lists(at)enterprisedb(dot)com> |
---|---|
To: | blast <carlosd2002(at)hotmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Backup&Restore Postgres DB |
Date: | 2010-03-22 17:57:55 |
Message-ID: | d3ab2ec81003221057g199f44f5qa37a31b31bb87e79@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Lots there, let's break it down individually:
On Mon, Mar 22, 2010 at 6:38 AM, blast <carlosd2002(at)hotmail(dot)com> wrote:
>
> Hi all,
>
> I need to backup and restore a DB.
> In this particular case the data in the database is not important (strange
> hum...) but only the schema to put new data...
>
> I m thinking use the pg_dump:
>
> pg_dump -c -C -s schema > file.out
>
Almost....
-s says "only dump the structure of the database"
If you want to dump a specific named schema inside the database, you'd
use:
-n <schema>
So, what you end up with is:
pg_dump -c -C -s -n [schema] [database] > file.out
>
> With this i have in file.out the schema, correct?
>
Yes
>
> So, to restore the db from scratch, for example to a new system, what
> should
> i do?
>
psql -d [database] -f file.out
> it automatically creates all users, rolls, permissions etc?How?
>
To create users, you need to dump them from the source db first (pg_dump
doesn't do users)...
so
pg_dumpall -g > users.sql
psql -d [database] -f users.sql
do this BEFORE you do the restore of your objects and all your permissions
etc... will be set.
>
> What is the best way of doing it?
>
>
Good luck!
>
> Many thanks
>
> --
> View this message in context:
> http://old.nabble.com/Backup-Restore-Postgres-DB-tp27984540p27984540.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Mead | 2010-03-22 18:09:20 | Re: Store database users in custom table |
Previous Message | Devrim GÜNDÜZ | 2010-03-22 12:26:59 | Re: pg_resetxlog: command not found |