Re: Moving a PostgreSQL database from one server to another

• To: For users of Fedora Core releases <fedora-list@xxxxxxxxxx>
• Subject: Re: Moving a PostgreSQL database from one server to another
• From: Les Mikesell <les@xxxxxxxxxxxxxxxx>
• Date: Thu, 13 Jan 2005 11:39:07 -0600
• In-reply-to: <[email protected]>
• List-archive: <https://www.redhat.com/archives/fedora-list>
• List-help: <mailto:[email protected]?subject=help>
• List-id: For users of Fedora Core releases <fedora-list.redhat.com>
• List-post: <mailto:[email protected]>
• List-subscribe: <http://www.redhat.com/mailman/listinfo/fedora-list>, <mailto:[email protected]?subject=subscribe>
• List-unsubscribe: <http://www.redhat.com/mailman/listinfo/fedora-list>, <mailto:[email protected]?subject=unsubscribe>
• References: <[email protected]>
• Reply-to: For users of Fedora Core releases <fedora-list@xxxxxxxxxx>

On Thu, 2005-01-13 at 11:28, Rodolfo J. Paiz wrote:

> Anyway, my problem is that I set up and populated a database on my
> notebook, but of course my production website is not *on* my notebook.
> <grin> I move the website files to the server with rsync... but how do I
> move the PostgreSQL database?

Use pg_dump or pg_dumpall. 

-- 
  Les Mikesell
   les@xxxxxxxxxxxxxxxx

• References:
  • Moving a PostgreSQL database from one server to another
    • From: Rodolfo J. Paiz

• Prev by Date: Re: ATI mach64 resolution?
• Next by Date: Re: Nervious wannabe new user asks for advice.
• Previous by thread: Moving a PostgreSQL database from one server to another
• Next by thread: Re: Moving a PostgreSQL database from one server to another
• Index(es):
  • Date
  • Thread