Move empty copy of db from windows to linux -
i have postgresql db on windows 7 machine. need create copy of on linux mint machine.
is there way create template (or something?) existing db on windows machine, use create same db on linux machine (with no data).
when this, primary keys each table restart @ 1 in new db or have manually that?
pg_dump --schema-only --host=database_ip --username=username datbase_name > schema.sql
then run schema.sql
on linux mint machine.
Comments
Post a Comment