And to restore it.. Can I use pg_restore -d new_db_name ?? -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@xxxxxxxxxxxx] Sent: sexta-feira, 16 de julho de 2010 14:47 To: ENGEMANN, DAYSE; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: How to move a database from HP server to Linux Server that had already one database. "ENGEMANN, DAYSE" <dayse.engemann@xxxxxx> wrote: > I have a HP Server with a postgres database, and I need to transfer it > to another server > What is the easy way to do it? pg_dump | psql -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin