Hi,
pvcb> I tried to use pg_dump + pg_restore, but I don't know the correct usage of
pvcb> them under Win 9X/NT. I'd appreciate any tips in that matter.
create a dump file with pg_dump like
pg_dump -h sourcehost dbname > outputfile.dump
then connect to the other machine and create the new database
psql -h desthost -d template1
create database new_dbname;
exit and connect now with the generated datafile
psql -h desthost -d new_dbname < outputfile.dump
I tried this way and it works.
regards Michael Timme
--
Michael Timme
mailto:[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
