Re: [pgadmin-support] Copying a database

2010-08-13 Thread Ron Gafron
Thanks for the information. Much appreciated. Ron On 8/13/2010 4:55 AM, Guillaume Lelarge wrote: Le 13/08/2010 11:38, Raymond O'Donnell a écrit : On 13/08/2010 06:32, Guillaume Lelarge wrote: If you want a plain (SQL) dump, you have to tick the "Only schema" checkbox before doing the dump.

Re: [pgadmin-support] Copying a database

2010-08-13 Thread Guillaume Lelarge
Le 13/08/2010 11:38, Raymond O'Donnell a écrit : > On 13/08/2010 06:32, Guillaume Lelarge wrote: > >> If you want a plain (SQL) dump, you have to tick the "Only schema" >> checkbox before doing the dump. You don't have anything special to on >> the restore step. > > It may be worth adding to this

Re: [pgadmin-support] Copying a database

2010-08-13 Thread Raymond O'Donnell
On 13/08/2010 06:32, Guillaume Lelarge wrote: > If you want a plain (SQL) dump, you have to tick the "Only schema" > checkbox before doing the dump. You don't have anything special to on > the restore step. It may be worth adding to this that you need to restore a plain dump via psql on the comma

Re: [pgadmin-support] Copying a database

2010-08-12 Thread Guillaume Lelarge
Le 13/08/2010 01:06, Ron Gafron a écrit : > 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 s

Re: [pgadmin-support] Copying a database

2010-08-12 Thread Josh Berkus
On 8/12/10 4:06 PM, Ron Gafron wrote: > > 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.

[pgadmin-support] Copying a database

2010-08-12 Thread Ron Gafron
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