this seems strangely to be an extremely complex task. I've tried all kinds
of backup/restore (compressed, tared, plain) with all possible options and
combination of options. I cannot seem to be able to backup a PostgreSQL
satabase on my server and restore it on another server. I always get errors
during the restore procedure.
I've even tried to zip the entire database folder, but no luck. I'm stuck
with this problem. Why is it so difficult to move a database from one server
to another? Many other RDBMS just let you copy the database file (or dir) to
the new machine and import it.
Please help, this feature is extremely important for my development.
Thank you in advance,
pgsql-hackers-win32 by date
|Next:||From: Tom Lane||Date: 2005-06-22 22:29:09|
|Subject: Re: How to move a DB from one server to another... |
|Previous:||From: Magnus Hagander||Date: 2005-06-10 11:26:53|
|Subject: Re: Adding a database and login|