| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Paul Keyes <paul_s_keyes(at)yahoo(dot)ca> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: moving database to diff. server |
| Date: | 2005-06-28 06:09:59 |
| Message-ID: | 20050628060959.GA18635@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Jun 22, 2005 at 04:02:24PM -0400, Paul Keyes wrote:
>
> I'm confused about one aspect of backing up and moving
> a database to a different server.
> I've used pg_dump to dump the database and moved he
> resulting file to the new server, where Postgresql is
> istalled and configured (as far as I know).
> But I know that before I run psql on the backup I have
> to create the database with something like (createdb
> -T template0 dbname). How do I make that template0?
template0 is created by initdb; you shouldn't have to create it
manually.
http://www.postgresql.org/docs/8.0/static/manage-ag-templatedbs.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KÖPFERL Robert | 2005-06-28 08:24:58 | Re: How to compare the schemas ? |
| Previous Message | Tom Arthurs | 2005-06-28 05:03:36 | Re: moving database to diff. server |