This is a discussion on data transfer/migrate from win to linux within the pgsql Admins forums, part of the PostgreSQL category; --> Hello. After looking for a way to transfer PostgreSQL/PostGIS data from windowsXP to linux (Ubuntu 7.10), I did not ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello. After looking for a way to transfer PostgreSQL/PostGIS data from windowsXP to linux (Ubuntu 7.10), I did not find it. Please, does anyone know an easy way or free tool for it. Thanks in advance Best regards Antonio |
| ||||
| > After looking for a way to transfer PostgreSQL/PostGIS data from windowsXP > to linux (Ubuntu 7.10), I did not find it. > Please, does anyone know an easy way or free tool for it. Are pg_dump/pg_restore somehow insufficient for your needs? (http://www.postgresql.org/docs/curre...ve/backup.html) You'll have to dump your database to a file, transfer said file to your linux server, and then restore the database (I don't think you can directly pipe the output, but I could be wrong). You'll also have to make sure that PostGIS is installed on the linux side, but this should work modulo any major version discrepancies. If you run into an error while doing this, let us know. Peter ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |