Moving a PostgreSQL database from one server to another

From: Rodolfo J. Paiz (rpaiz_at_simpaticus.com)
Date: 01/13/05

  • Next message: Maxim Eremeev: "Re: Nervious wannabe new user asks for advice." 
    To: fedora-list@redhat.com
Date: Thu, 13 Jan 2005 11:28:52 -0600

    Hi, everyone:

    I'll happily accept a pointer to an FM I can R, but haven't found it
    yet. I'm just moving to PostgreSQL from MySQL, and so far I really
    really like it. The learning curve for a total newbie has been very easy
    thus far (easier than MySQL by a good chunk), and I simply love the fact
    that I finally have referential integrity, transactions, and stored
    procedores in an open-source database.

    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?

    I guess I need a backup/restore or an export/import... but for some
    bizarre reason I haven't found them yet. Admittedly I've only been
    looking for about an hour (and I keep getting sidetracked learning other
    stuff), but I thought I'd send a quick email to the One True List to see
    if anyone can save me some time, since I'm on a deadline.

    Thanks, y'all... 

    -- 
Rodolfo J. Paiz <rpaiz@simpaticus.com>
-- 
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
  • Next message: Maxim Eremeev: "Re: Nervious wannabe new user asks for advice."

    Relevant Pages

    • Re: Python, xml, databases, ...
      ... I think you want to be clear whether you want a database or not. ... Any machine can run a service (such as MySQL or PostgreSQL), ... both MySQL and PostgreSQL rely on the Cygwin dll. ...
      (comp.lang.python)
    • Re: Windows Ada database support.
      ... >>for example) promote the use of Object IDs (basically Row IDs). ... >>Still others don't support the concept at all (MySQL). ... >>within certain database design restrictions). ... PostgreSQL uses an API that opens/creates etc. and returns ...
      (comp.lang.ada)
    • Re: Looking for a database
      ... >> The obvious choices on fedora will be MySQL and postgresql ... > If I was to chose between Postgresql and another free database it would ... > be between Postgresql and Firebird, ...
      (Fedora)
    • Re: OT: give advice to MSAccess user
      ... On Wed, 2005-03-16 at 03:55, Duncan Lithgow wrote: ... > database - currently MSAccess. ... I don't know if there is a front end for MySQl or not. ... You may want to take a look at Postgresql as well. ...
      (Fedora)
    • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
      ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
      (comp.lang.php)