Re: moving a postgreSQL DB, etc.

Reshat Sabiq wrote:
> Hi,
>
> I wonder if it is as easy to move a postgreSQL DB from one machine to
> another (assuming both are using postgre) as dumping it into a file,
> ftping the file, and loading it on the other end.
>
> P.S. Is there an easy way to import an Access DB into postgreSQL?
> P.P.S. Is there a tool similar to Access that provides visual DB
> interface for postgre DBs. P.P.P.S. Is it easy to import a postgreSQL
> into a different one, like Oracle, or MS SQL Server?
>
> Thanks,
> r.

You just dump the database using pg_dump (or pg_dumpall for all db's and
users) to dump the database. If you have just made a plain dump you can just
use psql to restore.
http://pgadmin.postgresql.org
site has a tool called pgMigration available for download. This should help.
I've not transfered data the other way, but if you use copy to get the data
to a tab seperated file then it should be ok, or just link through ODBC and
suck up the data directly (I think SQL Server has a tool to do this).
hth,
- Stuart