On Thu, 2009-05-28 at 16:43 +0100, Grzegorz Jaśkiewicz wrote: > On Thu, May 28, 2009 at 4:24 PM, <inf200...@ucf.edu.cu> wrote: > > hi, sorry my english > > I need to copy a data base from windows to linux, how can I save my data > > base from windows with pg_dump, and where the file is?????? > > and after how can I create the data base in linux without graphic enviroment > > , just text mode, with commands > > yes, pg_dump is just the tool for it. > > when you run pg_dump., you decide where the file is going to be > stored, by redirecting output to a file: > > pg_dump database > C:\tmp\foo.sql >
take a look at: a) the --clean option and also b) pg_dumpall depending on what exactly you have in hands these options would be helpfull. Joao > > -- > GJ > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
