Re: pg_dump & Win 9X/NT - Mailing list pgsql-admin

From Michael Timme
Subject Re: pg_dump & Win 9X/NT
Date
Msg-id 895435430.20010913123135@e-mit.de
Whole thread Raw
In response to pg_dump & Win 9X/NT  (pmiranda@vm.com.br)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Another WAL question (sort of)
Next
From: "Corn"
Date:
Subject: Re: using multiple partitions for a single table