From: | Ron Gafron <rgafron(at)sbcglobal(dot)net> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Copying a database |
Date: | 2010-08-12 23:06:16 |
Message-ID: | 4C647E68.7090908@sbcglobal.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Good day all,
As a relative newbie to Postgres, I am looking for the "best way" to
make a copy of a database I am using. Is there a "standard way" to use
pgAdmin to do this? I've seen a number of posts using the command line
to do this, but so far, about all I've seen using pgAdmin are posts
about using the backup/restore routine to do this, but people seem to
have trouble with this at times.
All I'm interested in copying is the database structure at this point,
and I think I can see in pgAdmin how to do this with the backup. So,
would the steps be.....
1. Create the database backup.
2. Create a new, empty database with a new name.
3. Restore the backup to the new, empty database?
Thanks for any guidance you can provide, and have a good day.
Ron
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2010-08-12 23:15:55 | Re: Copying a database |
Previous Message | Franz Fritsche | 2010-08-11 00:20:40 | PgAdmin Crash |