Обсуждение: pg_dump & Win 9X/NT

Hi,

Does anyone know how can I make a copy of a database to another machine
(I'm using Postgres under Win95)?

I tried to use pg_dump + pg_restore, but I don't know the correct usage of
them under Win 9X/NT. I'd appreciate any tips in that matter.

Thanks in advance.


Paulo

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:mit@e-mit.de