moving database to diff. server
| От | Paul Keyes |
|---|---|
| Тема | moving database to diff. server |
| Дата | |
| Msg-id | 20050622200224.67912.qmail@web33413.mail.mud.yahoo.com обсуждение |
| Ответы |
Re: moving database to diff. server
Re: moving database to diff. server |
| Список | pgsql-admin |
Hi All, 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? I assume I've got to make it from the old server/existing database but am unclear about how. Any advice is greatly appreciated. Thanks, Paul __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
В списке pgsql-admin по дате отправления: